eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_ARC_PUR_CANDIDATES

Line 764: FROM igc_arc_pur_candidates;

760: -- --------------------------------------------------------------------
761: -- Cleanup the candidate list table before exiting.
762: -- --------------------------------------------------------------------
763: DELETE
764: FROM igc_arc_pur_candidates;
765:
766: -- --------------------------------------------------------------------
767: -- Commit the cleanup that has been performed.
768: -- --------------------------------------------------------------------

Line 1008: FROM igc_arc_pur_candidates ICV

1004: CONVERSION_RATE
1005: FROM igc_cc_mc_headers CMH
1006: WHERE CMH.cc_header_id IN
1007: ( SELECT ICV.cc_header_id
1008: FROM igc_arc_pur_candidates ICV
1009: );
1010:
1011: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1012: IF (g_debug_mode = 'Y') THEN

Line 1042: FROM igc_arc_pur_candidates ICV

1038: CONVERSION_RATE
1039: FROM igc_cc_mc_header_history CMHH
1040: WHERE CMHH.cc_header_id IN
1041: ( SELECT ICV.cc_header_id
1042: FROM igc_arc_pur_candidates ICV
1043: );
1044:
1045: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1046: IF (g_debug_mode = 'Y') THEN

Line 1082: FROM igc_arc_pur_candidates ICV1

1078: ( SELECT ACLH.cc_acct_line_id
1079: FROM igc_cc_acct_line_history ACLH
1080: WHERE ACLH.cc_header_id IN
1081: ( SELECT ICV1.cc_header_id
1082: FROM igc_arc_pur_candidates ICV1
1083: )
1084: )
1085: OR CML.cc_acct_line_id IN
1086: ( SELECT ACL.cc_acct_line_id

Line 1090: FROM igc_arc_pur_candidates ICV2

1086: ( SELECT ACL.cc_acct_line_id
1087: FROM igc_cc_acct_lines ACL
1088: WHERE ACL.cc_header_id IN
1089: ( SELECT ICV2.cc_header_id
1090: FROM igc_arc_pur_candidates ICV2
1091: )
1092: );
1093:
1094: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1134: FROM igc_arc_pur_candidates ICV1

1130: ( SELECT ACLH.cc_acct_line_id
1131: FROM igc_cc_acct_line_history ACLH
1132: WHERE ACLH.cc_header_id IN
1133: ( SELECT ICV1.cc_header_id
1134: FROM igc_arc_pur_candidates ICV1
1135: )
1136: )
1137: OR CMLH.cc_acct_line_id IN
1138: ( SELECT ACL.cc_acct_line_id

Line 1142: FROM igc_arc_pur_candidates ICV2

1138: ( SELECT ACL.cc_acct_line_id
1139: FROM igc_cc_acct_lines ACL
1140: WHERE ACL.cc_header_id IN
1141: ( SELECT ICV2.cc_header_id
1142: FROM igc_arc_pur_candidates ICV2
1143: )
1144: );
1145:
1146: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1184: FROM igc_arc_pur_candidates ICV1

1180: ( SELECT ACLH.cc_acct_line_id
1181: FROM igc_cc_acct_line_history ACLH
1182: WHERE ACLH.cc_header_id IN
1183: ( SELECT ICV1.cc_header_id
1184: FROM igc_arc_pur_candidates ICV1
1185: )
1186: )
1187: OR DPFH.cc_acct_line_id IN
1188: ( SELECT ACL.cc_acct_line_id

Line 1192: FROM igc_arc_pur_candidates ICV2

1188: ( SELECT ACL.cc_acct_line_id
1189: FROM igc_cc_acct_lines ACL
1190: WHERE ACL.cc_header_id IN
1191: ( SELECT ICV2.cc_header_id
1192: FROM igc_arc_pur_candidates ICV2
1193: )
1194: )
1195: )
1196: OR CMDP.cc_det_pf_line_id IN

Line 1204: FROM igc_arc_pur_candidates ICV3

1200: ( SELECT ACLH1.cc_acct_line_id
1201: FROM igc_cc_acct_line_history ACLH1
1202: WHERE ACLH1.cc_header_id IN
1203: ( SELECT ICV3.cc_header_id
1204: FROM igc_arc_pur_candidates ICV3
1205: )
1206: )
1207: OR DPF.cc_acct_line_id IN
1208: ( SELECT ACL1.cc_acct_line_id

Line 1212: FROM igc_arc_pur_candidates ICV4

1208: ( SELECT ACL1.cc_acct_line_id
1209: FROM igc_cc_acct_lines ACL1
1210: WHERE ACL1.cc_header_id IN
1211: ( SELECT ICV4.cc_header_id
1212: FROM igc_arc_pur_candidates ICV4
1213: )
1214: )
1215: );
1216:

Line 1258: FROM igc_arc_pur_candidates ICV1

1254: ( SELECT ACLH.cc_acct_line_id
1255: FROM igc_cc_acct_line_history ACLH
1256: WHERE ACLH.cc_header_id IN
1257: ( SELECT ICV1.cc_header_id
1258: FROM igc_arc_pur_candidates ICV1
1259: )
1260: )
1261: OR DPFH.cc_acct_line_id IN
1262: ( SELECT ACL.cc_acct_line_id

Line 1266: FROM igc_arc_pur_candidates ICV2

1262: ( SELECT ACL.cc_acct_line_id
1263: FROM igc_cc_acct_lines ACL
1264: WHERE ACL.cc_header_id IN
1265: ( SELECT ICV2.cc_header_id
1266: FROM igc_arc_pur_candidates ICV2
1267: )
1268: )
1269: )
1270: OR CMDPH.cc_det_pf_line_id IN

Line 1278: FROM igc_arc_pur_candidates ICV3

1274: ( SELECT ACLH1.cc_acct_line_id
1275: FROM igc_cc_acct_line_history ACLH1
1276: WHERE ACLH1.cc_header_id IN
1277: ( SELECT ICV3.cc_header_id
1278: FROM igc_arc_pur_candidates ICV3
1279: )
1280: )
1281: OR DPF.cc_acct_line_id IN
1282: ( SELECT ACL1.cc_acct_line_id

Line 1286: FROM igc_arc_pur_candidates ICV4

1282: ( SELECT ACL1.cc_acct_line_id
1283: FROM igc_cc_acct_lines ACL1
1284: WHERE ACL1.cc_header_id IN
1285: ( SELECT ICV4.cc_header_id
1286: FROM igc_arc_pur_candidates ICV4
1287: )
1288: )
1289: );
1290:

Line 1476: FROM igc_arc_pur_candidates

1472: CC_GUARANTEE_FLAG
1473: FROM igc_cc_headers CH
1474: WHERE CH.cc_header_id IN
1475: ( SELECT cc_header_id
1476: FROM igc_arc_pur_candidates
1477: );
1478:
1479: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1480: IF (g_debug_mode = 'Y') THEN

Line 1602: FROM igc_arc_pur_candidates

1598: CC_GUARANTEE_FLAG
1599: FROM igc_cc_header_history CHH
1600: WHERE CHH.cc_header_id IN
1601: ( SELECT cc_header_id
1602: FROM igc_arc_pur_candidates
1603: );
1604:
1605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1606: IF (g_debug_mode = 'Y') THEN

Line 1716: FROM igc_arc_pur_candidates ICV1

1712: TAX_CLASSIF_CODE -- Added for Bug 6472296 EB Tax uptake
1713: FROM igc_cc_acct_lines CL
1714: WHERE CL.cc_header_id IN
1715: ( SELECT ICV1.cc_header_id
1716: FROM igc_arc_pur_candidates ICV1
1717: );
1718:
1719: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1720: IF (g_debug_mode = 'Y') THEN

Line 1833: FROM igc_arc_pur_candidates ICV1

1829: TAX_CLASSIF_CODE -- Added for Bug 6472296 EB Tax uptake
1830: FROM igc_cc_acct_line_history CLH
1831: WHERE CLH.cc_header_id IN
1832: ( SELECT ICV1.cc_header_id
1833: FROM igc_arc_pur_candidates ICV1
1834: );
1835:
1836: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1837: IF (g_debug_mode = 'Y') THEN

Line 1925: FROM igc_arc_pur_candidates ICV1

1921: ( SELECT ACLH.cc_acct_line_id
1922: FROM igc_cc_acct_line_history ACLH
1923: WHERE ACLH.cc_header_id IN
1924: ( SELECT ICV1.cc_header_id
1925: FROM igc_arc_pur_candidates ICV1
1926: )
1927: )
1928: OR CDP.cc_acct_line_id IN
1929: ( SELECT ACL.cc_acct_line_id

Line 1933: FROM igc_arc_pur_candidates ICV2

1929: ( SELECT ACL.cc_acct_line_id
1930: FROM igc_cc_acct_lines ACL
1931: WHERE ACL.cc_header_id IN
1932: ( SELECT ICV2.cc_header_id
1933: FROM igc_arc_pur_candidates ICV2
1934: )
1935: );
1936:
1937: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2029: FROM igc_arc_pur_candidates ICV1

2025: ( SELECT ACLH.cc_acct_line_id
2026: FROM igc_cc_acct_line_history ACLH
2027: WHERE ACLH.cc_header_id IN
2028: ( SELECT ICV1.cc_header_id
2029: FROM igc_arc_pur_candidates ICV1
2030: )
2031: )
2032: OR CDPH.cc_acct_line_id IN
2033: ( SELECT ACL.cc_acct_line_id

Line 2037: FROM igc_arc_pur_candidates ICV2

2033: ( SELECT ACL.cc_acct_line_id
2034: FROM igc_cc_acct_lines ACL
2035: WHERE ACL.cc_header_id IN
2036: ( SELECT ICV2.cc_header_id
2037: FROM igc_arc_pur_candidates ICV2
2038: )
2039: );
2040:
2041: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2084: FROM igc_arc_pur_candidates ICV

2080: CREATED_BY
2081: FROM igc_cc_actions CA
2082: WHERE CA.cc_header_id IN
2083: ( SELECT ICV.cc_header_id
2084: FROM igc_arc_pur_candidates ICV
2085: );
2086:
2087: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2088: IF (g_debug_mode = 'Y') THEN

Line 2361: FROM igc_arc_pur_candidates ICV

2357: -- FROM po_headers_all PHA1
2358: -- WHERE PHA1.segment1 IN
2359: WHERE PHA.segment1 IN
2360: ( SELECT ICV.cc_num
2361: FROM igc_arc_pur_candidates ICV
2362: );
2363: -- );
2364:
2365: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2601: FROM igc_arc_pur_candidates ICV

2597: ( SELECT PHA.po_header_id
2598: FROM po_headers PHA
2599: WHERE PHA.segment1 IN
2600: ( SELECT ICV.cc_num
2601: FROM igc_arc_pur_candidates ICV
2602: )
2603: );
2604:
2605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2865: FROM igc_arc_pur_candidates ICV

2861: ( SELECT po_header_id
2862: FROM po_headers PHA
2863: WHERE PHA.segment1 IN
2864: ( SELECT ICV.cc_num
2865: FROM igc_arc_pur_candidates ICV
2866: )
2867: );
2868:
2869: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 3067: FROM igc_arc_pur_candidates ICV

3063: ( SELECT po_header_id
3064: FROM po_headers PHA
3065: WHERE PHA.segment1 IN
3066: ( SELECT ICV.cc_num
3067: FROM igc_arc_pur_candidates ICV
3068: )
3069: );
3070:
3071: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 3139: FROM igc_arc_pur_candidates;

3135: -- Define cursor to get count inserted into table.
3136: -- --------------------------------------------------------------------
3137: CURSOR c_cand_count IS
3138: SELECT count(*)
3139: FROM igc_arc_pur_candidates;
3140:
3141: l_full_path VARCHAR2(255);
3142:
3143: BEGIN

Line 3162: FROM igc_arc_pur_candidates;

3158: -- --------------------------------------------------------------------
3159: -- Clean up the temp table of any records being present.
3160: -- --------------------------------------------------------------------
3161: DELETE
3162: FROM igc_arc_pur_candidates;
3163:
3164: -- --------------------------------------------------------------------
3165: -- Insert all candidates that are closed / cancelled and all invoices
3166: -- that have been paid for the contract.

Line 3169: INTO igc_arc_pur_candidates

3165: -- Insert all candidates that are closed / cancelled and all invoices
3166: -- that have been paid for the contract.
3167: -- --------------------------------------------------------------------
3168: INSERT
3169: INTO igc_arc_pur_candidates
3170: (cc_header_id,
3171: cc_num,
3172: cc_acct_line_id,
3173: cc_det_pf_line_id,

Line 3227: FROM igc_arc_pur_candidates

3223: -- for each cover are closed / cancelled. Remove all cover candidates
3224: -- chosen from above that are not closed / cancelled.
3225: -- --------------------------------------------------------------------
3226: DELETE
3227: FROM igc_arc_pur_candidates
3228: WHERE cc_header_id IN
3229: ( SELECT parent_header_id
3230: FROM igc_cc_headers
3231: WHERE parent_header_id IS NOT NULL

Line 3234: FROM igc_arc_pur_candidates

3230: FROM igc_cc_headers
3231: WHERE parent_header_id IS NOT NULL
3232: AND cc_header_id NOT IN
3233: ( SELECT cc_header_id
3234: FROM igc_arc_pur_candidates
3235: )
3236: );
3237:
3238: -- --------------------------------------------------------------------

Line 3244: FROM igc_arc_pur_candidates

3240: -- for each cover are closed / cancelled. Remove all release candidates
3241: -- chosen from above that are not closed / cancelled.
3242: -- --------------------------------------------------------------------
3243: DELETE
3244: FROM igc_arc_pur_candidates
3245: WHERE cc_header_id IN
3246: ( SELECT cc_header_id
3247: FROM igc_cc_headers
3248: WHERE parent_header_id IS NOT NULL

Line 3251: FROM igc_arc_pur_candidates

3247: FROM igc_cc_headers
3248: WHERE parent_header_id IS NOT NULL
3249: AND parent_header_id NOT IN
3250: ( SELECT cc_header_id
3251: FROM igc_arc_pur_candidates
3252: )
3253: );
3254:
3255: -- --------------------------------------------------------------------

Line 3459: FROM igc_arc_pur_candidates ICV

3455: DELETE
3456: FROM igc_cc_arc_mc_headers CMH
3457: WHERE CMH.cc_header_id IN
3458: ( SELECT ICV.cc_header_id
3459: FROM igc_arc_pur_candidates ICV
3460: );
3461:
3462: -- --------------------------------------------------------------------
3463: -- Delete MRC Archive Account Line records before adding again.

Line 3479: FROM igc_arc_pur_candidates ICV1

3475: ( SELECT ACLH.cc_acct_line_id
3476: FROM igc_cc_acct_line_history ACLH
3477: WHERE ACLH.cc_header_id IN
3478: ( SELECT ICV1.cc_header_id
3479: FROM igc_arc_pur_candidates ICV1
3480: )
3481: )
3482: OR CML.cc_acct_line_id IN
3483: ( SELECT ACL.cc_acct_line_id

Line 3487: FROM igc_arc_pur_candidates ICV2

3483: ( SELECT ACL.cc_acct_line_id
3484: FROM igc_cc_acct_lines ACL
3485: WHERE ACL.cc_header_id IN
3486: ( SELECT ICV2.cc_header_id
3487: FROM igc_arc_pur_candidates ICV2
3488: )
3489: );
3490:
3491: -- --------------------------------------------------------------------

Line 3511: FROM igc_arc_pur_candidates ICV1

3507: ( SELECT ACLH.cc_acct_line_id
3508: FROM igc_cc_acct_line_history ACLH
3509: WHERE ACLH.cc_header_id IN
3510: ( SELECT ICV1.cc_header_id
3511: FROM igc_arc_pur_candidates ICV1
3512: )
3513: )
3514: OR DPFH.cc_acct_line_id IN
3515: ( SELECT ACL.cc_acct_line_id

Line 3519: FROM igc_arc_pur_candidates ICV2

3515: ( SELECT ACL.cc_acct_line_id
3516: FROM igc_cc_acct_lines ACL
3517: WHERE ACL.cc_header_id IN
3518: ( SELECT ICV2.cc_header_id
3519: FROM igc_arc_pur_candidates ICV2
3520: )
3521: )
3522: )
3523: OR CMP.cc_det_pf_line_id IN

Line 3531: FROM igc_arc_pur_candidates ICV1

3527: ( SELECT ACLH.cc_acct_line_id
3528: FROM igc_cc_acct_line_history ACLH
3529: WHERE ACLH.cc_header_id IN
3530: ( SELECT ICV1.cc_header_id
3531: FROM igc_arc_pur_candidates ICV1
3532: )
3533: )
3534: OR DPF.cc_acct_line_id IN
3535: ( SELECT ACL.cc_acct_line_id

Line 3539: FROM igc_arc_pur_candidates ICV2

3535: ( SELECT ACL.cc_acct_line_id
3536: FROM igc_cc_acct_lines ACL
3537: WHERE ACL.cc_header_id IN
3538: ( SELECT ICV2.cc_header_id
3539: FROM igc_arc_pur_candidates ICV2
3540: )
3541: )
3542: );
3543:

Line 3558: FROM igc_arc_pur_candidates ICV

3554: DELETE
3555: FROM igc_cc_arc_mc_header_hist CMHH
3556: WHERE CMHH.cc_header_id IN
3557: ( SELECT ICV.cc_header_id
3558: FROM igc_arc_pur_candidates ICV
3559: );
3560:
3561: -- --------------------------------------------------------------------
3562: -- Delete MRC Archive Account Line History records before adding again.

Line 3578: FROM igc_arc_pur_candidates ICV1

3574: ( SELECT ACLH.cc_acct_line_id
3575: FROM igc_cc_acct_line_history ACLH
3576: WHERE ACLH.cc_header_id IN
3577: ( SELECT ICV1.cc_header_id
3578: FROM igc_arc_pur_candidates ICV1
3579: )
3580: )
3581: OR CMLH.cc_acct_line_id IN
3582: ( SELECT ACL.cc_acct_line_id

Line 3586: FROM igc_arc_pur_candidates ICV2

3582: ( SELECT ACL.cc_acct_line_id
3583: FROM igc_cc_acct_lines ACL
3584: WHERE ACL.cc_header_id IN
3585: ( SELECT ICV2.cc_header_id
3586: FROM igc_arc_pur_candidates ICV2
3587: )
3588: );
3589:
3590: -- --------------------------------------------------------------------

Line 3610: FROM igc_arc_pur_candidates ICV1

3606: ( SELECT ACLH.cc_acct_line_id
3607: FROM igc_cc_acct_line_history ACLH
3608: WHERE ACLH.cc_header_id IN
3609: ( SELECT ICV1.cc_header_id
3610: FROM igc_arc_pur_candidates ICV1
3611: )
3612: )
3613: OR DPFH.cc_acct_line_id IN
3614: ( SELECT ACL.cc_acct_line_id

Line 3618: FROM igc_arc_pur_candidates ICV2

3614: ( SELECT ACL.cc_acct_line_id
3615: FROM igc_cc_acct_lines ACL
3616: WHERE ACL.cc_header_id IN
3617: ( SELECT ICV2.cc_header_id
3618: FROM igc_arc_pur_candidates ICV2
3619: )
3620: )
3621: )
3622: OR CMPH.cc_det_pf_line_id IN

Line 3630: FROM igc_arc_pur_candidates ICV1

3626: ( SELECT ACLH.cc_acct_line_id
3627: FROM igc_cc_acct_line_history ACLH
3628: WHERE ACLH.cc_header_id IN
3629: ( SELECT ICV1.cc_header_id
3630: FROM igc_arc_pur_candidates ICV1
3631: )
3632: )
3633: OR DPF.cc_acct_line_id IN
3634: ( SELECT ACL.cc_acct_line_id

Line 3638: FROM igc_arc_pur_candidates ICV2

3634: ( SELECT ACL.cc_acct_line_id
3635: FROM igc_cc_acct_lines ACL
3636: WHERE ACL.cc_header_id IN
3637: ( SELECT ICV2.cc_header_id
3638: FROM igc_arc_pur_candidates ICV2
3639: )
3640: )
3641: );
3642:

Line 3720: FROM igc_arc_pur_candidates ICV

3716: DELETE
3717: FROM igc_cc_arc_headers_all CMH
3718: WHERE CMH.cc_header_id IN
3719: ( SELECT ICV.cc_header_id
3720: FROM igc_arc_pur_candidates ICV
3721: );
3722:
3723: -- --------------------------------------------------------------------
3724: -- Delete Archive Header History records before adding again.

Line 3737: FROM igc_arc_pur_candidates ICV

3733: DELETE
3734: FROM igc_cc_arc_header_hist_all CAHH
3735: WHERE CAHH.cc_header_id IN
3736: ( SELECT ICV.cc_header_id
3737: FROM igc_arc_pur_candidates ICV
3738: );
3739:
3740: -- --------------------------------------------------------------------
3741: -- Delete Archive Account Line records before adding again.

Line 3754: FROM igc_arc_pur_candidates ICV

3750: DELETE
3751: FROM igc_cc_arc_acct_lines CML
3752: WHERE CML.cc_header_id IN
3753: ( SELECT ICV.cc_header_id
3754: FROM igc_arc_pur_candidates ICV
3755: );
3756:
3757: -- --------------------------------------------------------------------
3758: -- Delete Archive Account Line History records before adding again.

Line 3771: FROM igc_arc_pur_candidates ICV

3767: DELETE
3768: FROM igc_cc_arc_acct_line_hist CML
3769: WHERE CML.cc_header_id IN
3770: ( SELECT ICV.cc_header_id
3771: FROM igc_arc_pur_candidates ICV
3772: );
3773:
3774: -- --------------------------------------------------------------------
3775: -- Delete Archive Payment Forcast records before adding again.

Line 3791: FROM igc_arc_pur_candidates ICV1

3787: ( SELECT ACLH.cc_acct_line_id
3788: FROM igc_cc_acct_line_history ACLH
3789: WHERE ACLH.cc_header_id IN
3790: ( SELECT ICV1.cc_header_id
3791: FROM igc_arc_pur_candidates ICV1
3792: )
3793: )
3794: OR CDP.cc_acct_line_id IN
3795: ( SELECT ACL.cc_acct_line_id

Line 3799: FROM igc_arc_pur_candidates ICV2

3795: ( SELECT ACL.cc_acct_line_id
3796: FROM igc_cc_acct_lines ACL
3797: WHERE ACL.cc_header_id IN
3798: ( SELECT ICV2.cc_header_id
3799: FROM igc_arc_pur_candidates ICV2
3800: )
3801: );
3802:
3803: -- --------------------------------------------------------------------

Line 3820: FROM igc_arc_pur_candidates ICV1

3816: ( SELECT ACLH.cc_acct_line_id
3817: FROM igc_cc_acct_line_history ACLH
3818: WHERE ACLH.cc_header_id IN
3819: ( SELECT ICV1.cc_header_id
3820: FROM igc_arc_pur_candidates ICV1
3821: )
3822: )
3823: OR CDPH.cc_acct_line_id IN
3824: ( SELECT ACL.cc_acct_line_id

Line 3828: FROM igc_arc_pur_candidates ICV1

3824: ( SELECT ACL.cc_acct_line_id
3825: FROM igc_cc_acct_lines ACL
3826: WHERE ACL.cc_header_id IN
3827: ( SELECT ICV1.cc_header_id
3828: FROM igc_arc_pur_candidates ICV1
3829: )
3830: );
3831:
3832: -- --------------------------------------------------------------------

Line 3846: FROM igc_arc_pur_candidates ICV

3842: DELETE
3843: FROM igc_cc_arc_actions CAA
3844: WHERE CAA.cc_header_id IN
3845: ( SELECT ICV.cc_header_id
3846: FROM igc_arc_pur_candidates ICV
3847: );
3848:
3849: -- --------------------------------------------------------------------
3850: -- Delete Archived PO Header records that may exist

Line 3866: FROM igc_arc_pur_candidates ICV

3862: ( SELECT PHA1.po_header_id
3863: FROM po_headers_all PHA1
3864: WHERE PHA1.segment1 IN
3865: ( SELECT ICV.cc_num
3866: FROM igc_arc_pur_candidates ICV
3867: )
3868: );
3869:
3870: -- --------------------------------------------------------------------

Line 3887: FROM igc_arc_pur_candidates ICV

3883: ( SELECT PHA.po_header_id
3884: FROM po_headers_all PHA
3885: WHERE PHA.segment1 IN
3886: ( SELECT ICV.cc_num
3887: FROM igc_arc_pur_candidates ICV
3888: )
3889: );
3890:
3891: -- --------------------------------------------------------------------

Line 3908: FROM igc_arc_pur_candidates ICV

3904: ( SELECT PHA.po_header_id
3905: FROM po_headers_all PHA
3906: WHERE PHA.segment1 IN
3907: ( SELECT ICV.cc_num
3908: FROM igc_arc_pur_candidates ICV
3909: )
3910: );
3911:
3912: -- --------------------------------------------------------------------

Line 3929: FROM igc_arc_pur_candidates ICV

3925: ( SELECT PHA.po_header_id
3926: FROM po_headers_all PHA
3927: WHERE PHA.segment1 IN
3928: ( SELECT ICV.cc_num
3929: FROM igc_arc_pur_candidates ICV
3930: )
3931: );
3932:
3933: RETURN;

Line 4202: l_max_date igc_arc_pur_candidates.last_activity_date%TYPE;

4198: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4199: l_cc_type igc_cc_headers.cc_type%TYPE;
4200: l_parent_id igc_cc_headers.parent_header_id%TYPE;
4201: l_history_rec igc_cc_archive_history%ROWTYPE;
4202: l_max_date igc_arc_pur_candidates.last_activity_date%TYPE;
4203:
4204: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Archive_History';
4205:
4206: -- --------------------------------------------------------------------

Line 4213: FROM igc_arc_pur_candidates;

4209: CURSOR c_get_archived_hdrs IS
4210: SELECT distinct (cc_header_id),
4211: cc_num,
4212: last_activity_date
4213: FROM igc_arc_pur_candidates;
4214:
4215: CURSOR c_cc_header_info IS
4216: SELECT cc_header_id,
4217: cc_num,

Line 4534: FROM igc_arc_pur_candidates

4530: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Candidates';
4531:
4532: CURSOR c_lock_candidates IS
4533: SELECT cc_header_id
4534: FROM igc_arc_pur_candidates
4535: FOR UPDATE NOWAIT;
4536:
4537: l_full_path VARCHAR2(255);
4538:

Line 4847: FROM igc_arc_pur_candidates ICAP;

4843: AND archive_done_flag = 'Y';
4844:
4845: CURSOR c_get_purge_candidate IS
4846: SELECT distinct (ICAP.cc_header_id)
4847: FROM igc_arc_pur_candidates ICAP;
4848: l_full_path VARCHAR2(255);
4849:
4850: BEGIN
4851:

Line 5215: FROM igc_arc_pur_candidates ICAP;

5211: AND archive_done_flag = 'Y';
5212:
5213: CURSOR c_get_purge_candidate IS
5214: SELECT distinct (ICAP.cc_header_id)
5215: FROM igc_arc_pur_candidates ICAP;
5216:
5217: l_full_path VARCHAR2(255);
5218:
5219: BEGIN

Line 5283: FROM igc_arc_pur_candidates ICV

5279: ( SELECT PHA.po_header_id
5280: FROM po_headers_all PHA
5281: WHERE PHA.segment1 IN
5282: ( SELECT ICV.cc_num
5283: FROM igc_arc_pur_candidates ICV
5284: WHERE ICV.cc_header_id = l_cc_header_id
5285: )
5286: );
5287:

Line 5305: FROM igc_arc_pur_candidates ICV

5301: ( SELECT PHA.po_header_id
5302: FROM po_headers_all PHA
5303: WHERE PHA.segment1 IN
5304: ( SELECT ICV.cc_num
5305: FROM igc_arc_pur_candidates ICV
5306: WHERE ICV.cc_header_id = l_cc_header_id
5307: )
5308: );
5309:

Line 5327: FROM igc_arc_pur_candidates ICV

5323: ( SELECT PHA.po_header_id
5324: FROM po_headers_all PHA
5325: WHERE PHA.segment1 IN
5326: ( SELECT ICV.cc_num
5327: FROM igc_arc_pur_candidates ICV
5328: WHERE ICV.cc_header_id = l_cc_header_id
5329: )
5330: );
5331:

Line 5349: FROM igc_arc_pur_candidates ICV

5345: ( SELECT PHA1.po_header_id
5346: FROM po_headers_all PHA1
5347: WHERE PHA1.segment1 IN
5348: ( SELECT ICV.cc_num
5349: FROM igc_arc_pur_candidates ICV
5350: WHERE ICV.cc_header_id = l_cc_header_id
5351: )
5352: );
5353: