DBA Data[Home] [Help]

APPS.WMS_WMSCPTYR_XMLP_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 29: FND_CONCURRENT_REQUESTS CR

25: CP.USER_CONCURRENT_PROGRAM_NAME
26: INTO L_REPORT_NAME
27: FROM
28: FND_CONCURRENT_PROGRAMS_VL CP,
29: FND_CONCURRENT_REQUESTS CR
30: WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
31: AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
32: AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
33: P_REPORT_NAME := L_REPORT_NAME;

Line 47: FND_CONCURRENT_REQUESTS

43: SAVE_OUTPUT_FLAG,
44: PRINTER
45: INTO P_REQUEST_DATE,P_ACTUAL_START_DATE,P_SAVE_OUTPUT_FLAG,P_PRINTER
46: FROM
47: FND_CONCURRENT_REQUESTS
48: WHERE REQUEST_ID = P_CONC_REQUEST_ID;
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: NULL;

Line 58: FND_CONCURRENT_REQUESTS FCR,

54: SELECT
55: APPLICATION_NAME
56: INTO P_APPLICATION
57: FROM
58: FND_CONCURRENT_REQUESTS FCR,
59: FND_APPLICATION_VL FAV
60: WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
61: AND FAV.APPLICATION_ID = FCR.PROGRAM_APPLICATION_ID;
62: EXCEPTION

Line 71: FND_CONCURRENT_REQUESTS FCR,

67: SELECT
68: RESPONSIBILITY_NAME
69: INTO P_RESPONSIBILITY
70: FROM
71: FND_CONCURRENT_REQUESTS FCR,
72: FND_RESPONSIBILITY_VL FRV
73: WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
74: AND FRV.RESPONSIBILITY_ID = FCR.RESPONSIBILITY_ID;
75: EXCEPTION