6: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
7:
8: SELECT SUBSTR(ARGUMENT1,INSTR(ARGUMENT1,'=',1,1)+1)
9: INTO P_CONC_REQUEST_ID_RX
10: FROM FND_CONCURRENT_REQUESTS
11: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
12:
13: SELECT SUBSTR(ARGUMENT2,INSTR(ARGUMENT2,'=',1,1)+1)
14: INTO P_BOOK1
11: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
12:
13: SELECT SUBSTR(ARGUMENT2,INSTR(ARGUMENT2,'=',1,1)+1)
14: INTO P_BOOK1
15: FROM FND_CONCURRENT_REQUESTS
16: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
17:
18: SELECT SUBSTR(ARGUMENT2,INSTR(ARGUMENT2,'=',1,1)+1)
19: INTO P_BOOK1
16: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
17:
18: SELECT SUBSTR(ARGUMENT2,INSTR(ARGUMENT2,'=',1,1)+1)
19: INTO P_BOOK1
20: FROM FND_CONCURRENT_REQUESTS
21: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
22:
23: SELECT SUBSTR(ARGUMENT3,INSTR(ARGUMENT3,'=',1,1)+1)
24: INTO P_CURRENCY1
21: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
22:
23: SELECT SUBSTR(ARGUMENT3,INSTR(ARGUMENT3,'=',1,1)+1)
24: INTO P_CURRENCY1
25: FROM FND_CONCURRENT_REQUESTS
26: WHERE REQUEST_ID =P_CONC_REQUEST_ID;
27: DECLARE
28: L_CURRENCY_CODE VARCHAR2(15);
29: L_PRECISION NUMBER(15);
62: CR.CONCURRENT_PROGRAM_ID
63: INTO
64: L_CONC_PROGRAM_ID
65: FROM
66: FND_CONCURRENT_REQUESTS CR
67: WHERE CR.PROGRAM_APPLICATION_ID = 140
68: AND CR.REQUEST_ID = P_CONC_REQUEST_ID;
69: SELECT
70: CP.USER_CONCURRENT_PROGRAM_NAME