DBA Data[Home] [Help]

APPS.IGC_CC_COPY_PKG dependencies on IGC_CC_HEADERS

Line 34: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,

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

Line 42: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,

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:
46: PROCEDURE Access_Copy (

Line 64: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,

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

Line 236: p_conversion_rate IN igc_cc_headers.conversion_rate%TYPE,

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:
240: l_cc_pmt_fcst_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;

Line 465: p_old_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,

461: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
462: x_return_status OUT NOCOPY VARCHAR2,
463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_old_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
466: p_new_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
467: p_cc_num IN igc_cc_headers.cc_num%TYPE,
468: p_cc_type IN igc_cc_headers.cc_type%TYPE
469: ) IS

Line 466: p_new_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,

462: x_return_status OUT NOCOPY VARCHAR2,
463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_old_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
466: p_new_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
467: p_cc_num IN igc_cc_headers.cc_num%TYPE,
468: p_cc_type IN igc_cc_headers.cc_type%TYPE
469: ) IS
470:

Line 467: p_cc_num IN igc_cc_headers.cc_num%TYPE,

463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_old_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
466: p_new_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
467: p_cc_num IN igc_cc_headers.cc_num%TYPE,
468: p_cc_type IN igc_cc_headers.cc_type%TYPE
469: ) IS
470:
471: l_api_name CONSTANT VARCHAR2(30) := 'Header_Copy';

Line 468: p_cc_type IN igc_cc_headers.cc_type%TYPE

464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_old_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
466: p_new_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
467: p_cc_num IN igc_cc_headers.cc_num%TYPE,
468: p_cc_type IN igc_cc_headers.cc_type%TYPE
469: ) IS
470:
471: l_api_name CONSTANT VARCHAR2(30) := 'Header_Copy';
472: l_api_version CONSTANT NUMBER := 1.0;

Line 473: l_cc_headers_rec igc_cc_headers%ROWTYPE;

469: ) IS
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;

Line 485: l_cc_num_val igc_cc_headers.cc_num%TYPE;

481: l_Rowid VARCHAR2(18);
482: l_action_rowid VARCHAR2(18);
483: l_flag VARCHAR2(1);
484: l_debug VARCHAR2(1);
485: l_cc_num_val igc_cc_headers.cc_num%TYPE;
486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;

Line 486: l_cc_type_val igc_cc_headers.cc_type%TYPE;

482: l_action_rowid VARCHAR2(18);
483: l_flag VARCHAR2(1);
484: l_debug VARCHAR2(1);
485: l_cc_num_val igc_cc_headers.cc_num%TYPE;
486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;
490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;

Line 487: l_CC_State igc_cc_headers.cc_state%TYPE;

483: l_flag VARCHAR2(1);
484: l_debug VARCHAR2(1);
485: l_cc_num_val igc_cc_headers.cc_num%TYPE;
486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;
490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;
491:

Line 488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;

484: l_debug VARCHAR2(1);
485: l_cc_num_val igc_cc_headers.cc_num%TYPE;
486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;
490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;
491:
492: l_full_path VARCHAR2(500) := g_path||'Header_Copy';--bug 3199488

Line 489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;

485: l_cc_num_val igc_cc_headers.cc_num%TYPE;
486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;
490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;
491:
492: l_full_path VARCHAR2(500) := g_path||'Header_Copy';--bug 3199488
493:

Line 490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;

486: l_cc_type_val igc_cc_headers.cc_type%TYPE;
487: l_CC_State igc_cc_headers.cc_state%TYPE;
488: l_CC_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
489: l_CC_Encmbrnc_Status igc_cc_headers.cc_encmbrnc_status%TYPE;
490: l_CC_Apprvl_Status igc_cc_headers.cc_apprvl_status%TYPE;
491:
492: l_full_path VARCHAR2(500) := g_path||'Header_Copy';--bug 3199488
493:
494: CURSOR c_account_lines (t_cc_header_id NUMBER) IS

Line 515: FROM igc_cc_headers

511: WHERE cc_header_id = t_cc_header_id;
512:
513: CURSOR c_obtain_cc_header (t_cc_header_id NUMBER) IS
514: SELECT *
515: FROM igc_cc_headers
516: WHERE cc_header_id = t_cc_header_id;
517:
518: BEGIN
519:

Line 593: IGC_CC_HEADERS_PKG.Insert_Row

589: -- ------------------------------------------------------------------------------------
590: -- Call table handler to insert appropriate CC Header record into table as well as
591: -- the appropriate MRC records.
592: -- ------------------------------------------------------------------------------------
593: IGC_CC_HEADERS_PKG.Insert_Row
594: (p_api_version => 1.0,
595: p_init_msg_list => FND_API.G_FALSE,
596: p_commit => FND_API.G_FALSE,
597: p_validation_level => FND_API.G_VALID_LEVEL_FULL,