[Home] [Help]
28: CURSOR C_PURGE_HEADERS IS
29: SELECT
30: CSH.STATEMENT_HEADER_ID
31: FROM
32: CE_STATEMENT_HEADERS CSH
33: WHERE CSH.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
34: ,BANK_ACCOUNT_ID)
35: AND CSH.BANK_ACCOUNT_ID IN (
36: SELECT
46: AND not exists (
47: SELECT
48: 1
49: FROM
50: CE_STATEMENT_HEADERS SH,
51: CE_STATEMENT_LINES SL,
52: CE_STATEMENT_RECONCILS_ALL SR
53: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
54: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
445: CREATION_DATE,
446: LAST_UPDATED_BY,
447: LAST_UPDATE_DATE
448: FROM
449: CE_STATEMENT_HEADERS CSH
450: WHERE CSH.BANK_ACCOUNT_ID = P_BANK_ACCOUNT
451: AND CSH.STATEMENT_DATE >= NVL(P_STATEMENT_DATE_FROM
452: ,CSH.STATEMENT_DATE)
453: AND CSH.STATEMENT_DATE <= NVL(P_STATEMENT_DATE_TO1
455: AND not exists (
456: SELECT
457: 1
458: FROM
459: CE_STATEMENT_HEADERS SH,
460: CE_STATEMENT_LINES SL,
461: CE_STATEMENT_RECONCILS_ALL SR
462: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
463: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
566: CREATION_DATE,
567: LAST_UPDATED_BY,
568: LAST_UPDATE_DATE
569: FROM
570: CE_STATEMENT_HEADERS CSH
571: WHERE CSH.BANK_ACCOUNT_ID IN (
572: SELECT
573: ABA.BANK_ACCOUNT_ID
574: FROM
581: AND not exists (
582: SELECT
583: 1
584: FROM
585: CE_STATEMENT_HEADERS SH,
586: CE_STATEMENT_LINES SL,
587: CE_STATEMENT_RECONCILS_ALL SR
588: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
589: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
697: CREATION_DATE,
698: LAST_UPDATED_BY,
699: LAST_UPDATE_DATE
700: FROM
701: CE_STATEMENT_HEADERS CSH
702: WHERE CSH.STATEMENT_DATE >= NVL(P_STATEMENT_DATE_FROM
703: ,CSH.STATEMENT_DATE)
704: AND CSH.STATEMENT_DATE <= NVL(P_STATEMENT_DATE_TO1
705: ,CSH.STATEMENT_DATE)
706: AND not exists (
707: SELECT
708: 1
709: FROM
710: CE_STATEMENT_HEADERS SH,
711: CE_STATEMENT_LINES SL,
712: CE_STATEMENT_RECONCILS_ALL SR
713: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
714: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
900: INTO
901: X_HEADER_ID;
902: LOOP
903: EXIT WHEN C_PURGE_HEADERS%NOTFOUND;
904: DELETE FROM CE_STATEMENT_HEADERS
905: WHERE STATEMENT_HEADER_ID = X_HEADER_ID;
906: PURGE_HEADERS := PURGE_HEADERS + SQL%ROWCOUNT;
907: OPEN C_PURGE_LINES;
908: FETCH C_PURGE_LINES
1027: CREATION_DATE,
1028: LAST_UPDATED_BY,
1029: LAST_UPDATE_DATE
1030: FROM
1031: CE_STATEMENT_HEADERS_INT CSH
1032: WHERE NVL(CSH.BANK_BRANCH_NAME
1033: ,C_BANK_BRANCH_NAME) IN (
1034: SELECT
1035: BB.BANK_BRANCH_NAME
1166: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1167: SELECT
1168: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1169: FROM
1170: CE_STATEMENT_HEADERS_INT CSH
1171: WHERE NVL(CSH.BANK_BRANCH_NAME
1172: ,C_BANK_BRANCH_NAME) IN (
1173: SELECT
1174: BB.BANK_BRANCH_NAME
1207: ,'T') )
1208: AND NVL(CSH.INTRA_DAY_FLAG
1209: ,'N') = 'N' );
1210: C_PURGE_INF_LINES := SQL%ROWCOUNT;
1211: DELETE FROM CE_STATEMENT_HEADERS_INT CSH
1212: WHERE NVL(CSH.BANK_BRANCH_NAME
1213: ,C_BANK_BRANCH_NAME) IN (
1214: SELECT
1215: BB.BANK_BRANCH_NAME
1754: LAST_UPDATED_BY,
1755: LAST_UPDATE_DATE,
1756: INTRA_DAY_FLAG
1757: FROM
1758: CE_STATEMENT_HEADERS_INT CSH
1759: WHERE NVL(CSH.BANK_BRANCH_NAME
1760: ,C_BANK_BRANCH_NAME) IN (
1761: SELECT
1762: BB.BANK_BRANCH_NAME
1891: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1892: SELECT
1893: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1894: FROM
1895: CE_STATEMENT_HEADERS_INT CSH
1896: WHERE NVL(CSH.BANK_BRANCH_NAME
1897: ,C_BANK_BRANCH_NAME) IN (
1898: SELECT
1899: BB.BANK_BRANCH_NAME
1931: ,RECORD_STATUS_FLAG
1932: ,'T') )
1933: AND CSH.INTRA_DAY_FLAG = 'Y' );
1934: C_PURGE_INF_LINES2 := SQL%ROWCOUNT;
1935: DELETE FROM CE_STATEMENT_HEADERS_INT CSH
1936: WHERE NVL(CSH.BANK_BRANCH_NAME
1937: ,C_BANK_BRANCH_NAME) IN (
1938: SELECT
1939: BB.BANK_BRANCH_NAME