APPS.CN_IMPORT_PVT dependencies on CN_IMP_LINES

Line 29: -- This procedure will update cn_imp_lines record_num

25:
26: -- --------------------------------------------------------+
27: -- upd_impline_recnum
28: --
29: -- This procedure will update cn_imp_lines record_num
30: -- --------------------------------------------------------+
31: PROCEDURE upd_impline_recnum
32: (p_imp_header_id IN NUMBER) IS
33: PRAGMA AUTONOMOUS_TRANSACTION;

Line 36: SELECT imp_line_id FROM cn_imp_lines

32: (p_imp_header_id IN NUMBER) IS
33: PRAGMA AUTONOMOUS_TRANSACTION;
34:
35: CURSOR c_imp_lines_csr IS
36: SELECT imp_line_id FROM cn_imp_lines
37: WHERE imp_header_id = p_imp_header_id
38: ORDER BY imp_line_id;
39:
40: l_count NUMBER := 0;

Line 45: UPDATE cn_imp_lines

41:
42: BEGIN
43: FOR l_imp_lines_csr IN c_imp_lines_csr LOOP
44: l_count := l_count + 1;
45: UPDATE cn_imp_lines
46: SET record_num = l_count
47: WHERE imp_line_id = l_imp_lines_csr.imp_line_id
48: ;
49: END LOOP;

Line 479: FROM cn_imp_lines

475: err_num NUMBER;
476:
477: CURSOR c_loaded_rows IS
478: SELECT COUNT(*)
479: FROM cn_imp_lines
480: WHERE imp_header_id = p_imp_header_id;
481:
482: BEGIN
483: -- Standard Start of API savepoint

Line 790: -- Update record_num in cn_imp_lines

786: p_message_type => 'MILESTONE');
787:
788: -- Start Loading Data
789: IF l_imp_header.status_code = 'STAGE' THEN
790: -- Update record_num in cn_imp_lines
791: upd_impline_recnum (p_imp_header_id => p_imp_header_id);
792:
793: -- set status = SCHEDULE
794: update_imp_headers

Line 968: FROM cn_imp_lines

964: ;
965:
966: CURSOR c_loaded_rows IS
967: SELECT COUNT(*)
968: FROM cn_imp_lines
969: WHERE imp_header_id = p_imp_header_id;
970: l_loaded_rows NUMBER;
971:
972: l_data char_data_set_type;

Line 1173: -- This procedure will update cn_imp_lines status and error code

1169: -- ========================================================
1170: -- --------------------------------------------------------+
1171: -- update_imp_lines
1172: --
1173: -- This procedure will update cn_imp_lines status and error code
1174: -- --------------------------------------------------------+
1175: PROCEDURE update_imp_lines
1176: (p_imp_line_id IN NUMBER,
1177: p_status_code IN VARCHAR2,

Line 1183: UPDATE cn_imp_lines

1179: p_error_msg IN VARCHAR2 := NULL) IS
1180: PRAGMA AUTONOMOUS_TRANSACTION;
1181: BEGIN
1182:
1183: UPDATE cn_imp_lines
1184: SET status_code = p_status_code, error_code = p_error_code,
1185: error_msg = p_error_msg
1186: WHERE imp_line_id = p_imp_line_id
1187: ;