DBA Data[Home] [Help]

APPS.PA_PACCINTG_XMLP_PKG dependencies on PA_ALLOC_RUN

Line 47: PA_ALLOC_RUN.INIT_WHO_COLS;

43: RAISE INIT_FAILURE;
44: END IF;
45: /*SRW.MESSAGE('100'
46: ,'BEFORE CALLING THE who cals')*/NULL;
47: PA_ALLOC_RUN.INIT_WHO_COLS;
48: IF P_FROM_PROJECT_ID IS NOT NULL THEN
49: SELECT
50: SEGMENT1
51: INTO P_FROM_PROJ_NUM

Line 149: L_RUN_STATUS_CODE PA_ALLOC_RUNS_ALL.RUN_STATUS%TYPE;

145: PROCEDURE PROCESS_FAILED_RUN IS
146: NUMBER_OF_MESSAGES NUMBER;
147: MESSAGE_BUF VARCHAR2(2000);
148: L_PURGEABLE_FLAG PA_TRANSACTION_SOURCES.PURGEABLE_FLAG%TYPE;
149: L_RUN_STATUS_CODE PA_ALLOC_RUNS_ALL.RUN_STATUS%TYPE;
150: BEGIN
151: /*SRW.MESSAGE(1
152: ,'In process failerd run')*/NULL;
153: CP_RET_STS := 'E';

Line 199: PA_ALLOC_RUNS_ALL

195: END;
196: IF CP_RET_STS = 'E' THEN
197: IF ((P_MODE = 'R') OR (P_MODE = 'G' AND P_AUTO_RELEASE = 'Y')) THEN
198: UPDATE
199: PA_ALLOC_RUNS_ALL
200: SET
201: RELEASE_REQUEST_ID = NULL
202: WHERE RUN_ID = P_RUN_ID;
203: END IF;