DBA Data[Home] [Help]

APPS.IGC_CC_COPY_PKG dependencies on IGC_CC_ACCT_LINES

Line 33: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,

29: -- ------------------------------------------------------------------------------
30: -- Declare the procedures that are within this package.
31: -- ------------------------------------------------------------------------------
32: PROCEDURE Acct_Line_Copy (
33: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,
34: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
35: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,
36: x_return_status OUT NOCOPY VARCHAR2
37: );

Line 35: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,

31: -- ------------------------------------------------------------------------------
32: PROCEDURE Acct_Line_Copy (
33: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,
34: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
35: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,
36: x_return_status OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE Det_Pf_Line_Copy (

Line 41: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,

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: );
45:

Line 63: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,

59: PROCEDURE Acct_Line_Copy
60: ===============================================================================*/
61:
62: PROCEDURE Acct_Line_Copy (
63: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,
64: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
65: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,
66: x_return_status OUT NOCOPY VARCHAR2
67: ) IS

Line 65: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,

61:
62: PROCEDURE Acct_Line_Copy (
63: p_cc_acct_line IN igc_cc_acct_lines%ROWTYPE,
64: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,
65: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,
66: x_return_status OUT NOCOPY VARCHAR2
67: ) IS
68:
69: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

Line 69: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

65: x_cc_acct_line_id OUT NOCOPY igc_cc_acct_lines.cc_acct_line_id%TYPE,
66: x_return_status OUT NOCOPY VARCHAR2
67: ) IS
68:
69: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
70:
71: l_return_status VARCHAR2(1);
72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(2000);

Line 76: l_functional_amount igc_cc_acct_lines.cc_acct_func_amt%TYPE;

72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(2000);
74: l_Rowid VARCHAR2(18);
75: l_flag VARCHAR2(1);
76: l_functional_amount igc_cc_acct_lines.cc_acct_func_amt%TYPE;
77: -- bug 2043221 ssmales - added variable declaration on l_func_withheld_amt
78: l_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
79: l_seq_num NUMBER;
80:

Line 78: l_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;

74: l_Rowid VARCHAR2(18);
75: l_flag VARCHAR2(1);
76: l_functional_amount igc_cc_acct_lines.cc_acct_func_amt%TYPE;
77: -- bug 2043221 ssmales - added variable declaration on l_func_withheld_amt
78: l_func_withheld_amt igc_cc_acct_lines.cc_func_withheld_amt%TYPE;
79: l_seq_num NUMBER;
80:
81: l_full_path VARCHAR2(500) := g_path||'Acct_Line_Copy';--bug 3199488
82:

Line 118: IGC_CC_ACCT_LINES_PKG.Insert_Row

114: Put_Debug_Msg (l_full_path,' IGCCCPCB - New Copied Acct Line Functional Amount is : ' || l_func_withheld_amt);
115: -- bug 2043221 ssmales - end block
116: END IF;
117:
118: IGC_CC_ACCT_LINES_PKG.Insert_Row
119: (p_api_version => 1.0,
120: p_init_msg_list => FND_API.G_FALSE,
121: p_commit => FND_API.G_FALSE,
122: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 235: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,

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

Line 474: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;

470:
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);

Line 477: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;

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;
480: l_msg_data VARCHAR2(2000);
481: l_Rowid VARCHAR2(18);

Line 496: FROM igc_cc_acct_lines ccac

492: l_full_path VARCHAR2(500) := g_path||'Header_Copy';--bug 3199488
493:
494: CURSOR c_account_lines (t_cc_header_id NUMBER) IS
495: SELECT *
496: FROM igc_cc_acct_lines ccac
497: WHERE ccac.cc_header_id = t_cc_header_id;
498:
499: /* Contract Detail Payment Forecast lines */
500: