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

Line 47: p_cc_acct_lines_rec IN OUT NOCOPY igc_cc_acct_lines%ROWTYPE,

43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_rowid IN OUT NOCOPY VARCHAR2,
46: p_action_flag IN VARCHAR2,
47: p_cc_acct_lines_rec IN OUT NOCOPY igc_cc_acct_lines%ROWTYPE,
48: p_update_flag IN OUT NOCOPY VARCHAR2
49: );
50:
51: PROCEDURE Det_Pf_Wrapper

Line 145: p_cc_acct_lines_rec IN OUT NOCOPY igc_cc_acct_lines%ROWTYPE,

141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: x_rowid IN OUT NOCOPY VARCHAR2,
144: p_action_flag IN VARCHAR2,
145: p_cc_acct_lines_rec IN OUT NOCOPY igc_cc_acct_lines%ROWTYPE,
146: p_update_flag IN OUT NOCOPY VARCHAR2
147: ) IS
148:
149: l_api_name CONSTANT VARCHAR2(30) := 'Account_Line_Wrapper';

Line 163: IGC_CC_ACCT_LINES_PKG.Update_Row (

159: -- Make sure that the action requested to be performed is to UPDATE a row.
160: -- ---------------------------------------------------------------------------------
161: IF (p_action_flag = 'U') THEN
162:
163: IGC_CC_ACCT_LINES_PKG.Update_Row (
164: p_api_version,
165: p_init_msg_list,
166: p_commit,
167: p_validation_level,

Line 511: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

507: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Rel_Budgetary_Ctrl';
508: l_api_version CONSTANT NUMBER := 1.0;
509:
510: l_cc_headers_rec igc_cc_headers%ROWTYPE;
511: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
513:
514: l_transaction_date DATE;
515:

Line 516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
513:
514: l_transaction_date DATE;
515:
516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
518:
519: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
520: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

Line 517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

513:
514: l_transaction_date DATE;
515:
516: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
517: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
518:
519: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
520: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
521:

Line 536: l_update_login igc_cc_acct_lines.last_update_login%TYPE;

532: l_msg_count NUMBER;
533: l_msg_data VARCHAR2(2000);
534: l_row_id VARCHAR2(18);
535: l_update_flag VARCHAR2(1);
536: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
537: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
538:
539: -- -------------------------------------------------------------------------
540: -- Record definitions to be used for CURSORS getting single record for

Line 537: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;

533: l_msg_data VARCHAR2(2000);
534: l_row_id VARCHAR2(18);
535: l_update_flag VARCHAR2(1);
536: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
537: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
538:
539: -- -------------------------------------------------------------------------
540: -- Record definitions to be used for CURSORS getting single record for
541: -- the table wrappers. These record definitions are NOT the same as the

Line 545: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;

541: -- the table wrappers. These record definitions are NOT the same as the
542: -- ones above when getting data from the views.
543: -- -------------------------------------------------------------------------
544: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
545: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
546:
547: /* Contract Commitment account lines */
548:
549: -- Bug 2885953 - amended cursor below for performance enhancements

Line 552: -- FROM igc_cc_acct_lines_v ccac

548:
549: -- Bug 2885953 - amended cursor below for performance enhancements
550: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
551: -- SELECT *
552: -- FROM igc_cc_acct_lines_v ccac
553: -- WHERE ccac.cc_header_id = t_cc_header_id;
554: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
555: SELECT ccac.ROWID,
556: ccac.cc_header_id,

Line 618: FROM igc_cc_acct_lines ccac

614: ccac.cc_func_withheld_amt,
615: ccac.cc_ent_withheld_amt,
616: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccac.cc_header_id, NVL(ccac.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
617: ccac.Tax_Classif_Code
618: FROM igc_cc_acct_lines ccac
619: WHERE ccac.cc_header_id = t_cc_header_id;
620:
621: /* Contract Detail Payment Forecast lines */
622:

Line 678: FROM igc_cc_acct_lines

674: -- functions for updating, inserting, deleting records from tables.
675: -- -------------------------------------------------------------------------
676: CURSOR c_cc_acct_line IS
677: SELECT *
678: FROM igc_cc_acct_lines
679: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
680:
681: CURSOR c_det_pf_line IS
682: SELECT *

Line 806: -- igc_cc_acct_lines_v with

802:
803: l_billed_amt := 0;
804: l_func_billed_amt := 0;
805: -- Performance Tuning, Replaced view
806: -- igc_cc_acct_lines_v with
807: -- igc_cc_acct_lines and replaced the line
808: -- below.
809: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt
810: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 807: -- igc_cc_acct_lines and replaced the line

803: l_billed_amt := 0;
804: l_func_billed_amt := 0;
805: -- Performance Tuning, Replaced view
806: -- igc_cc_acct_lines_v with
807: -- igc_cc_acct_lines and replaced the line
808: -- below.
809: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt
810: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
811: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_func_billed_amt

Line 813: FROM igc_cc_acct_lines ccal

809: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt
810: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
811: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_func_billed_amt
812: INTO l_billed_amt,l_func_billed_amt
813: FROM igc_cc_acct_lines ccal
814: WHERE ccal.cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
815:
816: IF (p_currency_code <> l_cc_headers_rec.currency_code) THEN
817:

Line 881: FROM igc_cc_acct_lines

877: END IF;
878:
879: SELECT rowid
880: INTO l_row_id
881: FROM igc_cc_acct_lines
882: WHERE cc_acct_line_id = l_acct_line_rec.cc_acct_line_id;
883:
884: Account_Line_Wrapper (p_api_version => l_api_version,
885: p_init_msg_list => FND_API.G_FALSE,

Line 1430: p_cc_acct_lines_rec IN igc_cc_acct_lines_v%ROWTYPE,

1426:
1427: PROCEDURE Process_Interface_Row(
1428: p_currency_code IN VARCHAR2,
1429: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
1430: p_cc_acct_lines_rec IN igc_cc_acct_lines_v%ROWTYPE,
1431: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,
1432: p_mode IN VARCHAR2,
1433: p_type IN VARCHAR2,
1434: p_accounting_date IN DATE,

Line 1538: -- igc_cc_acct_lines_v with

1534: l_func_billed_amt := 0;
1535: l_func_amt := 0;
1536:
1537: -- Performance Tuning, Replaced view
1538: -- igc_cc_acct_lines_v with
1539: -- igc_cc_acct_lines and replaced the line
1540: -- below.
1541: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt, cc_acct_func_amt
1542: -- Modifications for bug# 12834070 begin

Line 1539: -- igc_cc_acct_lines and replaced the line

1535: l_func_amt := 0;
1536:
1537: -- Performance Tuning, Replaced view
1538: -- igc_cc_acct_lines_v with
1539: -- igc_cc_acct_lines and replaced the line
1540: -- below.
1541: -- SELECT cc_acct_billed_amt , cc_acct_func_billed_amt, cc_acct_func_amt
1542: -- Modifications for bug# 12834070 begin
1543: /* SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 1547: FROM igc_cc_acct_lines ccal

1543: /* SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
1544: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_func_billed_amt,
1545: cc_acct_func_amt
1546: INTO l_billed_amt, l_func_billed_amt, l_func_amt
1547: FROM igc_cc_acct_lines ccal
1548: WHERE ccal.cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id;
1549:
1550: l_unbilled_amt := l_func_amt - l_func_billed_amt;
1551: */

Line 1559: FROM igc_cc_acct_lines ccal

1555: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
1556: CC_ACCT_ENCMBRNC_AMT,
1557: cc_acct_func_amt
1558: INTO l_billed_amt, l_func_billed_amt, l_func_amt
1559: FROM igc_cc_acct_lines ccal
1560: WHERE ccal.cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id;
1561: l_unbilled_amt := l_func_billed_amt- l_func_amt ;
1562:
1563: IF (g_debug_mode = 'Y') THEN

Line 1604: -- igc_cc_acct_lines_v with

1600: l_func_billed_amt := 0;
1601: l_func_amt := 0;
1602:
1603: -- Performance Tuning, Replaced view
1604: -- igc_cc_acct_lines_v with
1605: -- igc_cc_acct_lines and replaced the line
1606: -- below.
1607: -- SELECT cc_det_pf_billed_amt, cc_det_pf_func_billed_amt , cc_det_pf_func_amt
1608: -- Modifications for bug# 12834070 begin

Line 1605: -- igc_cc_acct_lines and replaced the line

1601: l_func_amt := 0;
1602:
1603: -- Performance Tuning, Replaced view
1604: -- igc_cc_acct_lines_v with
1605: -- igc_cc_acct_lines and replaced the line
1606: -- below.
1607: -- SELECT cc_det_pf_billed_amt, cc_det_pf_func_billed_amt , cc_det_pf_func_amt
1608: -- Modifications for bug# 12834070 begin
1609: /* SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_line_num, ccdpf.cc_acct_line_id) cc_det_pf_billed_amt,

Line 2092: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;

2088: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2089: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2090:
2091: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2092: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;
2093: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2094: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2096:

Line 2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;

2093: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2094: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2096:
2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2099:
2100: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2101: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;

Line 2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;

2094: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;
2096:
2097: l_cc_acct_comp_func_amt igc_cc_acct_lines_v.cc_acct_comp_func_amt%TYPE;
2098: l_cc_acct_enc_amt igc_cc_acct_lines_v.cc_acct_encmbrnc_amt%TYPE;
2099:
2100: l_cc_det_pf_comp_func_amt igc_cc_det_pf_v.cc_det_pf_comp_func_amt%TYPE;
2101: l_cc_det_pf_enc_amt igc_cc_det_pf_v.cc_det_pf_encmbrnc_amt%TYPE;
2102:

Line 2122: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

2118: l_sob_id NUMBER;
2119: l_cc_state VARCHAR2(2);
2120:
2121: l_cc_headers_rec igc_cc_headers%ROWTYPE;
2122: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
2123: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
2124: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2125:
2126: l_debug VARCHAR2(1);

Line 2148: l_update_login igc_cc_acct_lines.last_update_login%TYPE;

2144: l_msg_count NUMBER;
2145: l_msg_data VARCHAR2(2000);
2146: l_row_id VARCHAR2(18);
2147: l_update_flag VARCHAR2(1);
2148: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
2149: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
2150:
2151: -- -------------------------------------------------------------------------
2152: -- Record definitions to be used for CURSORS getting single record for

Line 2149: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;

2145: l_msg_data VARCHAR2(2000);
2146: l_row_id VARCHAR2(18);
2147: l_update_flag VARCHAR2(1);
2148: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
2149: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
2150:
2151: -- -------------------------------------------------------------------------
2152: -- Record definitions to be used for CURSORS getting single record for
2153: -- the table wrappers. These record definitions are NOT the same as the

Line 2157: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;

2153: -- the table wrappers. These record definitions are NOT the same as the
2154: -- ones above when getting data from the views.
2155: -- -------------------------------------------------------------------------
2156: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
2157: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
2158:
2159: e_cc_invalid_set_up EXCEPTION;
2160: e_no_budgetary_control EXCEPTION;
2161: e_cc_not_found EXCEPTION;

Line 2243: -- FROM igc_cc_acct_lines_v ccac

2239:
2240: -- Bug 2885953 - cursor below amended for performance enhancements
2241: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
2242: -- SELECT *
2243: -- FROM igc_cc_acct_lines_v ccac
2244: -- WHERE ccac.cc_header_id = t_cc_header_id;
2245: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
2246: SELECT ccac.ROWID,
2247: ccac.cc_header_id,

Line 2309: FROM igc_cc_acct_lines ccac

2305: ccac.cc_func_withheld_amt,
2306: ccac.cc_ent_withheld_amt,
2307: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccac.cc_header_id, NVL(ccac.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
2308: ccac.Tax_Classif_Code
2309: FROM igc_cc_acct_lines ccac
2310: WHERE ccac.cc_header_id = t_cc_header_id;
2311:
2312: -- -------------------------------------------------------------------------
2313: -- Cursors used for obtaining a single line to be passed into the wrapper

Line 2318: FROM igc_cc_acct_lines

2314: -- functions for updating, inserting, deleting records from tables.
2315: -- -------------------------------------------------------------------------
2316: CURSOR c_cc_acct_line IS
2317: SELECT *
2318: FROM igc_cc_acct_lines
2319: WHERE cc_acct_line_id = l_cc_acct_line_id;
2320:
2321: CURSOR c_det_pf_line IS
2322: SELECT *

Line 2328: FROM igc_cc_acct_lines

2324: WHERE cc_det_pf_line_id = l_cc_det_pf_line_id;
2325:
2326: CURSOR c_cc_acct_line_rec_input IS
2327: SELECT *
2328: FROM igc_cc_acct_lines
2329: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
2330:
2331: CURSOR c_det_pf_line_rec_input IS
2332: SELECT *

Line 2343: FROM igc_cc_acct_lines

2339: SELECT SUM(( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(cp_cc_header_id, NVL(cc_det_pf_entered_amt,0) ) -
2340: NVL(cc_det_pf_encmbrnc_amt,0) )) cc_det_pf_unencmbrd_amt
2341: FROM igc_cc_det_pf
2342: WHERE cc_acct_line_id IN (SELECT cc_acct_line_id
2343: FROM igc_cc_acct_lines
2344: WHERE cc_header_id = cp_cc_header_id);
2345: -- bug 2689651, end 2
2346:
2347: l_full_path VARCHAR2(255);

Line 2877: -- igc_cc_acct_lines_v with

2873: (l_budget_dest_flag = 'C'))
2874: THEN */--Bug 5464993. Update amounts even when cbc is disabled
2875:
2876: -- Performance Tuning, Replaced view
2877: -- igc_cc_acct_lines_v with
2878: -- igc_cc_acct_lines and replaced the line
2879: -- below.
2880: -- SELECT cc_acct_comp_func_amt
2881: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_acct_entered_amt,0)) cc_acct_comp_func_amt

Line 2878: -- igc_cc_acct_lines and replaced the line

2874: THEN */--Bug 5464993. Update amounts even when cbc is disabled
2875:
2876: -- Performance Tuning, Replaced view
2877: -- igc_cc_acct_lines_v with
2878: -- igc_cc_acct_lines and replaced the line
2879: -- below.
2880: -- SELECT cc_acct_comp_func_amt
2881: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_acct_entered_amt,0)) cc_acct_comp_func_amt
2882: INTO l_cc_acct_comp_func_amt

Line 2883: FROM igc_cc_acct_lines ccal

2879: -- below.
2880: -- SELECT cc_acct_comp_func_amt
2881: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_acct_entered_amt,0)) cc_acct_comp_func_amt
2882: INTO l_cc_acct_comp_func_amt
2883: FROM igc_cc_acct_lines ccal
2884: WHERE ccal.cc_acct_line_id = l_cc_acct_line_id;
2885:
2886: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2887: IF (g_debug_mode = 'Y') THEN

Line 2955: -- igc_cc_acct_lines_v with

2951: l_billed_amt := 0;
2952: l_func_billed_amt := 0;
2953:
2954: -- Performance Tuning, Replaced view
2955: -- igc_cc_acct_lines_v with
2956: -- igc_cc_acct_lines and replaced the line
2957: -- below.
2958: -- SELECT cc_acct_billed_amt ,cc_acct_func_billed_amt
2959: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,

Line 2956: -- igc_cc_acct_lines and replaced the line

2952: l_func_billed_amt := 0;
2953:
2954: -- Performance Tuning, Replaced view
2955: -- igc_cc_acct_lines_v with
2956: -- igc_cc_acct_lines and replaced the line
2957: -- below.
2958: -- SELECT cc_acct_billed_amt ,cc_acct_func_billed_amt
2959: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
2960: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_func_billed_amt

Line 2962: FROM igc_cc_acct_lines ccal

2958: -- SELECT cc_acct_billed_amt ,cc_acct_func_billed_amt
2959: SELECT IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_billed_amt,
2960: IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) cc_acct_func_billed_amt
2961: INTO l_billed_amt, l_func_billed_amt
2962: FROM igc_cc_acct_lines ccal
2963: WHERE ccal.cc_acct_line_id = l_cc_acct_line_id;
2964:
2965: IF (l_currency_code <> l_cc_headers_rec.currency_code)
2966: THEN

Line 3023: FROM igc_cc_acct_lines

3019: END IF;
3020:
3021: SELECT rowid
3022: INTO l_row_id
3023: FROM igc_cc_acct_lines
3024: WHERE cc_acct_line_id = l_acct_line_rec.cc_acct_line_id;
3025:
3026: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3027: IF (g_debug_mode = 'Y') THEN

Line 3467: FROM igc_cc_acct_lines

3463: l_acct_line_rec.last_updated_by := l_update_by;
3464:
3465: SELECT rowid
3466: INTO l_row_id
3467: FROM igc_cc_acct_lines
3468: WHERE cc_acct_line_id = l_acct_line_rec.cc_acct_line_id;
3469:
3470: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3471: IF (g_debug_mode = 'Y') THEN

Line 4248: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

4244: l_api_name CONSTANT VARCHAR2(30) := 'Set_Encumbrance_Status';
4245: l_api_version CONSTANT NUMBER := 1.0;
4246:
4247: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4248: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4249: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4250:
4251: l_error_message VARCHAR2(2000);
4252:

Line 4262: l_update_login igc_cc_acct_lines.last_update_login%TYPE;

4258: l_msg_count NUMBER;
4259: l_msg_data VARCHAR2(2000);
4260: l_row_id VARCHAR2(18);
4261: l_update_flag VARCHAR2(1);
4262: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
4263: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
4264:
4265: -- -------------------------------------------------------------------------
4266: -- Record definitions to be used for CURSORS getting single record for

Line 4263: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;

4259: l_msg_data VARCHAR2(2000);
4260: l_row_id VARCHAR2(18);
4261: l_update_flag VARCHAR2(1);
4262: l_update_login igc_cc_acct_lines.last_update_login%TYPE;
4263: l_update_by igc_cc_acct_lines.last_updated_by%TYPE;
4264:
4265: -- -------------------------------------------------------------------------
4266: -- Record definitions to be used for CURSORS getting single record for
4267: -- the table wrappers. These record definitions are NOT the same as the

Line 4272: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;

4268: -- ones above when getting data from the views.
4269: -- -------------------------------------------------------------------------
4270: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
4271: l_header_rec igc_cc_headers%ROWTYPE;
4272: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
4273:
4274: e_cc_not_found EXCEPTION;
4275: e_invalid_status_code EXCEPTION;
4276:

Line 4335: -- FROM igc_cc_acct_lines_v ccac

4331:
4332: -- Bug 2885953 - cursor below amended for performance enhancements
4333: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4334: -- SELECT *
4335: -- FROM igc_cc_acct_lines_v ccac
4336: -- WHERE ccac.cc_header_id = t_cc_header_id;
4337: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4338: SELECT ccac.ROWID,
4339: ccac.cc_header_id,

Line 4401: FROM igc_cc_acct_lines ccac

4397: ccac.cc_func_withheld_amt,
4398: ccac.cc_ent_withheld_amt,
4399: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccac.cc_header_id, NVL(ccac.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
4400: ccac.Tax_Classif_Code
4401: FROM igc_cc_acct_lines ccac
4402: WHERE ccac.cc_header_id = t_cc_header_id;
4403:
4404: -- -------------------------------------------------------------------------
4405: -- Cursors used for obtaining a single line to be passed into the wrapper

Line 4410: FROM igc_cc_acct_lines

4406: -- functions for updating, inserting, deleting records from tables.
4407: -- -------------------------------------------------------------------------
4408: CURSOR c_cc_acct_line IS
4409: SELECT *
4410: FROM igc_cc_acct_lines
4411: WHERE cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;
4412:
4413: CURSOR c_det_pf_line IS
4414: SELECT *

Line 4506: FROM igc_cc_acct_lines

4502: l_acct_line_rec.last_updated_by := l_update_by;
4503:
4504: SELECT rowid
4505: INTO l_row_id
4506: FROM igc_cc_acct_lines
4507: WHERE cc_acct_line_id = l_acct_line_rec.cc_acct_line_id;
4508:
4509: Account_Line_Wrapper (p_api_version => l_api_version,
4510: p_init_msg_list => FND_API.G_FALSE,

Line 4737: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;

4733: IS
4734: l_api_name CONSTANT VARCHAR2(30) := 'Validate_CC';
4735: l_api_version CONSTANT NUMBER := 1.0;
4736: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4737: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4738: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4739: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4740: l_cc_acct_cnt NUMBER := 0;
4741: l_total_pf_entered_amt NUMBER := 0;

Line 4776: -- FROM igc_cc_acct_lines_v ccac

4772:
4773: -- Bug 2885953 - cursor below amended for performance enhancements
4774: -- CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4775: -- SELECT *
4776: -- FROM igc_cc_acct_lines_v ccac
4777: -- WHERE ccac.cc_header_id = t_cc_header_id;
4778: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
4779: SELECT ccac.ROWID,
4780: ccac.cc_header_id,

Line 4842: FROM igc_cc_acct_lines ccac

4838: ccac.cc_func_withheld_amt,
4839: ccac.cc_ent_withheld_amt,
4840: IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccac.cc_header_id, NVL(ccac.cc_func_withheld_amt,0)) cc_comp_func_whld_amt,
4841: ccac.Tax_Classif_Code
4842: FROM igc_cc_acct_lines ccac
4843: WHERE ccac.cc_header_id = t_cc_header_id;
4844:
4845: CURSOR c_det_pf_lines(t_cc_acct_line_id NUMBER) IS
4846: -- Performance Tuning, Replaced view