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_DET_PF

Line 436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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;
440:

Line 525: -- FROM igc_cc_det_pf_v

521:
522: CURSOR c_pf_lines(p_cc_acct_line_id NUMBER)
523: IS
524: -- SELECT *
525: -- FROM igc_cc_det_pf_v
526: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
527:
528: SELECT ccdpf.ROWID,
529: ccdpf.cc_det_pf_line_id,

Line 568: FROM igc_cc_det_pf ccdpf

564: ccdpf.last_updated_by,
565: ccdpf.last_update_login,
566: ccdpf.creation_date,
567: ccdpf.created_by
568: FROM igc_cc_det_pf ccdpf
569: WHERE cc_acct_line_id = p_cc_acct_line_id
570: AND ccdpf.cc_det_pf_entered_amt <> IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(ccdpf.cc_det_pf_line_id,ccdpf.cc_det_pf_line_num,
571: ccdpf.cc_acct_line_id); -- Bug 3856265
572:

Line 582: l_new_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;

578: l_hist_pf_row_id VARCHAR2(18);
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);

Line 610: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;

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;
613: l_cc_det_pf_encmbrnc_amt igc_cc_det_pf.cc_det_pf_encmbrnc_amt%TYPE;
614:

Line 611: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%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;
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

Line 612: l_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%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;
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;

Line 613: l_cc_det_pf_encmbrnc_amt igc_cc_det_pf.cc_det_pf_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;
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;

Line 976: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(

972: /* Update PF Line History */
973:
974: l_return_status := FND_API.G_RET_STS_SUCCESS;
975:
976: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
977: l_api_version,
978: l_init_msg_list,
979: l_commit,
980: l_validation_level,

Line 1092: FROM igc_cc_det_pf

1088: l_cc_det_pf_func_amt := l_new_cc_det_pf_func_amt;
1089:
1090: SELECT rowid
1091: INTO l_pf_row_id
1092: FROM igc_cc_det_pf
1093: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
1094:
1095: IGC_CC_DET_PF_PKG.Update_Row(
1096: l_api_version,

Line 1095: IGC_CC_DET_PF_PKG.Update_Row(

1091: INTO l_pf_row_id
1092: FROM igc_cc_det_pf
1093: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
1094:
1095: IGC_CC_DET_PF_PKG.Update_Row(
1096: l_api_version,
1097: l_init_msg_list,
1098: l_commit,
1099: l_validation_level,

Line 1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

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;
1596: l_err_det_pf_line_id NUMBER;

Line 1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%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;
1596: l_err_det_pf_line_id NUMBER;
1597:

Line 1853: -- FROM igc_cc_det_pf_v

1849:
1850: CURSOR C_PF_LINES(p_cc_acct_line_id NUMBER)
1851: IS
1852: -- SELECT *
1853: -- FROM igc_cc_det_pf_v
1854: -- WHERE cc_acct_line_id = p_cc_acct_line_id;
1855:
1856: SELECT ccdpf.ROWID,
1857: ccdpf.cc_det_pf_line_id,

Line 1896: FROM igc_cc_det_pf ccdpf

1892: ccdpf.last_updated_by,
1893: ccdpf.last_update_login,
1894: ccdpf.creation_date,
1895: ccdpf.created_by
1896: FROM igc_cc_det_pf ccdpf
1897: WHERE cc_acct_line_id = p_cc_acct_line_id
1898: AND ccdpf.cc_det_pf_entered_amt <> IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(ccdpf.cc_det_pf_line_id,ccdpf.cc_det_pf_line_num,
1899: ccdpf.cc_acct_line_id); -- Bug 3856265
1900:

Line 3342: FROM igc_cc_det_pf a,

3338:
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

Line 3368: -- Replaced the view igc_cc_det_pf_v with

3364: END;
3365:
3366:
3367: BEGIN
3368: -- Replaced the view igc_cc_det_pf_v with
3369: -- igc_cc_det_pf.
3370: -- Also replaced the following line.
3371: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3372:

Line 3369: -- igc_cc_det_pf.

3365:
3366:
3367: BEGIN
3368: -- Replaced the view igc_cc_det_pf_v with
3369: -- igc_cc_det_pf.
3370: -- Also replaced the following line.
3371: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3372:
3373: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +

Line 3383: FROM igc_cc_det_pf a,

3379: ) * (l_rate - c.conversion_rate)
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

Line 3429: FROM igc_cc_det_pf a,

3425:
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

Line 3457: -- Replaced view igc_cc_det_pf_v with

3453: END;
3454:
3455:
3456: BEGIN
3457: -- Replaced view igc_cc_det_pf_v with
3458: -- igc_cc_det_pf. Also replaced the following
3459: -- line.
3460: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3461: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +

Line 3458: -- igc_cc_det_pf. Also replaced the following

3454:
3455:
3456: BEGIN
3457: -- Replaced view igc_cc_det_pf_v with
3458: -- igc_cc_det_pf. Also replaced the following
3459: -- line.
3460: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3461: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +
3462: (

Line 3471: FROM igc_cc_det_pf a,

3467: ) * (l_rate - c.conversion_rate)
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

Line 3522: FROM igc_cc_det_pf a,

3518:
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

Line 3550: -- Replaced the view igc_cc_det_pf_v with

3546:
3547:
3548: BEGIN
3549:
3550: -- Replaced the view igc_cc_det_pf_v with
3551: -- igc_cc_det_pf and replaced the
3552: -- following line.
3553: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3554: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +

Line 3551: -- igc_cc_det_pf and replaced the

3547:
3548: BEGIN
3549:
3550: -- Replaced the view igc_cc_det_pf_v with
3551: -- igc_cc_det_pf and replaced the
3552: -- following line.
3553: -- ( NVL(a.cc_det_pf_func_amt,0) - a.cc_det_pf_func_billed_amt
3554: SELECT SUM( NVL(a.cc_det_pf_func_amt,0) +
3555: (

Line 3564: FROM igc_cc_det_pf a,

3560: ) * (l_rate - c.conversion_rate)
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