[Home] [Help]
157: ,APPLICATION_ID
158: ,MAPPING_CODE
159: ,CONTENT_APP_ID
160: ,DECODE_FLAG
161: FROM BNE_MAPPING_LINES
162: WHERE application_id = p_application_id
163: AND MAPPING_CODE = c_mapping_code;
164:
165: CURSOR c_key_flex_row (c_interface_code IN VARCHAR2
223: WHERE application_id = p_application_id
224: AND INTERFACE_CODE = c_interface_code
225: AND SEQUENCE_NUM = c_interface_seq_num;
226:
227: l_temp_interface_seq_num BNE_MAPPING_LINES.INTERFACE_SEQ_NUM%TYPE;
228: l_mapping_cols_row c_mapping_cols_row%ROWTYPE;
229: l_intf_cols_row c_intf_cols_row%ROWTYPE;
230: l_key_flex_row c_key_flex_row%ROWTYPE;
231: l_rowid VARCHAR2(100);
275: --in mapping to download the data
276: or l_temp_interface_seq_num between 223 and 252 --$ To include Soft Coded Kff Segments
277:
278: THEN
279: BNE_MAPPING_LINES_PKG.INSERT_ROW
280: (x_rowid => l_rowid
281: ,x_application_id => p_application_id
282: ,X_MAPPING_CODE => p_new_mapping_code
283: ,X_INTERFACE_APP_ID => l_mapping_cols_row.INTERFACE_APP_ID
325: or l_kff_seg_flag
326: -- or ((l_temp_interface_seq_num between 52 and 81) and (p_entity_name='JOB'))
327: THEN
328: hr_utility.set_location('Inside if ', 40);
329: BNE_MAPPING_LINES_PKG.INSERT_ROW
330: (x_rowid => l_rowid
331: ,x_application_id => p_application_id
332: ,X_MAPPING_CODE => p_new_mapping_code
333: ,X_INTERFACE_APP_ID => l_mapping_cols_row.INTERFACE_APP_ID
1953: P_APPLICATION_ID => p_application_id);
1954:
1955: --$ COMMENT MANUAL DELETION STEPS
1956: /* DELETE
1957: FROM BNE_MAPPING_LINES
1958: WHERE APPLICATION_ID = P_APPLICATION_ID
1959: AND MAPPING_CODE = p_MAPPING_CODE
1960: AND INTERFACE_CODE =p_INTERFACE_CODE;
1961:
2620: begin
2621: select cont.sequence_num into temp_content_seq_num
2622: from bne_content_cols_b cont,
2623: bne_interface_cols_b intf,
2624: bne_mapping_lines map
2625: where
2626: map.interface_code = intf.interface_code
2627: and cont.content_code = map.content_code
2628: and intf.sequence_num = temp_interface_seq_num