DBA Data[Home] [Help]

APPS.PAY_PYAURECD_XMLP_PKG dependencies on FND_GLOBAL

Line 12: and request_id= FND_GLOBAL.conc_request_id;

8: BEGIN
9: /*added as fix:*/
10: select concurrent_program_name into Rep_name from fnd_concurrent_programs fc,FND_CONCURRENT_REQUESTS fn
11: where fn.concurrent_program_id=fc.concurrent_program_id
12: and request_id= FND_GLOBAL.conc_request_id;
13: if Rep_name='PYAUREPSR_XML' then
14: select
15: SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
16: SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2)),

Line 60: where request_id= FND_GLOBAL.conc_request_id;

56: LP_LST_YEAR_TERM,
57: LP_DELETE_ACTIONS
58:
59: from FND_CONCURRENT_REQUESTS
60: where request_id= FND_GLOBAL.conc_request_id;
61:
62: end if;
63: if Rep_name='PYAURECD_XML' then
64: select

Line 106: where request_id= FND_GLOBAL.conc_request_id;

102: LP_SORT_ORDER_4,
103: LP_DELETE_ACTIONS
104:
105: from FND_CONCURRENT_REQUESTS
106: where request_id= FND_GLOBAL.conc_request_id;
107:
108: end if;
109:
110: LP_START_DATE := to_date(LP_START_DATE_D,'YYYY/MM/DD');

Line 116: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

112: LP_PERIOD_END_DATE := to_date(LP_PERIOD_END_DATE_D,'YYYY/MM/DD');
113: LP_START_DATE_D:=to_char(LP_START_DATE,'DD-MON-YYYY');
114: LP_END_DATE_D:=to_char(LP_END_DATE,'DD-MON-YYYY');
115: /*fix ends*/
116: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
117: ORDERBY_CLAUSE := ' ';
118: IF (P_PAYSUM_FLAG IS NULL) THEN
119: P_PAYSUM_FLAG := 'N';
120: END IF;