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_GT

Line 1278: INSERT INTO igc_cbc_po_process_gt

1274: Put_Debug_Msg (l_full_path,p_debug_msg => '**** Fetch PO and Releases ****');
1275: END IF;
1276:
1277: -- Fetch into global temporary table all documents that satisfy our initial selection criteria
1278: INSERT INTO igc_cbc_po_process_gt
1279: (document_type,
1280: po_header_id,
1281: po_release_id,
1282: line_id,

Line 1336: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;

1332: AND pod.gl_encumbered_date <= p_prev_year_end_date
1333: ;
1334:
1335: IF (g_debug_mode = 'Y') THEN
1336: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;
1337: Put_Debug_Msg (l_full_path,p_debug_msg => 'Insert Record Count: '||l_rec_count);
1338: END IF;
1339:
1340: EXCEPTION

Line 1390: DELETE FROM IGC_CBC_PO_PROCESS_GT ;

1386: IF (g_debug_mode = 'Y') THEN
1387: Put_Debug_Msg (l_full_path,p_debug_msg => '**** Fetch Requisitions ****');
1388: END IF;
1389:
1390: DELETE FROM IGC_CBC_PO_PROCESS_GT ;
1391: -- l_sql_string := 'TRUNCATE table IGC_CBC_PO_PROCESS_GT' ;
1392: -- EXECUTE IMMEDIATE l_sql_string;
1393:
1394: -- Fetch into global temporary table all documents that satisfy our initial selection criteria

Line 1391: -- l_sql_string := 'TRUNCATE table IGC_CBC_PO_PROCESS_GT' ;

1387: Put_Debug_Msg (l_full_path,p_debug_msg => '**** Fetch Requisitions ****');
1388: END IF;
1389:
1390: DELETE FROM IGC_CBC_PO_PROCESS_GT ;
1391: -- l_sql_string := 'TRUNCATE table IGC_CBC_PO_PROCESS_GT' ;
1392: -- EXECUTE IMMEDIATE l_sql_string;
1393:
1394: -- Fetch into global temporary table all documents that satisfy our initial selection criteria
1395: -- Added the OR clause for REQs having

Line 1400: INSERT INTO igc_cbc_po_process_gt

1396: -- backing BPA. In this case the gl_encumbered_date and the
1397: -- cbc accounting date should be updated even though there
1398: -- is no actual encumbrance to be moved.
1399: -- 3173178, Bidisha S
1400: INSERT INTO igc_cbc_po_process_gt
1401: (
1402: document_type,
1403: req_header_id,
1404: line_id,

Line 1439: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;

1435: AND prd.org_id = p_org_id
1436: AND prd.gl_encumbered_date BETWEEN p_prev_year_start_date AND p_prev_year_end_date ;
1437:
1438: IF (g_debug_mode = 'Y') THEN
1439: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;
1440: Put_Debug_Msg (l_full_path,p_debug_msg => 'Insert Record Count: '||l_rec_count);
1441: END IF;
1442:
1443: EXCEPTION

Line 1493: DELETE FROM IGC_CBC_PO_PROCESS_GT ;

1489: IF (g_debug_mode = 'Y') THEN
1490: Put_Debug_Msg (l_full_path,p_debug_msg => '**** Fetch Blanket Agreements ****');
1491: END IF;
1492:
1493: DELETE FROM IGC_CBC_PO_PROCESS_GT ;
1494:
1495: -- Fetch into global temporary table all documents that satisfy our initial selection criteria
1496: INSERT INTO igc_cbc_po_process_gt
1497: (

Line 1496: INSERT INTO igc_cbc_po_process_gt

1492:
1493: DELETE FROM IGC_CBC_PO_PROCESS_GT ;
1494:
1495: -- Fetch into global temporary table all documents that satisfy our initial selection criteria
1496: INSERT INTO igc_cbc_po_process_gt
1497: (
1498: document_type,
1499: po_header_id,
1500: line_id,

Line 1536: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;

1532: AND pod.gl_encumbered_date >= p_prev_year_start_date
1533: AND pod.gl_encumbered_date <= p_prev_year_end_date;
1534:
1535: IF (g_debug_mode = 'Y') THEN
1536: SELECT COUNT(1) INTO l_rec_count FROM igc_cbc_po_process_gt;
1537: Put_Debug_Msg (l_full_path,p_debug_msg => 'Insert Record Count: '||l_rec_count);
1538: END IF;
1539:
1540: EXCEPTION

Line 1618: igc_cbc_po_process_gt tmp

1614: 'IGC_PO_YEP_PO_OVERBILLED')))) result_error_code
1615: FROM ap_invoices ai,
1616: ap_invoice_payments aip,
1617: ap_invoice_distributions aid,
1618: igc_cbc_po_process_gt tmp
1619: WHERE ai.invoice_id = aid.invoice_id
1620: AND aip.invoice_id(+) = ai.invoice_id
1621: AND aid.po_distribution_id = tmp.distribution_id
1622: AND tmp.accrue_on_receipt = 'N'

Line 1646: igc_cbc_po_process_gt tmp

1642: 'IGC_PO_YEP_REL_OVERBILLED')))) result_error_code
1643: FROM ap_invoices ai,
1644: ap_invoice_payments aip,
1645: ap_invoice_distributions aid,
1646: igc_cbc_po_process_gt tmp
1647: WHERE ai.invoice_id = aid.invoice_id
1648: AND aip.invoice_id(+) = ai.invoice_id
1649: AND aid.po_distribution_id = tmp.distribution_id
1650: AND tmp.accrue_on_receipt = 'N'

Line 3228: FROM igc_cbc_po_process_gt

3224: THEN
3225: OPEN c_prev_val FOR SELECT distribution_id,
3226: gl_encumbered_date,
3227: gl_encumbered_period_name
3228: FROM igc_cbc_po_process_gt
3229: WHERE encumbered_flag = 'Y'
3230: AND po_header_id = p_document_id ;
3231: ELSIF p_document_type = 'REL'
3232: THEN

Line 3236: FROM igc_cbc_po_process_gt

3232: THEN
3233: OPEN c_prev_val FOR SELECT distribution_id,
3234: gl_encumbered_date,
3235: gl_encumbered_period_name
3236: FROM igc_cbc_po_process_gt
3237: WHERE encumbered_flag = 'Y'
3238: AND po_release_id = p_document_id ;
3239: ELSIF p_document_type = 'REQ'
3240: THEN

Line 3252: FROM igc_cbc_po_process_gt

3248: -- New for PRC.FP.J - 3173178
3249: OPEN c_prev_val FOR SELECT distribution_id,
3250: gl_encumbered_date,
3251: gl_encumbered_period_name
3252: FROM igc_cbc_po_process_gt
3253: WHERE (encumbered_flag = 'Y'
3254: OR ( prevent_encumbrance_flag = 'Y'
3255: AND blanket_po_header_id IS NOT NULL))
3256: AND req_header_id = p_document_id ;

Line 4792: FROM igc_cbc_po_process_gt tmp

4788: CURSOR c_get_recs(c_p_doc_type VARCHAR2) IS
4789: SELECT DISTINCT tmp.po_release_id,
4790: tmp.po_header_id,
4791: tmp.req_header_id
4792: FROM igc_cbc_po_process_gt tmp
4793: WHERE document_type = c_p_doc_type ;
4794:
4795: l_document_type VARCHAR2(3);
4796: l_po_enc_on BOOLEAN := FALSE;