APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_HEADERS

Line 213: CE_ARCH_HEADERS;

209: COUNT(*)
210: INTO
211: COUNT_HEADERS
212: FROM
213: CE_ARCH_HEADERS;
214: SELECT
215: COUNT(*)
216: INTO
217: COUNT_LINES

Line 297: DELETE FROM CE_ARCH_HEADERS;

293: ,'N') = 'Y' );
294: END IF;
295: END IF;
296: IF (COUNT_HEADERS > 0) THEN
297: DELETE FROM CE_ARCH_HEADERS;
298: END IF;
299: IF (COUNT_LINES > 0) THEN
300: DELETE FROM CE_ARCH_LINES;
301: END IF;

Line 362: INSERT INTO CE_ARCH_HEADERS

358: IF (P_STATEMENT_TYPE in ('BOTH','PREVIOUS')) THEN
359: IF (P_OBJECTS in ('BOTH','STATEMENT')) THEN
360: IF (P_OPTION in ('BOTH')) THEN
361: IF (P_BANK_ACCOUNT IS NOT NULL) THEN
362: INSERT INTO CE_ARCH_HEADERS
363: (STATEMENT_COMPLETE_FLAG
364: ,DOC_SEQUENCE_ID
365: ,DOC_SEQUENCE_VALUE
366: ,STATEMENT_HEADER_ID

Line 483: INSERT INTO CE_ARCH_HEADERS

479: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
480: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
481: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
482: ELSIF (P_BANK_BRANCH IS NOT NULL) THEN
483: INSERT INTO CE_ARCH_HEADERS
484: (STATEMENT_COMPLETE_FLAG
485: ,DOC_SEQUENCE_ID
486: ,DOC_SEQUENCE_VALUE
487: ,STATEMENT_HEADER_ID

Line 614: INSERT INTO CE_ARCH_HEADERS

610: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
611: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
612: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
613: ELSE
614: INSERT INTO CE_ARCH_HEADERS
615: (STATEMENT_COMPLETE_FLAG
616: ,DOC_SEQUENCE_ID
617: ,DOC_SEQUENCE_VALUE
618: ,STATEMENT_HEADER_ID

Line 823: CE_ARCH_HEADERS );

819: WHERE STATEMENT_HEADER_ID IN (
820: SELECT
821: STATEMENT_HEADER_ID
822: FROM
823: CE_ARCH_HEADERS );
824: C_ARCHIVE_STAT_LINES := SQL%ROWCOUNT;
825: INSERT INTO CE_ARCH_RECONCILIATIONS_ALL
826: (STATEMENT_LINE_ID
827: ,REFERENCE_TYPE