DBA Data[Home] [Help]

APPS.IGC_CC_COPY_PKG dependencies on IGC_CC_DET_PF

Line 40: p_cc_pmt_fcst IN igc_cc_det_pf%ROWTYPE,

36: x_return_status OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE Det_Pf_Line_Copy (
40: p_cc_pmt_fcst IN igc_cc_det_pf%ROWTYPE,
41: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,
42: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
43: x_return_status OUT NOCOPY VARCHAR2
44: );

Line 234: p_cc_pmt_fcst IN igc_cc_det_pf%ROWTYPE,

230: PROCEDURE Det_Pf_Line_Copy
231: ===============================================================================*/
232:
233: PROCEDURE Det_Pf_Line_Copy (
234: p_cc_pmt_fcst IN igc_cc_det_pf%ROWTYPE,
235: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,
236: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
237: x_return_status OUT NOCOPY VARCHAR2
238: ) IS

Line 240: l_cc_pmt_fcst_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;

236: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
237: x_return_status OUT NOCOPY VARCHAR2
238: ) IS
239:
240: l_cc_pmt_fcst_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;
241: l_return_status VARCHAR2(1);
242: l_msg_count NUMBER;
243: l_msg_data VARCHAR2(2000);
244: l_Rowid VARCHAR2(18);

Line 246: l_functional_amount igc_cc_det_pf.cc_det_pf_func_amt%TYPE;

242: l_msg_count NUMBER;
243: l_msg_data VARCHAR2(2000);
244: l_Rowid VARCHAR2(18);
245: l_flag VARCHAR2(1);
246: l_functional_amount igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
247:
248: l_full_path VARCHAR2(500) := g_path||'Det_Pf_Line_Copy';--bug 3199488
249: BEGIN
250:

Line 274: IGC_CC_DET_PF_PKG.Insert_Row

270: Put_Debug_Msg (l_full_path,' IGCCCPCB - OLD Det PF Functional Amount is : ' || p_cc_pmt_fcst.cc_det_pf_func_amt);
271: Put_Debug_Msg (l_full_path,' IGCCCPCB - New Copied Det PF Functional Amount is : ' || l_functional_amount);
272: END IF;
273:
274: IGC_CC_DET_PF_PKG.Insert_Row
275: (p_api_version => 1.0,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 475: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;

471: l_api_name CONSTANT VARCHAR2(30) := 'Header_Copy';
472: l_api_version CONSTANT NUMBER := 1.0;
473: l_cc_headers_rec igc_cc_headers%ROWTYPE;
474: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
475: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
476: l_cc_access_lines_rec igc_cc_access%ROWTYPE;
477: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
478: l_return_status VARCHAR2(1);
479: l_msg_count NUMBER;

Line 503: FROM igc_cc_det_pf

499: /* Contract Detail Payment Forecast lines */
500:
501: CURSOR c_payment_forecast (t_cc_acct_line_id NUMBER) IS
502: SELECT *
503: FROM igc_cc_det_pf
504: WHERE cc_acct_line_id = t_cc_acct_line_id;
505:
506: /* Contract Access Lines */
507: