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_REVAL_FIX_PROCESS_PKG dependencies on IGC_CC_ACCT_LINES

Line 38: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

34: p_cc_header_id IN NUMBER
35: ) RETURN BOOLEAN
36: IS
37: l_cc_headers_rec igc_cc_headers%ROWTYPE;
38: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
39: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
40:
41: /* Contract Commitment detail payment forecast */
42: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS

Line 99: -- view igc_cc_acct_lines_v. Instead of selecting from the view,

95: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
96: -- Replaced the folllowing query with the one below for
97: -- performance tuning fixes.
98: -- The record definition of l_cc_acct_lines_rec is still based on
99: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
100: -- select is being done from the base table, but all the columns
101: -- as defined in the view are retained even though they are not used.
102: -- This is just so that minimal change is made to the code.
103: /*

Line 105: FROM igc_cc_acct_lines_v ccac

101: -- as defined in the view are retained even though they are not used.
102: -- This is just so that minimal change is made to the code.
103: /*
104: SELECT *
105: FROM igc_cc_acct_lines_v ccac
106: WHERE ccac.cc_header_id = t_cc_header_id;
107: */
108:
109: SELECT ccal.ROWID,

Line 172: FROM igc_cc_acct_lines ccal

168: ccal.cc_ent_withheld_amt,
169: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
170: NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
171: ccal.TAX_CLASSIF_CODE /* Bug 6472296 for r12 EBtax uptake for CC */
172: FROM igc_cc_acct_lines ccal
173: WHERE ccal.cc_header_id = t_cc_header_id;
174:
175: reval_fix BOOLEAN := FALSE;
176:

Line 630: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

626: IS
627:
628: l_cc_headers_rec igc_cc_headers%ROWTYPE;
629: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
630: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
631: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
632: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
633: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
634:

Line 641: -- view igc_cc_acct_lines_v. Instead of selecting from the view,

637: IS
638: -- Replaced the folllowing query with the one below for
639: -- performance tuning fixes.
640: -- The record definition of l_cc_acct_lines_rec is still based on
641: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
642: -- select is being done from the base table, but all the columns
643: -- as defined in the view are retained even though they are not used.
644: -- This is just so that minimal change is made to the code.
645:

Line 647: -- FROM igc_cc_acct_lines_v

643: -- as defined in the view are retained even though they are not used.
644: -- This is just so that minimal change is made to the code.
645:
646: -- SELECT *
647: -- FROM igc_cc_acct_lines_v
648: -- WHERE cc_header_id = p_cc_header_id;
649:
650:
651: SELECT ccal.ROWID,

Line 714: FROM igc_cc_acct_lines ccal

710: ccal.cc_ent_withheld_amt,
711: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
712: NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
713: ccal.TAX_CLASSIF_CODE /* Bug No : 6341012. E-BTax uptake.New field is ebing added to Account_Lines Table R12 */
714: FROM igc_cc_acct_lines ccal
715: WHERE cc_header_id = p_cc_header_id;
716:
717: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
718: IS

Line 777: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

773: l_action_row_id VARCHAR2(18);
774:
775:
776: l_new_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
777: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
778:
779: l_api_version CONSTANT NUMBER := 1.0;
780: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
781: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 800: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

796: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
797: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
798: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
799:
800: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
801: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
802: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
803:
804: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;

Line 801: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;

797: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
798: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
799:
800: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
801: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
802: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
803:
804: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
805: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;

Line 802: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;

798: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
799:
800: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
801: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
802: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
803:
804: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
805: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;
806: l_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;

Line 811: l_cc_acct_func_amt_total igc_cc_acct_lines.cc_acct_func_amt%TYPE;

807: l_cc_det_pf_encmbrnc_amt igc_cc_det_pf.cc_det_pf_encmbrnc_amt%TYPE;
808:
809: l_det_pf_func_amt_total igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
810:
811: l_cc_acct_func_amt_total igc_cc_acct_lines.cc_acct_func_amt%TYPE;
812:
813: l_rel_conversion_rate igc_cc_headers.conversion_rate%TYPE;
814:
815: BEGIN

Line 955: igc_cc_acct_lines b

951: - (a.cc_det_pf_func_amt - IGC_CC_COMP_AMT_PKG.COMPUTE_PF_FUNC_BILLED_AMT(a.cc_det_pf_line_id, a.cc_det_pf_line_num, a.cc_acct_line_id))
952: )
953: INTO l_det_pf_func_amt_total
954: FROM igc_cc_det_pf a,
955: igc_cc_acct_lines b
956: WHERE a.parent_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
957: a.cc_acct_line_id = b.cc_acct_line_id AND
958: b.cc_header_id = p_rel_cc_header_id;
959: EXCEPTION

Line 1259: FROM igc_cc_acct_lines

1255: END IF;
1256:
1257: SELECT rowid
1258: INTO l_acct_row_id
1259: FROM igc_cc_acct_lines
1260: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
1261:
1262: IGC_CC_ACCT_LINES_PKG.Update_Row(
1263: l_api_version ,

Line 1262: IGC_CC_ACCT_LINES_PKG.Update_Row(

1258: INTO l_acct_row_id
1259: FROM igc_cc_acct_lines
1260: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
1261:
1262: IGC_CC_ACCT_LINES_PKG.Update_Row(
1263: l_api_version ,
1264: l_init_msg_list,
1265: l_commit,
1266: l_validation_level,

Line 1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1607: p_revalue_fix_date IN VARCHAR2)
1608: IS
1609: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:

Line 1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1608: IS
1609: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:
1616: /*Bug No : 6341012. MOAC Uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */

Line 1735: -- view igc_cc_acct_lines_v. Instead of selecting from the view,

1731: IS
1732: -- Replaced the folllowing query with the one below for
1733: -- performance tuning fixes.
1734: -- The record definition of l_cc_acct_lines_rec is still based on
1735: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
1736: -- select is being done from the base table, but all the columns
1737: -- as defined in the view are retained even though they are not used.
1738: -- This is just so that minimal change is made to the code.
1739: /*

Line 1741: FROM igc_cc_acct_lines_v

1737: -- as defined in the view are retained even though they are not used.
1738: -- This is just so that minimal change is made to the code.
1739: /*
1740: SELECT *
1741: FROM igc_cc_acct_lines_v
1742: WHERE cc_header_id = p_cc_header_id;
1743: */
1744:
1745: SELECT ccal.ROWID,

Line 1808: FROM igc_cc_acct_lines ccal

1804: ccal.cc_ent_withheld_amt,
1805: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
1806: NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
1807: ccal.TAX_CLASSIF_CODE /* Bug No : 6341012. E-BTax uptake.New field is ebing added to Account_Lines Table R12 */
1808: FROM igc_cc_acct_lines ccal
1809: WHERE cc_header_id = p_cc_header_id;
1810:
1811: CURSOR C_PF_LINES(p_cc_acct_line_id NUMBER)
1812: IS

Line 1862: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

1858: WHERE ccdpf.cc_acct_line_id = p_cc_acct_line_id;
1859:
1860: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1861: l_rel_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1862: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
1863: l_debug VARCHAR2(1);
1864:
1865: insert_data EXCEPTION;
1866: BEGIN

Line 2480: FROM igc_cc_acct_lines a,

2476:
2477: BEGIN
2478: SELECT NVL(SUM(NVL(CC_ACCT_FUNC_AMT,0)),0)
2479: INTO l_non_reval_acct_amt_total
2480: FROM igc_cc_acct_lines a,
2481: igc_cc_headers b
2482: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
2483: a.cc_header_id = b.cc_header_id AND
2484: NVL(b.parent_header_id,0) = l_cc_header_id AND

Line 2508: FROM igc_cc_acct_lines a,

2504: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( a.cc_acct_line_id))
2505: )
2506: )
2507: INTO l_reval_acct_amt_total
2508: FROM igc_cc_acct_lines a,
2509: igc_cc_headers b
2510: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
2511: a.cc_header_id = b.cc_header_id AND
2512: b.cc_header_id = p_cc_header_id;

Line 2547: igc_cc_acct_lines b,

2543: BEGIN
2544: SELECT SUM(NVL(CC_DET_PF_FUNC_AMT,0))
2545: INTO l_non_reval_pf_amt_total
2546: FROM igc_cc_det_pf a,
2547: igc_cc_acct_lines b,
2548: igc_cc_headers c
2549: WHERE NVL(a.parent_acct_line_id,0) =
2550: l_cc_acct_lines_rec.cc_acct_line_id AND
2551: NVL(a.parent_det_pf_line_id,0) =

Line 2579: igc_cc_acct_lines b,

2575: )
2576: )
2577: INTO l_reval_pf_amt_total
2578: FROM igc_cc_det_pf a,
2579: igc_cc_acct_lines b,
2580: igc_cc_headers c
2581: WHERE NVL(a.parent_acct_line_id,0) =
2582: l_cc_acct_lines_rec.cc_acct_line_id AND
2583: NVL(a.parent_det_pf_line_id,0) =