APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on IGC_CC_HEADERS_INTERFACE

Line 200: FROM igc_cc_headers_interface ICALI1

196: ICALI.interface_acct_line_id
197: FROM igc_cc_acct_lines_interface ICALI
198: WHERE ICALI.batch_id = g_batch_Id
199: AND NOT EXISTS (SELECT ICALI1.interface_header_id
200: FROM igc_cc_headers_interface ICALI1
201: WHERE ICALI1.batch_id = g_batch_id
202: AND ICALI.interface_header_id = ICALI1.interface_header_id);
203:
204: CURSOR c_interface_orphan_det_pf IS

Line 210: FROM igc_cc_headers_interface ICHI,

206: ICDPI.interface_det_pf_line_id
207: FROM igc_cc_det_pf_interface ICDPI
208: WHERE ICDPI.batch_id = g_batch_id
209: AND NOT EXISTS (SELECT ICALI.interface_acct_line_id
210: FROM igc_cc_headers_interface ICHI,
211: igc_cc_acct_lines_interface ICALI
212: WHERE ICHI.batch_id = g_batch_id
213: AND ICHI.batch_id = ICALI.batch_id
214: AND ICHI.interface_header_id = ICALI.interface_header_id

Line 283: FROM igc_cc_headers cch, igc_cc_headers_interface cchi

279: BEGIN
280: IF P_Interface_Parent_Header_Id IS NOT NULL AND P_Parent_Header_Id IS NULL THEN
281: BEGIN
282: SELECT cch.cc_header_id INTO P_Parent_Header_Id
283: FROM igc_cc_headers cch, igc_cc_headers_interface cchi
284: WHERE cchi.interface_header_id = P_Interface_Parent_Header_Id
285: AND cchi.cc_num = cch.cc_num
286: AND cchi.org_id = cch.org_id;
287: EXCEPTION WHEN OTHERS THEN RAISE;

Line 545: FROM igc_cc_headers_interface

541: AND l_valid
542: THEN
543: SELECT MIN(cc_start_date)
544: INTO l_min_rel_start_date
545: FROM igc_cc_headers_interface
546: WHERE interface_parent_header_id = p_interface_header_id;
547:
548: -- Check Start date of cover < earliest release start date
549: IF NVL(l_min_rel_start_date, p_cc_start_date) < p_cc_start_date

Line 613: FROM igc_cc_headers_interface

609: IF p_cc_type = 'C'
610: THEN
611: SELECT MAX(cc_end_date)
612: INTO l_max_rel_end_date
613: FROM igc_cc_headers_interface
614: WHERE interface_parent_header_id = p_interface_header_id;
615:
616: -- Check End date of cover > latest release end date
617: IF NVL(l_max_rel_end_date, p_cc_end_date) > p_cc_end_date

Line 1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;

1376: l_msg_data VARCHAR2(12000);
1377: l_error_text VARCHAR2(12000);
1378: l_msg_buf VARCHAR2(2000);
1379: l_request_id NUMBER;
1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;
1381: l_start_date gl_periods.start_date%TYPE;
1382: l_end_date gl_periods.end_date%TYPE;
1383: l_curr_year_pf_lines NUMBER;
1384: l_error_message igc_cc_interface_errors.error_message%TYPE;

Line 1409: SELECT * FROM igc_cc_headers_interface

1405: l_lang VARCHAR2(10):='en';
1406: l_layout BOOLEAN;
1407:
1408: CURSOR c_interface_header_records IS
1409: SELECT * FROM igc_cc_headers_interface
1410: WHERE batch_id = P_Batch_Id
1411: ORDER BY cc_type DESC;
1412:
1413: -- Start Date and End Date of current fiscal year for set of books

Line 2418: DELETE IGC.igc_cc_headers_interface

2414: END IF;
2415: -- bug 3199488, end block
2416:
2417: /*
2418: DELETE IGC.igc_cc_headers_interface
2419: WHERE batch_id = P_Batch_Id;
2420: DELETE IGC.igc_cc_acct_lines_interface
2421: WHERE batch_id = P_Batch_Id;
2422: DELETE IGC.igc_cc_det_pf_interface

Line 2762: FROM igc_cc_headers_interface

2758: ELSE
2759: BEGIN
2760: SELECT interface_header_id, cc_start_date, cc_end_date, currency_code, conversion_type, conversion_rate, conversion_date
2761: INTO l_interface_parent_header_id, l_start_date, l_end_date, l_curr_code, l_conversion_type, l_conversion_rate, l_conversion_date
2762: FROM igc_cc_headers_interface
2763: WHERE interface_header_id = P_Interface_Parent_Header_Id
2764: AND cc_type = 'C';
2765: IF P_Cc_Start_Date < l_start_date THEN
2766: l_error_message := NULL;