DBA Data[Home] [Help]

APPS.PA_PACCINTG_XMLP_PKG dependencies on PA_TRANSACTION_SOURCES

Line 148: L_PURGEABLE_FLAG PA_TRANSACTION_SOURCES.PURGEABLE_FLAG%TYPE;

144:
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;

Line 171: L_PURGEABLE_FLAG PA_TRANSACTION_SOURCES.PURGEABLE_FLAG%TYPE;

167: NULL;
168: END PROCESS_FAILED_RUN;
169:
170: FUNCTION AFTERREPORT RETURN BOOLEAN IS
171: L_PURGEABLE_FLAG PA_TRANSACTION_SOURCES.PURGEABLE_FLAG%TYPE;
172: BEGIN
173: BEGIN
174: /*SRW.MESSAGE('2'
175: ,'In after report trigger with p_mode ' || P_MODE)*/NULL;

Line 180: PA_TRANSACTION_SOURCES

176: SELECT
177: PURGEABLE_FLAG
178: INTO L_PURGEABLE_FLAG
179: FROM
180: PA_TRANSACTION_SOURCES
181: WHERE TRANSACTION_SOURCE = 'Capitalized Interest';
182: IF ((P_MODE = 'R') OR (P_MODE = 'G' AND P_AUTO_RELEASE = 'Y')) THEN
183: IF (L_PURGEABLE_FLAG = 'Y') THEN
184: DELETE FROM PA_TRANSACTION_INTERFACE