DBA Data[Home] [Help]

APPS.CN_IMP_HEADERS_PVT dependencies on CN_IMP_MAPS

Line 349: l_imp_map cn_imp_maps_pvt.imp_maps_rec_type :=

345: l_api_version CONSTANT NUMBER := 1.0;
346:
347: l_imp_header imp_headers_rec_type;
348: l_temp NUMBER;
349: l_imp_map cn_imp_maps_pvt.imp_maps_rec_type :=
350: cn_imp_maps_pvt.G_MISS_IMP_MAPS_REC;
351:
352: CURSOR c_pro_audit_csr(c_imp_header_id NUMBER) IS
353: SELECT process_audit_id

Line 350: cn_imp_maps_pvt.G_MISS_IMP_MAPS_REC;

346:
347: l_imp_header imp_headers_rec_type;
348: l_temp NUMBER;
349: l_imp_map cn_imp_maps_pvt.imp_maps_rec_type :=
350: cn_imp_maps_pvt.G_MISS_IMP_MAPS_REC;
351:
352: CURSOR c_pro_audit_csr(c_imp_header_id NUMBER) IS
353: SELECT process_audit_id
354: FROM cn_process_audits

Line 412: FROM cn_imp_maps

408: -- if p_map_obj_num = null, called for DELETE ALL, skip checking
409: -- for object_version_number
410: SELECT Decode(p_map_obj_num,NULL,object_version_number,p_map_obj_num)
411: INTO l_imp_map.object_version_number
412: FROM cn_imp_maps
413: WHERE imp_map_id = l_imp_header.imp_map_id;
414: -- check if mapping used by other imp_headers
415: BEGIN
416: l_temp := 0;

Line 429: cn_imp_maps_pvt.Delete_Imp_Map

425: END;
426:
427: -- delete imp_map if not used by other imp_headers
428: IF l_temp = 0 THEN
429: cn_imp_maps_pvt.Delete_Imp_Map
430: ( p_api_version => 1.0,
431: x_return_status => x_return_status,
432: x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data,