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_CC_HEADERS

Line 13: g_update_login igc_cc_headers.last_update_login%TYPE;

9:
10: -- Private Global Variables :
11:
12: g_debug_msg VARCHAR2(10000) := NULL;
13: g_update_login igc_cc_headers.last_update_login%TYPE;
14: g_update_by igc_cc_headers.last_updated_by%TYPE;
15: g_mrc_installed VARCHAR2(1);
16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;

Line 14: g_update_by igc_cc_headers.last_updated_by%TYPE;

10: -- Private Global Variables :
11:
12: g_debug_msg VARCHAR2(10000) := NULL;
13: g_update_login igc_cc_headers.last_update_login%TYPE;
14: g_update_by igc_cc_headers.last_updated_by%TYPE;
15: g_mrc_installed VARCHAR2(1);
16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
18: g_org_id igc_cc_headers.org_id%TYPE;

Line 18: g_org_id igc_cc_headers.org_id%TYPE;

14: g_update_by igc_cc_headers.last_updated_by%TYPE;
15: g_mrc_installed VARCHAR2(1);
16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
18: g_org_id igc_cc_headers.org_id%TYPE;
19: g_sob_id igc_cc_headers.set_of_books_id%TYPE;
20: g_cc_num igc_cc_headers.cc_num%TYPE;
21: g_maxloops CONSTANT NUMBER(2) := 20;
22: g_seconds CONSTANT NUMBER(2) := 10;

Line 19: g_sob_id igc_cc_headers.set_of_books_id%TYPE;

15: g_mrc_installed VARCHAR2(1);
16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
18: g_org_id igc_cc_headers.org_id%TYPE;
19: g_sob_id igc_cc_headers.set_of_books_id%TYPE;
20: g_cc_num igc_cc_headers.cc_num%TYPE;
21: g_maxloops CONSTANT NUMBER(2) := 20;
22: g_seconds CONSTANT NUMBER(2) := 10;
23: g_validation_error BOOLEAN := FALSE;

Line 20: g_cc_num igc_cc_headers.cc_num%TYPE;

16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
18: g_org_id igc_cc_headers.org_id%TYPE;
19: g_sob_id igc_cc_headers.set_of_books_id%TYPE;
20: g_cc_num igc_cc_headers.cc_num%TYPE;
21: g_maxloops CONSTANT NUMBER(2) := 20;
22: g_seconds CONSTANT NUMBER(2) := 10;
23: g_validation_error BOOLEAN := FALSE;
24:

Line 1473: FROM igc_cc_headers CH

1469: ATTRIBUTE13 ,
1470: ATTRIBUTE14 ,
1471: ATTRIBUTE15 ,
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: );

Line 3182: igc_cc_headers_all ICH

3178: ICCCHV.cc_act_id,
3179: ICCCHV.cc_pf_id,
3180: ICCCHV.max_dt
3181: FROM igc_cc_closed_canc_hdrs_v ICCCHV,
3182: igc_cc_headers_all ICH
3183: WHERE ICH.cc_header_id = ICCCHV.cc_hd_id
3184: AND ICH.set_of_books_id = g_sob_id
3185: AND ICH.org_id = g_org_id
3186: AND trunc (ICCCHV.max_dt) <= trunc (g_last_activity_date)

Line 3189: FROM igc_cc_headers ICH1,

3185: AND ICH.org_id = g_org_id
3186: AND trunc (ICCCHV.max_dt) <= trunc (g_last_activity_date)
3187: AND ICH.cc_header_id NOT IN
3188: ( SELECT ICH1.cc_header_id
3189: FROM igc_cc_headers ICH1,
3190: po_headers_all PHA1,
3191: po_distributions_all PDA,
3192: ap_invoice_distributions_all AIDA,
3193: ap_invoices_all AIA1

Line 3230: FROM igc_cc_headers

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
3232: AND cc_header_id NOT IN
3233: ( SELECT cc_header_id
3234: FROM igc_arc_pur_candidates

Line 3247: FROM igc_cc_headers

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
3249: AND parent_header_id NOT IN
3250: ( SELECT cc_header_id
3251: FROM igc_arc_pur_candidates

Line 4198: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

4194: -- --------------------------------------------------------------------
4195: -- Declare local variables to be used in this procedure.
4196: -- --------------------------------------------------------------------
4197: l_return_status VARCHAR2(1);
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;

Line 4199: l_cc_type igc_cc_headers.cc_type%TYPE;

4195: -- Declare local variables to be used in this procedure.
4196: -- --------------------------------------------------------------------
4197: l_return_status VARCHAR2(1);
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:

Line 4200: l_parent_id igc_cc_headers.parent_header_id%TYPE;

4196: -- --------------------------------------------------------------------
4197: l_return_status VARCHAR2(1);
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';

Line 4220: FROM igc_cc_headers

4216: SELECT cc_header_id,
4217: cc_num,
4218: cc_type,
4219: parent_header_id
4220: FROM igc_cc_headers
4221: WHERE cc_header_id = l_cc_header_id;
4222: /*AND set_of_books_id = g_sob_id
4223: AND org_id = g_org_id; --Commented during MOAC uptake*/
4224:

Line 4529: l_cc_header igc_cc_headers.cc_header_id%TYPE;

4525: -- --------------------------------------------------------------------
4526: -- Declare local variables to be used.
4527: -- --------------------------------------------------------------------
4528: l_counter NUMBER(1) := 0;
4529: l_cc_header igc_cc_headers.cc_header_id%TYPE;
4530: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Candidates';
4531:
4532: CURSOR c_lock_candidates IS
4533: SELECT cc_header_id

Line 4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

4822:
4823: -- --------------------------------------------------------------------
4824: -- Declare local variables to be used in this procedure.
4825: -- --------------------------------------------------------------------
4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;

Line 5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

5187:
5188: -- --------------------------------------------------------------------
5189: -- Declare local variables to be used in this procedure.
5190: -- --------------------------------------------------------------------
5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;

Line 5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

5188: -- --------------------------------------------------------------------
5189: -- Declare local variables to be used in this procedure.
5190: -- --------------------------------------------------------------------
5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;

Line 5471: FROM igc_cc_headers CH

5467: -- --------------------------------------------------------------------
5468: -- Delete all Header records for related CC Header IDs.
5469: -- --------------------------------------------------------------------
5470: DELETE
5471: FROM igc_cc_headers CH
5472: WHERE CH.cc_header_id = l_cc_header_id
5473: AND CH.set_of_books_id = g_sob_id;
5474:
5475: IF (g_debug_mode = 'Y') THEN

Line 5476: g_debug_msg := 'Number Rows Deleted from IGC_CC_HEADERS for CC Header ID : ' ||

5472: WHERE CH.cc_header_id = l_cc_header_id
5473: AND CH.set_of_books_id = g_sob_id;
5474:
5475: IF (g_debug_mode = 'Y') THEN
5476: g_debug_msg := 'Number Rows Deleted from IGC_CC_HEADERS for CC Header ID : ' ||
5477: l_cc_header_id || ' SOB ID : ' || l_sob_id || ' is : ' ||
5478: to_char(SQL%ROWCOUNT);
5479: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5480: END IF;

Line 5912: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

5908:
5909: -- --------------------------------------------------------------------
5910: -- Define local variables to be used
5911: -- --------------------------------------------------------------------
5912: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5913: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Inputs';
5914:
5915: -- --------------------------------------------------------------------
5916: -- Define cursors to be used in main archive/purge procedure

Line 5920: FROM igc_cc_headers ICCH

5916: -- Define cursors to be used in main archive/purge procedure
5917: -- --------------------------------------------------------------------
5918: CURSOR c_validate_sob_org IS
5919: SELECT ICCH.cc_header_id
5920: FROM igc_cc_headers ICCH
5921: WHERE ICCH.set_of_books_id = g_sob_id
5922: AND ICCH.org_id = g_org_id;
5923:
5924: l_full_path VARCHAR2(255);

Line 5980: -- Make sure that there are records in the IGC_CC_HEADERS table that

5976:
5977: ELSE
5978:
5979: -- -------------------------------------------------------------------
5980: -- Make sure that there are records in the IGC_CC_HEADERS table that
5981: -- can be reviewed for the SOB ID and the ORG ID.
5982: -- -------------------------------------------------------------------
5983: OPEN c_validate_sob_org;
5984: FETCH c_validate_sob_org

Line 5993: ' Combination not found in IGC_CC_HEADERS. Exiting.';

5989: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5990: IF (g_debug_mode = 'Y') THEN
5991: g_debug_msg := ' Set of books ID : ' || g_sob_id ||
5992: ' and ORG ID : ' || g_org_id ||
5993: ' Combination not found in IGC_CC_HEADERS. Exiting.';
5994: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5995: END IF;
5996:
5997: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',