DBA Data[Home] [Help]

APPS.IGC_CC_COPY_PKG dependencies on IGC_CC_ACCESS

Line 47: p_access_lines IN igc_cc_access%ROWTYPE,

43: x_return_status OUT NOCOPY VARCHAR2
44: );
45:
46: PROCEDURE Access_Copy (
47: p_access_lines IN igc_cc_access%ROWTYPE,
48: x_return_status OUT NOCOPY VARCHAR2
49: );
50:
51: PROCEDURE Put_Debug_Msg (

Line 370: p_access_lines IN igc_cc_access%ROWTYPE,

366: PROCEDURE Access_Copy
367: ===============================================================================*/
368:
369: PROCEDURE Access_Copy (
370: p_access_lines IN igc_cc_access%ROWTYPE,
371: x_return_status OUT NOCOPY VARCHAR2
372: ) IS
373:
374: l_cc_access_id igc_cc_access.cc_access_id%TYPE;

Line 374: l_cc_access_id igc_cc_access.cc_access_id%TYPE;

370: p_access_lines IN igc_cc_access%ROWTYPE,
371: x_return_status OUT NOCOPY VARCHAR2
372: ) IS
373:
374: l_cc_access_id igc_cc_access.cc_access_id%TYPE;
375: l_return_status VARCHAR2(1);
376: l_msg_count NUMBER;
377: l_msg_data VARCHAR2(2000);
378: l_Rowid VARCHAR2(18);

Line 390: IGC_CC_ACCESS_PKG.Insert_Row

386: Put_Debug_Msg (l_full_path,' IGCCCPCB - Starting the Access Copy routine..........');
387: END IF;
388:
389:
390: IGC_CC_ACCESS_PKG.Insert_Row
391: (p_api_version => 1.0,
392: p_init_msg_list => FND_API.G_FALSE,
393: p_commit => FND_API.G_FALSE,
394: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 476: l_cc_access_lines_rec igc_cc_access%ROWTYPE;

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

Line 510: FROM igc_cc_access

506: /* Contract Access Lines */
507:
508: CURSOR c_access_lines (t_cc_header_id NUMBER) IS
509: SELECT *
510: FROM igc_cc_access
511: WHERE cc_header_id = t_cc_header_id;
512:
513: CURSOR c_obtain_cc_header (t_cc_header_id NUMBER) IS
514: SELECT *