DBA Data[Home] [Help]

APPS.PSB_PSBRPERR_XMLP_PKG dependencies on PSB_ERROR_REQUESTS_V

Line 28: PSB_ERROR_REQUESTS_V

24: SOURCE_PROCESS_MEANING,
25: PROCESS_NAME
26: INTO L_PROCESS_ID,P_SOURCE_PROCESS,L_SOURCE_PROCESS,L_PROCESS_NAME
27: FROM
28: PSB_ERROR_REQUESTS_V
29: WHERE CONCURRENT_REQUEST_ID = P_CONC_ID;
30: CP_CONC_ID := L_CONC_ID;
31: CP_SOURCE_PROCESS := L_SOURCE_PROCESS;
32: CP_NAME := L_PROCESS_NAME;

Line 65: PSB_ERROR_REQUESTS_V

61: SOURCE_PROCESS_MEANING,
62: PROCESS_NAME
63: INTO L_SOURCE_PROCESS,L_PROCESS_NAME
64: FROM
65: PSB_ERROR_REQUESTS_V
66: WHERE PROCESS_ID = P_PROCESS_ID
67: AND SOURCE_PROCESS = P_SOURCE_PROCESS;
68: CP_PROCESS_ID := TO_CHAR(P_PROCESS_ID);
69: CP_SOURCE_PROCESS := L_SOURCE_PROCESS;

Line 88: PSB_ERROR_REQUESTS_V

84: PROCESS_ID,
85: PROCESS_NAME
86: INTO L_PROCESS_ID,L_PROCESS_NAME
87: FROM
88: PSB_ERROR_REQUESTS_V
89: WHERE CONCURRENT_REQUEST_ID = P_CONC_ID;
90: END IF;
91: IF (P_SOURCE_PROCESS <> 'BUDGET_REVISION') AND L_PROCESS_ID <> P_PROCESS_ID THEN
92: SELECT