eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on IGC_CC_HEADERS

Line 39: p_current_org_id IN igc_cc_headers.org_id%TYPE,

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,

Line 40: p_current_sob_id IN igc_cc_headers.set_of_books_id%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,

Line 41: p_func_currency_code IN igc_cc_headers.currency_code%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,

Line 43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%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: );

Line 44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%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: );
48:

Line 45: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%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:
49: --

Line 46: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%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: --
50: -- This procedure is called with cc_open_api_main procedure

Line 93: x_currency_code igc_cc_headers.currency_code%TYPE;

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

Line 94: x_conversion_type igc_cc_headers.conversion_type%TYPE;

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:

Line 95: x_conversion_date igc_cc_headers.conversion_date%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:
99:

Line 96: x_conversion_rate igc_cc_headers.conversion_rate%TYPE;

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

Line 272: IGC_CC_HEADERS_PKG.Insert_Row (1.0,

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,

Line 407: p_current_org_id IN igc_cc_headers.org_id%TYPE,

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,

Line 408: p_current_sob_id IN igc_cc_headers.set_of_books_id%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,

Line 409: p_func_currency_code IN igc_cc_headers.currency_code%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,

Line 411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%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

Line 412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%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
416:

Line 413: x_conversion_date OUT NOCOPY igc_cc_headers.conversion_date%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:
417: l_api_name VARCHAR2(30);

Line 414: x_conversion_rate OUT NOCOPY igc_cc_headers.conversion_rate%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);
418: l_error_message VARCHAR2(240);

Line 452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

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:

Line 453: l_cc_num igc_cc_headers.cc_num%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:
457: CURSOR c_validate_sob_id IS

Line 478: FROM igc_cc_headers

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:

Line 828: FROM igc_cc_headers

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:

Line 871: FROM igc_cc_headers

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:

Line 960: FROM igc_cc_headers cchd

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

Line 2000: SELECT igc_cc_headers_s.nextval

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

Line 2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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,

Line 2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%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,

Line 2036: p_org_id IN igc_cc_headers.org_id%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,

Line 2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,

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

Line 2039: p_last_update_login IN igc_cc_headers.last_update_login%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
2043: ) IS

Line 2048: l_cc_header_rec igc_cc_headers%ROWTYPE;

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

Line 2049: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

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

Line 2050: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;

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

Line 2051: l_cc_num igc_cc_headers.cc_num%TYPE;

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;

Line 2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;

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;

Line 2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%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;

Line 2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%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;

Line 2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%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);

Line 2066: l_itemkey igc_cc_headers.wf_item_key%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);
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;

Line 2067: l_itemtype igc_cc_headers.wf_item_type%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;
2071: l_user_id NUMBER;

Line 2091: FROM igc_cc_headers cchd

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:

Line 2098: FROM igc_cc_headers cchd

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

Line 2104: FROM igc_cc_headers cchd

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:

Line 2689: UPDATE igc_cc_headers_all ICH

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

Line 2887: UPDATE igc_cc_headers_all ICH

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

Line 3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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,

Line 3200: p_org_id IN igc_cc_headers.org_id%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,

Line 3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

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,

Line 3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,

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

Line 3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,

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

Line 3212: FROM igc_cc_headers ICH

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:

Line 3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,

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,

Line 3377: p_org_id IN igc_cc_headers.org_id%TYPE,

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,

Line 3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

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

Line 3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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

Line 3388: FROM igc_cc_headers ICH

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;

Line 3396: FROM igc_cc_headers ICH

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;

Line 3414: l_cc_num igc_cc_headers.cc_num%TYPE;

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:

Line 3415: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;

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

Line 3416: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

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

Line 3514: UPDATE igc_cc_headers_all ICH

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