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.

[Home] [Help]

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.25.12010000.2 2008/08/29 13:20:18 schakkin 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 840: Put_Debug_Msg (l_full_path,p_debug_msg => 'Truncating igc_cbc_po_process_excpts_all table');

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

Line 843: DELETE FROM igc_cbc_po_process_excpts_all;

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

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

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

Line 3893: igc_cbc_po_process_excpts_all ipe

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

Line 3905: igc_cbc_po_process_excpts_all ipe

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

Line 3944: FROM igc_cbc_po_process_excpts_all ipe,

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

Line 3953: FROM igc_cbc_po_process_excpts_all ipe,

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