[Home] [Help]
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,
216: p_enc_amt IN NUMBER,
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;
393: l_enc_date DATE;
468: /* Contract Commitment account lines */
469:
470: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
471: SELECT *
472: FROM igc_cc_acct_lines ccac
473: WHERE ccac.cc_header_id = t_cc_header_id;
474:
475: l_full_path VARCHAR2(255);
476:
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;
1103: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
1106: -- Cursors c_acct_lines and c_det_pf_lines
1107: -- modified for bug 2876467
1108: -- ccdpf.cc_det_pf_billed_amt changed to ccdpf.cc_det_pf_func_billed_amt
1109: -- Performance Tuning project. Replaced selection from views
1110: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1111: -- and igc_cc_det_pf_v with igc_cc_det_pf
1112: -- Replaced the following line as well
1113: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1114: CURSOR c_acct_lines(p_cc_header_id NUMBER)
1113: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
1114: CURSOR c_acct_lines(p_cc_header_id NUMBER)
1115: IS
1116: -- SELECT *
1117: -- FROM igc_cc_acct_lines_v ccal
1118: -- WHERE ccal.cc_header_id = p_cc_header_id
1119: -- AND exists
1120: -- ( Select 'x' FROM igc_cc_det_pf_v ccdpf
1121: -- WHERE ccdpf.cc_acct_line_id = ccal.cc_acct_line_id
1183: ccal.cc_func_withheld_amt,
1184: ccal.cc_ent_withheld_amt,
1185: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(p_cc_header_id, NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
1186: ccal.tax_classif_code -- modified for Ebtax uptake (Bug No-6472296)
1187: FROM igc_cc_acct_lines ccal
1188: WHERE ccal.cc_header_id = p_cc_header_id
1189: AND exists ( SELECT 'x'
1190: FROM igc_cc_det_pf ccdpf
1191: WHERE ccdpf.cc_acct_line_id = ccal.cc_acct_line_id
1339: l_pf_row_id VARCHAR2(18);
1340: l_hist_pf_row_id VARCHAR2(18);
1341: l_action_row_id VARCHAR2(18);
1342: l_new_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
1343: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
1344: l_api_version CONSTANT NUMBER := 1.0;
1345: l_init_msg_list VARCHAR2(1);
1346: l_commit VARCHAR2(1);
1347: l_validation_level NUMBER;
1965: /* Bug No : 6341012. MOAC uptake. Local variable SOB_Name added*/
1966: l_sob_name VARCHAR2(30);
1967:
1968: -- Performance Tuning project. Replaced selection from views
1969: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
1970: -- and igc_cc_det_pf_v with igc_cc_det_pf
1971: -- Replaced the following 2 lines a well
1972: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
1973: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
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
1997: AND cchd.org_id = p_org_id
2014: ) > 0
2015: GROUP BY cchd.cc_header_id, cchd.cc_apprvl_status;
2016:
2017: -- Performance Tuning project. Replaced selection from views
2018: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2019: -- and igc_cc_det_pf_v with igc_cc_det_pf
2020: -- Replaced the following 2 lines a well
2021: -- sum (ccdpf.cc_det_pf_func_amt-ccdpf.cc_det_pf_func_billed_amt) tot_unbilled_amt
2022: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
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
2045: AND cchd.org_id = p_org_id
2071: AND ccpd.process_type = l_process_type
2072: AND (ccpd.processed <> 'Y' OR ccpd.processed IS NULL);
2073:
2074: -- Performance Tuning project. Replaced selection from views
2075: -- igc_cc_acct_lines_v with table igc_cc_acct_lines
2076: -- and igc_cc_det_pf_v with igc_cc_det_pf
2077: -- Replaced the following line as well
2078: -- AND (NVL(ccdpf.cc_det_pf_func_amt,0) - NVL(ccdpf.cc_det_pf_func_billed_amt,0) ) > 0
2079: CURSOR c4 (
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
2096: AND cchd.cc_header_id = ccal.cc_header_id
2136: )
2137: IS
2138: SELECT ccdpf.cc_acct_line_id, ccdpf.cc_det_pf_line_id,
2139: ccdpf.cc_det_pf_date
2140: FROM igc_cc_acct_lines ccal,
2141: igc_cc_det_pf ccdpf
2142: WHERE ccal.cc_header_id = p_cc_header_id
2143: AND ccal.cc_acct_line_id = ccdpf.cc_acct_line_id
2144: AND ccdpf.cc_det_pf_date >= p_start_date
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'
2176: -- FROM igc_cc_acct_lines_v ccal1
2177: -- WHERE ccal1.cc_header_id = cchd.cc_header_id
2178: -- AND NOT EXISTS (SELECT 'X'
2179: -- FROM igc_cc_det_pf_v ccdpf1
2180: -- WHERE ccdpf1.cc_acct_line_id = ccal1.cc_acct_line_id