APPS.BOM_CSTRPCRE_XMLP_PKG dependencies on FND_CONCURRENT

Line 123: FND_CONCURRENT_PROGRAMS

119: SELECT
120: CONCURRENT_PROGRAM_ID
121: INTO L_CSTRPCRE_PROG_ID
122: FROM
123: FND_CONCURRENT_PROGRAMS
124: WHERE APPLICATION_ID = 702
125: AND CONCURRENT_PROGRAM_NAME = 'CSTRPCRE';
126: LOOP
127: L_STMT_NUM := 60;

Line 149: FND_CONCURRENT_REQUESTS FCR

145: SELECT
146: MIN(FCR.REQUEST_ID)
147: INTO L_OTHER_REQUEST_ID
148: FROM
149: FND_CONCURRENT_REQUESTS FCR
150: WHERE FCR.PROGRAM_APPLICATION_ID = 702
151: AND FCR.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
152: AND FCR.ARGUMENT1 = TO_CHAR(P_ORG_ID)
153: AND FCR.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)

Line 159: FND_CONCURRENT_REQUESTS FCR2

155: AND FCR.ACTUAL_START_DATE = (
156: SELECT
157: MIN(FCR2.ACTUAL_START_DATE)
158: FROM
159: FND_CONCURRENT_REQUESTS FCR2
160: WHERE FCR2.PROGRAM_APPLICATION_ID = 702
161: AND FCR2.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
162: AND FCR2.ARGUMENT1 = TO_CHAR(P_ORG_ID)
163: AND FCR2.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)

Line 172: L_RETURN_VAL := FND_CONCURRENT.WAIT_FOR_REQUEST(L_OTHER_REQUEST_ID

168: ELSE
169: L_STMT_NUM := 90;
170: /*SRW.MESSAGE(0
171: ,'waiting on summarization request ' || L_OTHER_REQUEST_ID)*/NULL;
172: L_RETURN_VAL := FND_CONCURRENT.WAIT_FOR_REQUEST(L_OTHER_REQUEST_ID
173: ,10
174: ,0
175: ,L_PHASE
176: ,L_STATUS

Line 267: FND_CONCURRENT_PROGRAMS

263: SELECT
264: ENABLE_TRACE
265: INTO L_ENABLE_TRACE
266: FROM
267: FND_CONCURRENT_PROGRAMS
268: WHERE CONCURRENT_PROGRAM_NAME = 'CSTRPCRE'
269: AND APPLICATION_ID = 702;
270: L_STMT_NUM := 180;
271: SELECT