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:
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 (
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:
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;
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
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:
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';
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;
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;
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;
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;
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:
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
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:
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
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:
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,