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_CBC_PO_YEAR_END_PKG dependencies on IGC_CBC_PO_PROCESS_EXCPTS_ALL

Line 6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,

2: /*$Header: IGCPOYEB.pls 120.27.12020000.1 2013/02/15 17:52:40 appldev ship $*/
3:
4:
5: TYPE exception_rec_type IS RECORD
6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,
7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,

Line 7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,

3:
4:
5: TYPE exception_rec_type IS RECORD
6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,
7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,

Line 8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,

4:
5: TYPE exception_rec_type IS RECORD
6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,
7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,
12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE

Line 9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,

5: TYPE exception_rec_type IS RECORD
6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,
7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,
12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE
13: );

Line 10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,

6: (document_type igc_cbc_po_process_excpts_all.document_type%TYPE,
7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,
12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE
13: );
14:

Line 11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,

7: document_id igc_cbc_po_process_excpts_all.document_id%TYPE,
8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,
12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE
13: );
14:
15: TYPE exception_tbl_type IS TABLE OF exception_rec_type

Line 12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE

8: line_id igc_cbc_po_process_excpts_all.line_id%TYPE,
9: line_location_id igc_cbc_po_process_excpts_all.line_location_id%TYPE,
10: distribution_id igc_cbc_po_process_excpts_all.distribution_id%TYPE,
11: exception_reason igc_cbc_po_process_excpts_all.exception_reason%TYPE,
12: exception_code igc_cbc_po_process_excpts_all.exception_code%TYPE
13: );
14:
15: TYPE exception_tbl_type IS TABLE OF exception_rec_type
16: INDEX BY BINARY_INTEGER;

Line 349: INSERT INTO igc_cbc_po_process_excpts_all

345: -- insert any records in global pl/sql exception table into igc exceptions table
346: -- bug 2804025 ssmales 19-Feb-2003 amended below to user g_user_id,g_login
347: FOR l_index IN g_exception_tbl.FIRST .. g_exception_tbl.LAST
348: LOOP
349: INSERT INTO igc_cbc_po_process_excpts_all
350: (
351: document_type,
352: document_id,
353: line_id,

Line 841: Put_Debug_Msg (l_full_path,p_debug_msg => 'Truncating igc_cbc_po_process_excpts_all table');

837: -- Clear the exceptions table if user has selected Yes for Truncate parameter
838: IF p_trunc_exception = 'Y'
839: THEN
840: IF (g_debug_mode = 'Y') THEN
841: Put_Debug_Msg (l_full_path,p_debug_msg => 'Truncating igc_cbc_po_process_excpts_all table');
842: END IF;
843:
844: DELETE FROM igc_cbc_po_process_excpts_all;
845: -- l_sql_string := 'TRUNCATE table igc_cbc_po_process_excpts_all' ;

Line 844: DELETE FROM igc_cbc_po_process_excpts_all;

840: IF (g_debug_mode = 'Y') THEN
841: Put_Debug_Msg (l_full_path,p_debug_msg => 'Truncating igc_cbc_po_process_excpts_all table');
842: END IF;
843:
844: DELETE FROM igc_cbc_po_process_excpts_all;
845: -- l_sql_string := 'TRUNCATE table igc_cbc_po_process_excpts_all' ;
846: -- EXECUTE IMMEDIATE l_sql_string;
847: END IF ; -- p_trunc_exception = 'Y'
848:

Line 845: -- l_sql_string := 'TRUNCATE table igc_cbc_po_process_excpts_all' ;

841: Put_Debug_Msg (l_full_path,p_debug_msg => 'Truncating igc_cbc_po_process_excpts_all table');
842: END IF;
843:
844: DELETE FROM igc_cbc_po_process_excpts_all;
845: -- l_sql_string := 'TRUNCATE table igc_cbc_po_process_excpts_all' ;
846: -- EXECUTE IMMEDIATE l_sql_string;
847: END IF ; -- p_trunc_exception = 'Y'
848:
849: -- Both SBC and CBC are enabled, so get encumbrance types

Line 3894: igc_cbc_po_process_excpts_all ipe

3890: -- Removed the clause "AND ipe.exception_code = 'IGC_PO_YEP_REL_INV_STATE'"
3891: CURSOR c_get_release_errors(p_header_id NUMBER) IS
3892: SELECT 'x'
3893: FROM po_releases por,
3894: igc_cbc_po_process_excpts_all ipe
3895: WHERE por.po_header_id = p_header_id
3896: AND ipe.document_type = 'REL'
3897: AND ipe.document_id = por.po_release_id
3898: AND ipe.conc_request_id = p_conc_request_id ;

Line 3906: igc_cbc_po_process_excpts_all ipe

3902: CURSOR c_get_po_errors(p_req_id NUMBER) IS
3903: SELECT 'x'
3904: FROM po_line_locations poll,
3905: po_requisition_lines porl,
3906: igc_cbc_po_process_excpts_all ipe
3907: WHERE porl.requisition_header_id = p_req_id
3908: AND porl.line_location_id = poll.line_location_id
3909: AND ipe.document_id = poll.po_header_id
3910: AND ipe.conc_request_id = p_conc_request_id ;

Line 3945: FROM igc_cbc_po_process_excpts_all ipe,

3941:
3942: -- Added for PRC.FP.J, 3173178
3943: CURSOR c_get_bpa_po_errs (p_bpa_header_id NUMBER) IS
3944: SELECT 'X'
3945: FROM igc_cbc_po_process_excpts_all ipe,
3946: po_lines pol
3947: WHERE pol.from_header_id = p_bpa_header_id
3948: AND pol.po_header_id = ipe.document_id
3949: AND ipe.document_type = 'PO'

Line 3954: FROM igc_cbc_po_process_excpts_all ipe,

3950: AND ipe.conc_request_id = p_conc_request_id ;
3951:
3952: CURSOR c_get_bpa_req_errs (p_bpa_header_id NUMBER) IS
3953: SELECT 'X'
3954: FROM igc_cbc_po_process_excpts_all ipe,
3955: po_requisition_lines prl
3956: WHERE prl.blanket_po_header_id = p_bpa_header_id
3957: AND prl.requisition_header_id = ipe.document_id
3958: AND ipe.document_type = 'REQ'