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

Line 435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

431: IS
432:
433: l_cc_headers_rec igc_cc_headers%ROWTYPE;
434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
437:
438: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
439: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;

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

442: IS
443: -- Replaced the folllowing query with the one below for
444: -- performance tuning fixes.
445: -- The record definition of l_cc_acct_lines_rec is still based on
446: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
447: -- select is being done from the base table, but all the columns
448: -- as defined in the view are retained even though they are not used.
449: -- This is just so that minimal change is made to the code.
450: /*

Line 452: FROM igc_cc_acct_lines_v

448: -- as defined in the view are retained even though they are not used.
449: -- This is just so that minimal change is made to the code.
450: /*
451: SELECT *
452: FROM igc_cc_acct_lines_v
453: WHERE cc_header_id = p_cc_header_id;
454: */
455:
456: SELECT ccal.ROWID,

Line 519: FROM igc_cc_acct_lines ccal

515: ccal.cc_ent_withheld_amt,
516: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
517: NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
518: ccal.tax_classif_code -- added Bug 6472296 Ebtax uptake for cc
519: FROM igc_cc_acct_lines ccal
520: WHERE ccal.cc_header_id = p_cc_header_id;
521:
522: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
523: IS

Line 583: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

579: l_action_row_id VARCHAR2(18);
580:
581:
582: l_new_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
583: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
584:
585: l_api_version CONSTANT NUMBER := 1.0;
586: l_init_msg_list VARCHAR2(1);
587: l_commit VARCHAR2(1);

Line 606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
608: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
609:
610: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;

Line 607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;

603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
608: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
609:
610: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
611: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;

Line 608: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;

604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
608: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;
609:
610: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
611: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;
612: l_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;

Line 616: l_new_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;

612: l_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
613: l_cc_det_pf_encmbrnc_amt igc_cc_det_pf.cc_det_pf_encmbrnc_amt%TYPE;
614:
615: -- bug 2043221 ssmales - added two variable declarations below
616: l_new_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
617: l_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
618:
619:
620: BEGIN

Line 617: l_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;

613: l_cc_det_pf_encmbrnc_amt igc_cc_det_pf.cc_det_pf_encmbrnc_amt%TYPE;
614:
615: -- bug 2043221 ssmales - added two variable declarations below
616: l_new_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
617: l_cc_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
618:
619:
620: BEGIN
621:

Line 881: FROM igc_cc_acct_lines

877: END IF;
878:
879: SELECT rowid
880: INTO l_acct_row_id
881: FROM igc_cc_acct_lines
882: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
883:
884: IGC_CC_ACCT_LINES_PKG.Update_Row(
885: l_api_version ,

Line 884: IGC_CC_ACCT_LINES_PKG.Update_Row(

880: INTO l_acct_row_id
881: FROM igc_cc_acct_lines
882: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
883:
884: IGC_CC_ACCT_LINES_PKG.Update_Row(
885: l_api_version ,
886: l_init_msg_list,
887: l_commit,
888: l_validation_level,

Line 1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1586: p_cc_header_id IN NUMBER)
1587: IS
1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1594: l_err_header_id NUMBER;

Line 1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

1587: IS
1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1594: l_err_header_id NUMBER;
1595: l_err_acct_line_id NUMBER;

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

1770: IS
1771: -- Replaced the folllowing query with the one below for
1772: -- performance tuning fixes.
1773: -- The record definition of l_cc_acct_lines_rec is still based on
1774: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
1775: -- select is being done from the base table, but all the columns
1776: -- as defined in the view are retained even though they are not used.
1777: -- This is just so that minimal change is made to the code.
1778: /*

Line 1780: FROM igc_cc_acct_lines_v

1776: -- as defined in the view are retained even though they are not used.
1777: -- This is just so that minimal change is made to the code.
1778: /*
1779: SELECT *
1780: FROM igc_cc_acct_lines_v
1781: WHERE cc_header_id = p_cc_header_id;
1782: */
1783:
1784: SELECT ccal.ROWID,

Line 1847: FROM igc_cc_acct_lines ccal

1843: ccal.cc_ent_withheld_amt,
1844: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id,
1845: NVL(ccal.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
1846: ccal.tax_classif_code -- added for Bug 6472296 Ebtax uptake for cc
1847: FROM igc_cc_acct_lines ccal
1848: WHERE cc_header_id = p_cc_header_id;
1849:
1850: CURSOR C_PF_LINES(p_cc_acct_line_id NUMBER)
1851: IS

Line 1904: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

1900:
1901:
1902: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1903: l_rel_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1904: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
1905:
1906: insert_data EXCEPTION;
1907: BEGIN
1908:

Line 3049: FROM igc_cc_acct_lines a,

3045:
3046: BEGIN
3047: SELECT NVL(SUM(NVL(CC_ACCT_FUNC_AMT,0)),0)
3048: INTO l_non_reval_acct_amt_total
3049: FROM igc_cc_acct_lines a,
3050: igc_cc_headers b
3051: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3052: a.cc_header_id = b.cc_header_id AND
3053: NVL(b.parent_header_id,0) = l_cc_header_id AND

Line 3083: --FROM igc_cc_acct_lines_v a,

3079: ) * (l_rate - b.conversion_rate )
3080: )
3081: )
3082: INTO l_reval_acct_amt_total
3083: --FROM igc_cc_acct_lines_v a,
3084: FROM igc_cc_acct_lines a,
3085: igc_cc_headers b
3086: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3087: a.cc_header_id = b.cc_header_id AND

Line 3084: FROM igc_cc_acct_lines a,

3080: )
3081: )
3082: INTO l_reval_acct_amt_total
3083: --FROM igc_cc_acct_lines_v a,
3084: FROM igc_cc_acct_lines a,
3085: igc_cc_headers b
3086: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3087: a.cc_header_id = b.cc_header_id AND
3088: b.cc_header_id = p_cc_header_id;

Line 3134: FROM igc_cc_acct_lines a,

3130:
3131: BEGIN
3132: SELECT NVL(SUM(NVL(CC_ACCT_FUNC_AMT,0)),0)
3133: INTO l_non_reval_acct_amt_total
3134: FROM igc_cc_acct_lines a,
3135: igc_cc_headers b
3136: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3137: a.cc_header_id = b.cc_header_id AND
3138: NVL(b.parent_header_id,0) = l_cc_header_id AND

Line 3169: --FROM igc_cc_acct_lines_v a,

3165: ) * (l_rate - b.conversion_rate )
3166: )
3167: )
3168: INTO l_reval_acct_amt_total
3169: --FROM igc_cc_acct_lines_v a,
3170: FROM igc_cc_acct_lines a,
3171: igc_cc_headers b
3172: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3173: a.cc_header_id = b.cc_header_id AND

Line 3170: FROM igc_cc_acct_lines a,

3166: )
3167: )
3168: INTO l_reval_acct_amt_total
3169: --FROM igc_cc_acct_lines_v a,
3170: FROM igc_cc_acct_lines a,
3171: igc_cc_headers b
3172: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3173: a.cc_header_id = b.cc_header_id AND
3174: NVL(b.parent_header_id,0) = l_cc_header_id AND

Line 3215: FROM igc_cc_acct_lines a,

3211:
3212: BEGIN
3213: SELECT SUM(NVL(CC_ACCT_FUNC_AMT,0))
3214: INTO l_non_reval_acct_amt_total
3215: FROM igc_cc_acct_lines a,
3216: igc_cc_headers b
3217: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3218: NVL(b.parent_header_id,0) = l_cc_header_id AND
3219: a.cc_header_id = b.cc_header_id AND

Line 3250: --FROM igc_cc_acct_lines_v a,

3246: ) * (l_rate - b.conversion_rate )
3247: )
3248: )
3249: INTO l_reval_acct_amt_total
3250: --FROM igc_cc_acct_lines_v a,
3251: FROM igc_cc_acct_lines a,
3252: igc_cc_headers b
3253: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3254: a.cc_header_id = b.cc_header_id AND

Line 3251: FROM igc_cc_acct_lines a,

3247: )
3248: )
3249: INTO l_reval_acct_amt_total
3250: --FROM igc_cc_acct_lines_v a,
3251: FROM igc_cc_acct_lines a,
3252: igc_cc_headers b
3253: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3254: a.cc_header_id = b.cc_header_id AND
3255: ( (b.currency_code = p_currency_code) AND

Line 3343: igc_cc_acct_lines b,

3339: BEGIN
3340: SELECT NVL(SUM(NVL(CC_DET_PF_FUNC_AMT,0)),0)
3341: INTO l_non_reval_pf_amt_total
3342: FROM igc_cc_det_pf a,
3343: igc_cc_acct_lines b,
3344: igc_cc_headers c
3345: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3346: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3347: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3384: igc_cc_acct_lines b,

3380: )
3381: )
3382: INTO l_reval_pf_amt_total
3383: FROM igc_cc_det_pf a,
3384: igc_cc_acct_lines b,
3385: igc_cc_headers c
3386: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3387: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3388: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3430: igc_cc_acct_lines b,

3426: BEGIN
3427: SELECT SUM(NVL(CC_DET_PF_FUNC_AMT,0))
3428: INTO l_non_reval_pf_amt_total
3429: FROM igc_cc_det_pf a,
3430: igc_cc_acct_lines b,
3431: igc_cc_headers c
3432: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3433: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3434: NVL(c.parent_header_id,0) = l_cc_header_id AND

Line 3472: igc_cc_acct_lines b,

3468: )
3469: )
3470: INTO l_reval_pf_amt_total
3471: FROM igc_cc_det_pf a,
3472: igc_cc_acct_lines b,
3473: igc_cc_headers c
3474: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3475: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3476: NVL(c.parent_header_id,0) = l_cc_header_id AND

Line 3523: igc_cc_acct_lines b,

3519: BEGIN
3520: SELECT NVL(SUM(NVL(CC_DET_PF_FUNC_AMT,0)),0)
3521: INTO l_non_reval_pf_amt_total
3522: FROM igc_cc_det_pf a,
3523: igc_cc_acct_lines b,
3524: igc_cc_headers c
3525: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3526: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3527: NVL(c.parent_header_id,0) = l_cc_header_id AND

Line 3565: igc_cc_acct_lines b,

3561: )
3562: )
3563: INTO l_reval_pf_amt_total
3564: FROM igc_cc_det_pf a,
3565: igc_cc_acct_lines b,
3566: igc_cc_headers c
3567: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3568: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3569: NVL(c.parent_header_id,0) = l_cc_header_id AND