ضرورى يا جماعه وبأقصى سرعه جزاكم الله كل خير انا عاوز انادى تقرير معمول  من فورمه  فى apps 12 وليس 11i

CREATE OR REPLACE PROCEDURE APPS.RUN_REQ(P_USER_ID IN NUMBER,
                    P_RESP_ID IN NUMBER,
                    P_APP_ID  IN NUMBER,
                    P_NAME    IN VARCHAR2,
                    L_REQUEST_ID  Out number,
                    P_1       IN VARCHAR2,
                    P_2       IN VARCHAR2,
                    P_3       IN VARCHAR2 DEFAULT NULL,
                    P_4       IN VARCHAR2 DEFAULT NULL,
                    P_5       IN VARCHAR2 DEFAULT NULL,
                    P_6       IN VARCHAR2 DEFAULT NULL,
                    P_7       IN VARCHAR2 DEFAULT NULL,
                    P_8       IN VARCHAR2 DEFAULT NULL,
                    P_9       IN VARCHAR2 DEFAULT NULL,
                    P_10      IN VARCHAR2 DEFAULT NULL,
                    P_11      IN VARCHAR2 DEFAULT NULL,
                    P_12      IN VARCHAR2 DEFAULT NULL,
                    P_13      IN VARCHAR2 DEFAULT NULL,
                    P_14      IN VARCHAR2 DEFAULT NULL,
                    P_15      IN VARCHAR2 DEFAULT NULL,
                    P_16      IN VARCHAR2 DEFAULT NULL,
                    P_17      IN VARCHAR2 DEFAULT NULL,
                    P_18      IN VARCHAR2 DEFAULT NULL,
                    P_19      IN VARCHAR2 DEFAULT NULL,
                    P_20      IN VARCHAR2 DEFAULT NULL
                    ) IS
 
    L_BOOL       BOOLEAN;
  --  L_REQUEST_ID NUMBER;
 
    L_APPL_NAME     VARCHAR2(240);
    L_TEMPLATE_CODE VARCHAR2(240);
    L_TEMPLATE_LANG VARCHAR2(240);
    L_TEMPLATE_TERR VARCHAR2(240);
    L_OUTPUT_FORMAT VARCHAR2(150);
    L_PRINTER       VARCHAR2(150);
 
    P_APP_CODE VARCHAR2(250);
 
    V_SESSION_ID INTEGER := USERENV('sessionid');
    
    l_boolean    boolean;
 
  BEGIN
 
   
    FND_GLOBAL.APPS_INITIALIZE(USER_ID      => P_USER_ID,
                               RESP_ID      => P_RESP_ID,
                               RESP_APPL_ID => P_APP_ID);
 
    COMMIT;
 

 
    SELECT APP.APPLICATION_SHORT_NAME
      INTO P_APP_CODE
      FROM FND_APPLICATION APP
     WHERE APP.APPLICATION_ID = P_APP_ID;
     
     l_boolean := fnd_request.set_mode (TRUE);

 
    L_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST(P_APP_CODE,
                                               P_NAME,
                                               '',
                                               SYSDATE,
                                               FALSE,
                                               P_1,
                                               P_2,
                                               P_3,
                                               P_4,
                                               P_5,
                                               P_6,
                                               P_7,
                                               P_8,
                                               P_9,
                                               P_10,
                                               P_11,
                                               P_12,
                                               P_13,
                                               P_14,
                                               P_15,
                                               P_16,
                                               P_17,
                                               P_18,
                                               P_19,
                                               P_20,
                                               chr(0),
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '',
                                               '');
 
    COMMIT;
    
    if (L_REQUEST_ID = 0)
then
/* Handle submission error */
FND_MESSAGE.RAISE_ERROR;
end if;
  END;

شكرا اخى جزاك الله كل خير ....

بس انا عندى استفسار ايه البراميتر الموجوده دى فى البروسيدر وبعدين انا هكتب اسم التقرير وال Path بتاعه فين

هي الباراميترات اللي بدك تمررها للريبورت

بالنسبة لاسم التقرير هو نفسه الشورت نيم

بتحطه و بتحط على اي ريسبونسبليتي لازم يرن 

مسار الملف مش ضروري لانه لما تحط application_id  هو بيعرف لوحده على اي فولدر مثلا تقرير hr على per

لما تحط الاي دي للابلكيشن 800 هو بيعرف انه دا hrوموجود على per