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_MPFS_PROCESS_PKG dependencies on IGC_CC_HEADERS

Line 211: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,

207: PROCEDURE Process_Interface_Row(
208: p_currency_code IN VARCHAR2,
209: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_Ids are not required*/
210: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
211: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
212: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
213: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,
214: p_enc_type IN VARCHAR2,
215: p_enc_date IN DATE,

Line 388: l_cc_headers_rec igc_cc_headers%ROWTYPE;

384: ) RETURN VARCHAR2
385: IS
386: l_interface_row_count NUMBER;
387:
388: l_cc_headers_rec igc_cc_headers%ROWTYPE;
389: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
390: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
391:
392: l_enc_amt NUMBER := 0;

Line 489: FROM igc_cc_headers

485: BEGIN
486:
487: SELECT *
488: INTO l_cc_headers_rec
489: FROM igc_cc_headers
490: WHERE cc_header_id = p_cc_header_id;
491:
492: EXCEPTION
493:

Line 1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;

1094: l_error_message OUT NOCOPY VARCHAR2
1095: )
1096: RETURN VARCHAR2
1097: IS
1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;
1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;

Line 1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;

1098: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1099: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1100: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1101: l_cc_pf_target igc_cc_det_pf_v%ROWTYPE;
1102: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1103: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
1104: l_DUMMY VARCHAR2(1);
1105:
1106: -- Cursors c_acct_lines and c_det_pf_lines

Line 1356: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;

1352: l_approval_status igc_cc_process_data.old_approval_status%TYPE;
1353: l_Last_Updated_By NUMBER;
1354: l_Last_Update_Login NUMBER;
1355: l_Created_By NUMBER;
1356: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
1357: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
1358: l_full_path VARCHAR2(255);
1359: BEGIN
1360: l_init_msg_list := FND_API.G_FALSE;

Line 1357: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;

1353: l_Last_Updated_By NUMBER;
1354: l_Last_Update_Login NUMBER;
1355: l_Created_By NUMBER;
1356: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
1357: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
1358: l_full_path VARCHAR2(255);
1359: BEGIN
1360: l_init_msg_list := FND_API.G_FALSE;
1361: l_commit := FND_API.G_FALSE;

Line 1374: FROM igc_cc_headers

1370: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Begin MPFS_UPDATE '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1371: END IF;
1372: SELECT *
1373: INTO l_cc_headers_rec
1374: FROM igc_cc_headers
1375: WHERE cc_header_id = p_cc_header_id
1376: FOR UPDATE NOWAIT;
1377:
1378: SELECT old_approval_status

Line 1717: FROM igc_cc_headers

1713: l_cc_version_num:= l_cc_headers_rec.CC_VERSION_NUM + 1;
1714:
1715: SELECT rowid
1716: INTO l_hdr_row_id
1717: FROM igc_cc_headers
1718: WHERE CC_HEADER_ID = l_cc_headers_rec.cc_header_id;
1719:
1720: IGC_CC_HEADERS_PKG.Update_Row(
1721: l_api_version,

Line 1720: IGC_CC_HEADERS_PKG.Update_Row(

1716: INTO l_hdr_row_id
1717: FROM igc_cc_headers
1718: WHERE CC_HEADER_ID = l_cc_headers_rec.cc_header_id;
1719:
1720: IGC_CC_HEADERS_PKG.Update_Row(
1721: l_api_version,
1722: l_init_msg_list,
1723: l_commit,
1724: l_validation_level,

Line 1810: -- FROM igc_cc_headers cchd,

1806: -- SELECT 'Y'
1807: -- INTO l_DUMMY
1808: -- FROM po_headers pha1
1809: -- WHERE pha1.po_header_id = (SELECT pha2.po_header_id
1810: -- FROM igc_cc_headers cchd,
1811: -- po_headers pha2
1812: -- WHERE cchd.org_id = p_org_id
1813: -- AND cchd.cc_header_id = l_cc_headers_rec.cc_header_id
1814: -- AND cchd.cc_num = pha2.segment1

Line 1819: igc_cc_headers cchd

1815: -- AND pha2.type_lookup_code = 'STANDARD');
1816: SELECT 'Y'
1817: INTO l_dummy
1818: FROM po_headers_all pha1,
1819: igc_cc_headers cchd
1820: WHERE cchd.org_id = p_org_id
1821: AND cchd.cc_header_id = l_cc_headers_rec.cc_header_id
1822: AND cchd.cc_num = pha1.segment1
1823: AND pha1.type_lookup_code = 'STANDARD'

Line 1992: FROM igc_cc_headers cchd,

1988: ccdpf.cc_det_pf_line_num,
1989: ccdpf.cc_acct_line_id
1990: )
1991: ) tot_unbilled_amt
1992: FROM igc_cc_headers cchd,
1993: igc_cc_acct_lines ccal,
1994: igc_cc_det_pf ccdpf
1995: WHERE cchd.cc_header_id = ccal.cc_header_id
1996: AND ccal.cc_acct_line_id = ccdpf.cc_acct_line_id

Line 2040: FROM igc_cc_headers cchd,

2036: ccdpf.cc_det_pf_line_num,
2037: ccdpf.cc_acct_line_id
2038: )
2039: ) tot_unbilled_amt
2040: FROM igc_cc_headers cchd,
2041: igc_cc_acct_lines ccal,
2042: igc_cc_det_pf ccdpf
2043: WHERE cchd.cc_header_id = ccal.cc_header_id
2044: AND ccal.cc_acct_line_id = ccdpf.cc_acct_line_id

Line 2091: FROM igc_cc_headers cchd,

2087: )
2088: IS
2089: SELECT cchd.cc_header_id, cchd.cc_num, ccdpf.cc_acct_line_id,
2090: ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_date
2091: FROM igc_cc_headers cchd,
2092: igc_cc_acct_lines ccal,
2093: igc_cc_det_pf ccdpf,
2094: igc_cc_process_data ccpd
2095: WHERE cchd.cc_header_id = ccpd.cc_header_id

Line 2122: FROM igc_cc_headers cchd,

2118: p_process_type VARCHAR2
2119: )
2120: IS
2121: SELECT cchd.cc_header_id, cchd.cc_num
2122: FROM igc_cc_headers cchd,
2123: igc_cc_process_data ccpd
2124: WHERE cchd.cc_header_id = ccpd.cc_header_id
2125: AND cchd.org_id = l_org_id
2126: AND cchd.set_of_books_id = l_sob_id

Line 2171: -- FROM igc_cc_headers cchd

2167: */
2168: --CURSOR C6 (p_cc_header_id NUMBER,p_target_date DATE,p_org_id NUMBER,p_sob_id NUMBER)
2169: --IS
2170: -- SELECT cchd.cc_header_id
2171: -- FROM igc_cc_headers cchd
2172: -- WHERE cchd.cc_header_id = p_cc_header_id
2173: -- AND cchd.org_id = p_org_id
2174: -- AND cchd.set_of_books_id = p_sob_id
2175: -- AND NOT EXISTS (SELECT 'X'

Line 2265: l_header_id igc_cc_headers.cc_header_id%TYPE;

2261: l_debug VARCHAR2 (1);
2262: l_rec_found NUMBER;
2263: l_valid_params VARCHAR2 (1);
2264: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
2265: l_header_id igc_cc_headers.cc_header_id%TYPE;
2266: l_cc_num igc_cc_headers.cc_num%TYPE;
2267: l_lock_cc_status BOOLEAN;
2268: l_lock_po_status BOOLEAN;
2269: l_budg_status BOOLEAN;

Line 2266: l_cc_num igc_cc_headers.cc_num%TYPE;

2262: l_rec_found NUMBER;
2263: l_valid_params VARCHAR2 (1);
2264: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
2265: l_header_id igc_cc_headers.cc_header_id%TYPE;
2266: l_cc_num igc_cc_headers.cc_num%TYPE;
2267: l_lock_cc_status BOOLEAN;
2268: l_lock_po_status BOOLEAN;
2269: l_budg_status BOOLEAN;
2270: l_cc_inprocess VARCHAR2 (1);

Line 2279: l_previous_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;

2275: l_source_pf_gl_prd VARCHAR2 (1);
2276: l_target_pf_found VARCHAR2 (1);
2277: l_tgt_gl_open VARCHAR2 (1);
2278: l_tgt_cc_open VARCHAR2 (1);
2279: l_previous_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2280: l_dummy VARCHAR2 (1);
2281: l_result_of_reservation igc_cc_process_data.reservation_status%TYPE;
2282: l_result_mpfs_update VARCHAR2 (1);
2283: l_return_status VARCHAR2 (1);

Line 2892: FROM igc_cc_headers cchd

2888: EXIT WHEN c4%NOTFOUND;
2889:
2890: SELECT cc_apprvl_status
2891: INTO l_previous_apprvl_status
2892: FROM igc_cc_headers cchd
2893: WHERE cchd.cc_header_id = v4.cc_header_id;
2894:
2895: -- Bug 1632539 Fixed
2896: IF l_previous_apprvl_status = 'IP'

Line 3362: FROM igc_cc_headers

3358: EXIT WHEN c4_1%NOTFOUND;
3359:
3360: SELECT cc_num
3361: INTO l_cc_num
3362: FROM igc_cc_headers
3363: WHERE cc_header_id = v4_1.cc_header_id;
3364:
3365: IF (g_debug_mode = 'Y')
3366: THEN

Line 3497: FROM igc_cc_headers cchd

3493: END IF;
3494:
3495: SELECT cc_apprvl_status
3496: INTO l_previous_apprvl_status
3497: FROM igc_cc_headers cchd
3498: WHERE cchd.cc_header_id = v4_1.cc_header_id;
3499:
3500: -- Bug 1632539 Fixed
3501: IF l_previous_apprvl_status = 'IP'

Line 4047: UPDATE igc_cc_headers cchd

4043: AND ccpd.request_id = l_request_id1
4044: AND ccpd.process_type = l_process_type;
4045:
4046: /* If contract passes the validation phase then change the status to IN-PROCESS */
4047: UPDATE igc_cc_headers cchd
4048: SET cchd.cc_apprvl_status = 'IP'
4049: WHERE cchd.cc_header_id = v4.cc_header_id;
4050:
4051: /*Change PO Status */

Line 4061: -- FROM igc_cc_headers cchd,

4057: -- SELECT 'Y'
4058: -- INTO l_DUMMY
4059: -- FROM po_headers pha1
4060: -- WHERE pha1.po_header_id = (SELECT pha2.po_header_id
4061: -- FROM igc_cc_headers cchd,
4062: -- po_headers pha2
4063: -- WHERE cchd.org_id = l_org_id
4064: -- AND cchd.cc_header_id = V4.cc_header_id
4065: -- AND cchd.cc_num = pha2.segment1

Line 4069: FROM po_headers_all pha1, igc_cc_headers cchd

4065: -- AND cchd.cc_num = pha2.segment1
4066: -- AND pha2.type_lookup_code = 'STANDARD');
4067: SELECT 'Y'
4068: INTO l_dummy
4069: FROM po_headers_all pha1, igc_cc_headers cchd
4070: WHERE cchd.org_id = l_org_id
4071: AND cchd.cc_header_id = v4_1.cc_header_id
4072: AND cchd.cc_num = pha1.segment1
4073: AND pha1.type_lookup_code = 'STANDARD'

Line 4082: -- FROM po_headers pha2, igc_cc_headers cchd

4078: -- UPDATE po_headers pha1
4079: -- SET pha1.approved_flag = 'N'
4080: -- WHERE (pha1.segment1,pha1.org_id,pha1.type_lookup_code) IN
4081: -- (SELECT pha2.segment1,pha2.org_id,pha2.type_lookup_code
4082: -- FROM po_headers pha2, igc_cc_headers cchd
4083: -- WHERE cchd.cc_header_id = V4.cc_header_id
4084: -- AND pha2.segment1 = cchd.cc_num
4085: -- AND pha2.org_id = cchd.org_id
4086: -- AND pha2.type_lookup_code = 'STANDARD');

Line 4093: FROM igc_cc_headers cchd

4089: WHERE pha1.type_lookup_code = 'STANDARD'
4090: AND pha1.org_id = l_org_id
4091: AND pha1.segment1 =
4092: (SELECT cchd.cc_num
4093: FROM igc_cc_headers cchd
4094: WHERE cchd.cc_header_id = v4_1.cc_header_id);
4095: EXCEPTION
4096: WHEN NO_DATA_FOUND
4097: THEN

Line 4291: UPDATE igc_cc_headers cchd

4287: AND ccpd.org_id = l_org_id
4288: AND ccpd.process_type = l_process_type;
4289: END IF;
4290:
4291: UPDATE igc_cc_headers cchd
4292: SET cchd.cc_apprvl_status = v5.old_approval_status
4293: WHERE cchd.cc_header_id = v5.cc_header_id;
4294:
4295: IF v5.old_approval_status = 'AP'

Line 4304: -- FROM igc_cc_headers cchd,

4300: -- SELECT 'Y'
4301: -- INTO l_DUMMY
4302: -- FROM po_headers pha1
4303: -- WHERE pha1.po_header_id = (SELECT pha2.po_header_id
4304: -- FROM igc_cc_headers cchd,
4305: -- po_headers pha2
4306: -- WHERE cchd.org_id = l_org_id
4307: -- AND cchd.cc_header_id = V5.cc_header_id
4308: -- AND cchd.cc_num = pha2.segment1

Line 4312: FROM po_headers_all pha1, igc_cc_headers cchd

4308: -- AND cchd.cc_num = pha2.segment1
4309: -- AND pha2.type_lookup_code = 'STANDARD');
4310: SELECT 'Y'
4311: INTO l_dummy
4312: FROM po_headers_all pha1, igc_cc_headers cchd
4313: WHERE cchd.org_id = l_org_id
4314: AND cchd.cc_header_id = v5.cc_header_id
4315: AND cchd.cc_num = pha1.segment1
4316: AND pha1.type_lookup_code = 'STANDARD'

Line 4325: -- FROM po_headers pha2, igc_cc_headers cchd

4321: -- UPDATE po_headers pha1
4322: -- SET pha1.approved_flag = 'Y'
4323: -- WHERE (pha1.segment1,pha1.org_id,pha1.type_lookup_code) IN
4324: -- (SELECT pha2.segment1,pha2.org_id,pha2.type_lookup_code
4325: -- FROM po_headers pha2, igc_cc_headers cchd
4326: -- WHERE cchd.cc_header_id = V5.cc_header_id
4327: -- AND pha2.segment1 = cchd.cc_num
4328: -- AND pha2.org_id = cchd.org_id
4329: -- AND pha2.type_lookup_code = 'STANDARD');

Line 4336: FROM igc_cc_headers cchd

4332: WHERE pha1.type_lookup_code = 'STANDARD'
4333: AND pha1.org_id = l_org_id
4334: AND pha1.segment1 =
4335: (SELECT cchd.cc_num
4336: FROM igc_cc_headers cchd
4337: WHERE cchd.cc_header_id = v5.cc_header_id);
4338: EXCEPTION
4339: WHEN NO_DATA_FOUND
4340: THEN