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

Line 43: x_release_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE

39: --
40: -- To fetch the release account line Id.
41: --
42: PROCEDURE release_cc_acct_line_id (
43: x_release_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE
44: );
45:
46: --
47: -- To fetch the release payment forecast line Id.

Line 121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;

117: IS
118: l_api_name CONSTANT VARCHAR2 (30) := 'create_releases';
119: l_api_version CONSTANT NUMBER := 1.0;
120: l_cc_headers_rec igc_cc_headers%ROWTYPE;
121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;

Line 126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE

122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;

Line 128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE

124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
125: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;

Line 134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE

130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;
138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

Line 138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;
138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
139: l_release_cc_det_pf_line_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;
140: l_return_status VARCHAR2 (1);
141: l_msg_count NUMBER;
142: l_msg_data VARCHAR2 (2000);

Line 167: FROM igc_cc_acct_lines ccal

163:
164: CURSOR c_cc_acct_csr (p_cc_header_id IN NUMBER)
165: IS
166: SELECT *
167: FROM igc_cc_acct_lines ccal
168: WHERE ccal.cc_header_id = p_cc_header_id;
169:
170: CURSOR c_cc_det_pf_csr (p_cc_acct_line_id IN NUMBER)
171: IS

Line 398: FROM igc_cc_acct_lines ccal

394:
395: BEGIN
396: SELECT NVL (ccal.cc_acct_func_amt, 0)
397: INTO l_cc_acct_func_amt
398: FROM igc_cc_acct_lines ccal
399: WHERE ccal.cc_header_id = p_cover_cc_header_id;
400: EXCEPTION
401: WHEN OTHERS
402: THEN

Line 417: FROM igc_cc_acct_lines ccal, igc_cc_headers cchd

413:
414: BEGIN
415: SELECT SUM (NVL (ccal.cc_acct_func_amt, 0))
416: INTO l_cc_rel_func_total_amt
417: FROM igc_cc_acct_lines ccal, igc_cc_headers cchd
418: WHERE ccal.parent_header_id = p_cover_cc_header_id
419: AND ccal.cc_header_id = cchd.cc_header_id;
420: EXCEPTION
421: WHEN OTHERS

Line 634: igc_cc_acct_lines_pkg.insert_row

630: THEN
631: RAISE fnd_api.g_exc_unexpected_error;
632: END IF; -- Account Line Identification.
633:
634: igc_cc_acct_lines_pkg.insert_row
635: (p_api_version => 1.0,
636: p_init_msg_list => fnd_api.g_false,
637: p_commit => fnd_api.g_false,
638: p_validation_level => fnd_api.g_valid_level_full,

Line 1112: x_release_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE

1108: RETURN;
1109: END release_cc_header_id;
1110:
1111: PROCEDURE release_cc_acct_line_id (
1112: x_release_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE
1113: )
1114: IS
1115: l_api_name CONSTANT VARCHAR2 (30) := 'release_cc_acct_line_id';
1116: l_full_path VARCHAR2 (255);

Line 1122: SELECT igc_cc_acct_lines_s.NEXTVAL

1118: l_full_path := g_path || 'release_cc_acct_line_id';
1119: x_release_cc_acct_line_id := NULL;
1120:
1121: BEGIN
1122: SELECT igc_cc_acct_lines_s.NEXTVAL
1123: INTO x_release_cc_acct_line_id
1124: FROM DUAL;
1125: EXCEPTION
1126: WHEN NO_DATA_FOUND