35: -- This validates the entire record.
36: --
37: PROCEDURE CC_OPEN_API_VALIDATE (
38: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
39: p_current_org_id IN igc_cc_headers.org_id%TYPE,
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
36: --
37: PROCEDURE CC_OPEN_API_VALIDATE (
38: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
39: p_current_org_id IN igc_cc_headers.org_id%TYPE,
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
37: PROCEDURE CC_OPEN_API_VALIDATE (
38: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
39: p_current_org_id IN igc_cc_headers.org_id%TYPE,
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
39: p_current_org_id IN igc_cc_headers.org_id%TYPE,
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
46: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
47: );
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
46: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
47: );
48:
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
46: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
47: );
48:
49: --
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
46: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
47: );
48:
49: --
50: -- This procedure is called with cc_open_api_main procedure
89: l_error_message VARCHAR2(240);
90: l_cc_header_rec CC_HEADER_REC_TYPE;
91: l_status VARCHAR2(240);
92: x_valid_cc VARCHAR2(2000);
93: x_currency_code igc_cc_headers.currency_code%TYPE;
94: x_conversion_type igc_cc_headers.conversion_type%TYPE;
95: x_conversion_date igc_cc_headers.conversion_date%TYPE;
96: x_conversion_rate igc_cc_headers.conversion_rate%TYPE;
97: l_full_path VARCHAR(500);
90: l_cc_header_rec CC_HEADER_REC_TYPE;
91: l_status VARCHAR2(240);
92: x_valid_cc VARCHAR2(2000);
93: x_currency_code igc_cc_headers.currency_code%TYPE;
94: x_conversion_type igc_cc_headers.conversion_type%TYPE;
95: x_conversion_date igc_cc_headers.conversion_date%TYPE;
96: x_conversion_rate igc_cc_headers.conversion_rate%TYPE;
97: l_full_path VARCHAR(500);
98:
91: l_status VARCHAR2(240);
92: x_valid_cc VARCHAR2(2000);
93: x_currency_code igc_cc_headers.currency_code%TYPE;
94: x_conversion_type igc_cc_headers.conversion_type%TYPE;
95: x_conversion_date igc_cc_headers.conversion_date%TYPE;
96: x_conversion_rate igc_cc_headers.conversion_rate%TYPE;
97: l_full_path VARCHAR(500);
98:
99:
92: x_valid_cc VARCHAR2(2000);
93: x_currency_code igc_cc_headers.currency_code%TYPE;
94: x_conversion_type igc_cc_headers.conversion_type%TYPE;
95: x_conversion_date igc_cc_headers.conversion_date%TYPE;
96: x_conversion_rate igc_cc_headers.conversion_rate%TYPE;
97: l_full_path VARCHAR(500);
98:
99:
100: l_init_msg_list VARCHAR2(2000);
268: RAISE FND_API.G_EXC_ERROR;
269:
270: ELSE
271:
272: IGC_CC_HEADERS_PKG.Insert_Row (1.0,
273: FND_API.G_FALSE,
274: FND_API.G_FALSE,
275: FND_API.G_VALID_LEVEL_FULL,
276: l_return_status,
403: -- Validate the CC Header record and return the result
404:
405: PROCEDURE CC_OPEN_API_VALIDATE (
406: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
407: p_current_org_id IN igc_cc_headers.org_id%TYPE,
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
404:
405: PROCEDURE CC_OPEN_API_VALIDATE (
406: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
407: p_current_org_id IN igc_cc_headers.org_id%TYPE,
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
405: PROCEDURE CC_OPEN_API_VALIDATE (
406: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
407: p_current_org_id IN igc_cc_headers.org_id%TYPE,
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
407: p_current_org_id IN igc_cc_headers.org_id%TYPE,
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
414: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
415: ) IS
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
414: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
415: ) IS
416:
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
414: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
415: ) IS
416:
417: l_api_name VARCHAR2(30);
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,
413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%TYPE,
414: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%TYPE
415: ) IS
416:
417: l_api_name VARCHAR2(30);
418: l_error_message VARCHAR2(240);
448: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
450: l_cc_num_created NUMBER;
451: l_org_name hr_organization_units.name%TYPE;
452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
453: l_cc_num igc_cc_headers.cc_num%TYPE;
454: l_name hr_all_organization_units.name%TYPE;
455: l_full_path VARCHAR(500);
456:
449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
450: l_cc_num_created NUMBER;
451: l_org_name hr_organization_units.name%TYPE;
452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
453: l_cc_num igc_cc_headers.cc_num%TYPE;
454: l_name hr_all_organization_units.name%TYPE;
455: l_full_path VARCHAR(500);
456:
457: CURSOR c_validate_sob_id IS
474: AND HAOU.organization_id || '' = OOD.organization_id;
475:
476: CURSOR c_val_cover_state_stat IS
477: SELECT cc_num
478: FROM igc_cc_headers
479: WHERE cc_header_id = p_cc_header_rec.parent_header_id
480: AND cc_state IN ('PR','CM')
481: AND cc_apprvl_status = 'AP';
482:
824: -- -------------------------------------------------------------------
825: BEGIN
826: l_count := 0;
827: SELECT COUNT(*) INTO l_count
828: FROM igc_cc_headers
829: WHERE /*org_id = p_cc_header_rec.org_id
830: AND --Commented during MOAC uptake */
831: cc_num = p_cc_header_rec.cc_num;
832:
867: -- -------------------------------------------------------------------
868: BEGIN
869: l_count := 0;
870: SELECT COUNT(*) INTO l_count
871: FROM igc_cc_headers
872: WHERE /*org_id = p_cc_header_rec.org_id
873: AND --Commented during MOAC uptake */
874: cc_ref_num = p_cc_header_rec.cc_ref_num;
875:
956: INTO l_cov_curr_code,
957: l_cov_conversion_type,
958: l_cov_conversion_rate,
959: l_cov_conversion_date
960: FROM igc_cc_headers cchd
961: WHERE cchd.cc_header_id = p_cc_header_rec.parent_header_id
962: AND cchd.cc_type = 'C';
963:
964: EXCEPTION
1996: l_api_name := 'CC_Open_API_Derive';
1997:
1998: x_header_id := NULL;
1999: l_full_path := g_path||'cc_open_api_derive';
2000: SELECT igc_cc_headers_s.nextval
2001: INTO x_header_id
2002: FROM DUAL;
2003:
2004: -- --------------------------------------------------------------------
2030: p_api_version IN NUMBER,
2031: p_init_msg_list IN VARCHAR2,
2032: p_commit IN VARCHAR2,
2033: p_validation_level IN NUMBER,
2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2031: p_init_msg_list IN VARCHAR2,
2032: p_commit IN VARCHAR2,
2033: p_validation_level IN NUMBER,
2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2039: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
2032: p_commit IN VARCHAR2,
2033: p_validation_level IN NUMBER,
2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2039: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
2040: x_return_status OUT NOCOPY VARCHAR2,
2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2039: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
2040: x_return_status OUT NOCOPY VARCHAR2,
2041: x_msg_count OUT NOCOPY NUMBER,
2042: x_msg_data OUT NOCOPY VARCHAR2
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2039: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
2040: x_return_status OUT NOCOPY VARCHAR2,
2041: x_msg_count OUT NOCOPY NUMBER,
2042: x_msg_data OUT NOCOPY VARCHAR2
2043: ) IS
2044:
2045: l_api_name VARCHAR2(30);
2046: l_api_version NUMBER;
2047: l_debug VARCHAR2 (1);
2048: l_cc_header_rec igc_cc_headers%ROWTYPE;
2049: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2050: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
2051: l_cc_num igc_cc_headers.cc_num%TYPE;
2052: l_valid_cc VARCHAR2(2000);
2045: l_api_name VARCHAR2(30);
2046: l_api_version NUMBER;
2047: l_debug VARCHAR2 (1);
2048: l_cc_header_rec igc_cc_headers%ROWTYPE;
2049: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2050: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
2051: l_cc_num igc_cc_headers.cc_num%TYPE;
2052: l_valid_cc VARCHAR2(2000);
2053: l_return_status VARCHAR2(1);
2046: l_api_version NUMBER;
2047: l_debug VARCHAR2 (1);
2048: l_cc_header_rec igc_cc_headers%ROWTYPE;
2049: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2050: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
2051: l_cc_num igc_cc_headers.cc_num%TYPE;
2052: l_valid_cc VARCHAR2(2000);
2053: l_return_status VARCHAR2(1);
2054: l_result VARCHAR2(1);
2047: l_debug VARCHAR2 (1);
2048: l_cc_header_rec igc_cc_headers%ROWTYPE;
2049: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2050: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
2051: l_cc_num igc_cc_headers.cc_num%TYPE;
2052: l_valid_cc VARCHAR2(2000);
2053: l_return_status VARCHAR2(1);
2054: l_result VARCHAR2(1);
2055: l_msg_count NUMBER;
2054: l_result VARCHAR2(1);
2055: l_msg_count NUMBER;
2056: l_msg_data VARCHAR2(12000);
2057: l_encumbrance_flag VARCHAR2(1);
2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2055: l_msg_count NUMBER;
2056: l_msg_data VARCHAR2(12000);
2057: l_encumbrance_flag VARCHAR2(1);
2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2056: l_msg_data VARCHAR2(12000);
2057: l_encumbrance_flag VARCHAR2(1);
2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2057: l_encumbrance_flag VARCHAR2(1);
2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2066: l_itemkey igc_cc_headers.wf_item_key%TYPE;
2067: l_itemtype igc_cc_headers.wf_item_type%TYPE;
2068: l_row_id VARCHAR2(18);
2069: l_current_user_id NUMBER;
2070: l_current_login_id NUMBER;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2066: l_itemkey igc_cc_headers.wf_item_key%TYPE;
2067: l_itemtype igc_cc_headers.wf_item_type%TYPE;
2068: l_row_id VARCHAR2(18);
2069: l_current_user_id NUMBER;
2070: l_current_login_id NUMBER;
2071: l_user_id NUMBER;
2087: AND HAOU.organization_id || '' = OOD.organization_id;
2088:
2089: CURSOR c_cc_header_exist IS
2090: SELECT cchd.cc_header_id
2091: FROM igc_cc_headers cchd
2092: WHERE cchd.cc_num = p_cc_num;
2093: /* AND cchd.set_of_books_id = p_set_of_books_id
2094: AND cchd.org_id = l_current_org_id; --Commented during MOAC up take*/
2095:
2094: AND cchd.org_id = l_current_org_id; --Commented during MOAC up take*/
2095:
2096: CURSOR c_val_ref_num IS
2097: SELECT cchd.cc_ref_num
2098: FROM igc_cc_headers cchd
2099: WHERE cchd.cc_header_id = l_cc_header_id
2100: AND cchd.cc_ref_num IS NOT NULL;
2101:
2102: CURSOR c_cc_header_state IS
2100: AND cchd.cc_ref_num IS NOT NULL;
2101:
2102: CURSOR c_cc_header_state IS
2103: SELECT *
2104: FROM igc_cc_headers cchd
2105: WHERE cchd.cc_header_id = l_cc_header_id
2106: AND cchd.cc_apprvl_status = 'AP'
2107: AND cchd.cc_state = 'CM';
2108:
2685:
2686: l_itemkey := TO_CHAR(l_cc_header_id) || '-' || l_seq;
2687: l_itemtype := 'CCAPPWF';
2688:
2689: UPDATE igc_cc_headers_all ICH
2690: SET ICH.cc_ctrl_status = l_new_ctrl_status,
2691: ICH.cc_apprvl_status = l_new_apprvl_status,
2692: ICH.wf_item_type = 'CCAPPWF',
2693: ICH.wf_item_key = l_itemkey
2883: g_debug_msg := 'CC Update APi Open, Close, On Hold Actions begins here ...';
2884: Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2885: END IF;
2886:
2887: UPDATE igc_cc_headers_all ICH
2888: SET ICH.cc_ctrl_status = l_new_ctrl_status
2889: WHERE ICH.cc_header_id = l_cc_header_id
2890: AND ICH.cc_num = l_cc_header_rec.cc_num
2891: AND ICH.set_of_books_id = l_cc_header_rec.set_of_books_id
3195: p_api_version IN NUMBER,
3196: p_init_msg_list IN VARCHAR2,
3197: p_commit IN VARCHAR2,
3198: p_validation_level IN NUMBER,
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3196: p_init_msg_list IN VARCHAR2,
3197: p_commit IN VARCHAR2,
3198: p_validation_level IN NUMBER,
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3204: x_return_status OUT NOCOPY VARCHAR2,
3197: p_commit IN VARCHAR2,
3198: p_validation_level IN NUMBER,
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3204: x_return_status OUT NOCOPY VARCHAR2,
3205: x_msg_count OUT NOCOPY NUMBER,
3198: p_validation_level IN NUMBER,
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3204: x_return_status OUT NOCOPY VARCHAR2,
3205: x_msg_count OUT NOCOPY NUMBER,
3206: x_msg_data OUT NOCOPY VARCHAR2
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3204: x_return_status OUT NOCOPY VARCHAR2,
3205: x_msg_count OUT NOCOPY NUMBER,
3206: x_msg_data OUT NOCOPY VARCHAR2
3207: ) IS
3208:
3209: CURSOR c_check_cc_num IS
3210: SELECT ICH.cc_header_id,
3211: ICH.cc_ref_num
3212: FROM igc_cc_headers ICH
3213: WHERE ICH.org_id = p_org_id
3214: AND ICH.set_of_books_id = p_set_of_books_id
3215: AND ICH.cc_num = p_cc_num;
3216:
3372: p_api_version IN NUMBER,
3373: p_init_msg_list IN VARCHAR2,
3374: p_commit IN VARCHAR2,
3375: p_validation_level IN NUMBER ,
3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
3377: p_org_id IN igc_cc_headers.org_id%TYPE,
3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3380: x_return_status OUT NOCOPY VARCHAR2,
3373: p_init_msg_list IN VARCHAR2,
3374: p_commit IN VARCHAR2,
3375: p_validation_level IN NUMBER ,
3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
3377: p_org_id IN igc_cc_headers.org_id%TYPE,
3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3380: x_return_status OUT NOCOPY VARCHAR2,
3381: x_msg_count OUT NOCOPY NUMBER,
3374: p_commit IN VARCHAR2,
3375: p_validation_level IN NUMBER ,
3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
3377: p_org_id IN igc_cc_headers.org_id%TYPE,
3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3380: x_return_status OUT NOCOPY VARCHAR2,
3381: x_msg_count OUT NOCOPY NUMBER,
3382: x_msg_data OUT NOCOPY VARCHAR2
3375: p_validation_level IN NUMBER ,
3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
3377: p_org_id IN igc_cc_headers.org_id%TYPE,
3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3380: x_return_status OUT NOCOPY VARCHAR2,
3381: x_msg_count OUT NOCOPY NUMBER,
3382: x_msg_data OUT NOCOPY VARCHAR2
3383: ) IS
3384:
3385: CURSOR c_check_cc_num IS
3386: SELECT ICH.cc_num,
3387: ICH.cc_header_id
3388: FROM igc_cc_headers ICH
3389: WHERE /*ICH.org_id = p_org_id
3390: AND ICH.set_of_books_id = p_set_of_books_id
3391: AND --Commented during r12 MOAC uptake */
3392: ICH.cc_num = p_cc_num;
3392: ICH.cc_num = p_cc_num;
3393:
3394: CURSOR c_check_dup_ref_num IS
3395: SELECT ICH.cc_ref_num
3396: FROM igc_cc_headers ICH
3397: WHERE /*ICH.org_id = p_org_id
3398: AND ICH.set_of_books_id = p_set_of_books_id
3399: AND --Commented during MOAC uptake */
3400: ICH.cc_ref_num = p_cc_ref_num;
3410:
3411: l_api_name VARCHAR2(30);
3412: l_api_version NUMBER ;
3413: l_debug VARCHAR2(1);
3414: l_cc_num igc_cc_headers.cc_num%TYPE;
3415: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
3416: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
3417: l_name hr_all_organization_units.name%TYPE;
3418:
3411: l_api_name VARCHAR2(30);
3412: l_api_version NUMBER ;
3413: l_debug VARCHAR2(1);
3414: l_cc_num igc_cc_headers.cc_num%TYPE;
3415: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
3416: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
3417: l_name hr_all_organization_units.name%TYPE;
3418:
3419: l_full_path VARCHAR(500);
3412: l_api_version NUMBER ;
3413: l_debug VARCHAR2(1);
3414: l_cc_num igc_cc_headers.cc_num%TYPE;
3415: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
3416: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
3417: l_name hr_all_organization_units.name%TYPE;
3418:
3419: l_full_path VARCHAR(500);
3420: l_init_msg_list varchar2(2000);
3510: INTO l_cc_ref_num;
3511:
3512: IF (c_check_dup_ref_num%NOTFOUND) THEN
3513:
3514: UPDATE igc_cc_headers_all ICH
3515: SET ICH.cc_ref_num = p_cc_ref_num
3516: WHERE ICH.cc_header_id = l_cc_header_id
3517: AND ICH.cc_num = p_cc_num
3518: AND ICH.set_of_books_id = p_set_of_books_id