APPS.CN_IMP_MAPS_PVT dependencies on CN_IMP_MAPS

Line 1: PACKAGE BODY CN_IMP_MAPS_PVT AS

1: PACKAGE BODY CN_IMP_MAPS_PVT AS
2: -- $Header: cnvimmpb.pls 120.2 2005/08/07 23:03:33 vensrini noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_MAPS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvimmpb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_MAPS_PVT';

1: PACKAGE BODY CN_IMP_MAPS_PVT AS
2: -- $Header: cnvimmpb.pls 120.2 2005/08/07 23:03:33 vensrini noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_MAPS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvimmpb.pls';
6:
7: -- Start of comments
8: -- API name : Create_Mapping

Line 103: FROM cn_imp_maps

99: BEGIN
100: SELECT imp_map_id,object_version_number
101: INTO l_imp_map.imp_map_id,
102: l_imp_map.object_version_number
103: FROM cn_imp_maps
104: WHERE imp_map_id = p_imp_map.imp_map_id
105: ;
106: EXCEPTION
107: WHEN no_data_found THEN

Line 124: -- update cn_imp_maps object_version_number for new mapping

120: FND_MSG_PUB.Add;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR ;
123: END IF;
124: -- update cn_imp_maps object_version_number for new mapping
125: UPDATE cn_imp_maps
126: SET object_version_number = l_imp_map.object_version_number + 1
127: WHERE imp_map_id = p_imp_map.imp_map_id
128: ;

Line 125: UPDATE cn_imp_maps

121: END IF;
122: RAISE FND_API.G_EXC_ERROR ;
123: END IF;
124: -- update cn_imp_maps object_version_number for new mapping
125: UPDATE cn_imp_maps
126: SET object_version_number = l_imp_map.object_version_number + 1
127: WHERE imp_map_id = p_imp_map.imp_map_id
128: ;
129: x_imp_map_id := p_imp_map.imp_map_id;

Line 142: FROM cn_imp_maps m, cn_import_types t

138:
139: -- get target_table_id,target_table_name
140: SELECT t.table_id,t.view_name
141: INTO l_imp_map_field.target_table_id,l_imp_map_field.target_table_name
142: FROM cn_imp_maps m, cn_import_types t
143: WHERE m.imp_map_id = l_imp_map.imp_map_id
144: AND m.import_type_code = t.import_type_code
145: ;
146:

Line 448: FROM cn_imp_maps

444: CLOSE c_mapped_csr;
445: -- get imp_map obj version number : used by impHeaderEO.delete()
446: BEGIN
447: SELECT object_version_number INTO x_map_obj_num
448: FROM cn_imp_maps
449: WHERE imp_map_id = p_imp_map_id;
450: EXCEPTION
451: WHEN no_data_found THEN
452: x_map_obj_num := 0 ;

Line 566: FROM cn_imp_maps

562: -- Check Name uniqueness
563: BEGIN
564: SELECT 1
565: INTO l_temp
566: FROM cn_imp_maps
567: WHERE name = p_imp_map.name
568: ;
569: EXCEPTION
570: WHEN no_data_found THEN

Line 582: -- Call API to create cn_imp_maps

578: END IF;
579: RAISE FND_API.G_EXC_ERROR ;
580: END IF;
581:
582: -- Call API to create cn_imp_maps
583: l_imp_map := p_imp_map ;
584:
585: SELECT cn_imp_maps_s.nextval
586: INTO x_imp_map_id

Line 585: SELECT cn_imp_maps_s.nextval

581:
582: -- Call API to create cn_imp_maps
583: l_imp_map := p_imp_map ;
584:
585: SELECT cn_imp_maps_s.nextval
586: INTO x_imp_map_id
587: FROM sys.dual ;
588: l_imp_map.imp_map_id := x_imp_map_id ;
589:

Line 590: cn_imp_maps_pkg.insert_row

586: INTO x_imp_map_id
587: FROM sys.dual ;
588: l_imp_map.imp_map_id := x_imp_map_id ;
589:
590: cn_imp_maps_pkg.insert_row
591: (p_imp_maps_rec => l_imp_map);
592:
593: -- End of API body.
594:

Line 705: FROM cn_imp_maps

701: BEGIN
702: SELECT imp_map_id,object_version_number
703: INTO l_imp_map.imp_map_id,
704: l_imp_map.object_version_number
705: FROM cn_imp_maps
706: WHERE imp_map_id = p_imp_map.imp_map_id
707: ;
708: EXCEPTION
709: WHEN no_data_found THEN

Line 736: -- Call API to delete cn_imp_maps

732: IF x_return_status <> FND_API.g_ret_sts_success THEN
733: RAISE FND_API.G_EXC_ERROR;
734: END IF;
735:
736: -- Call API to delete cn_imp_maps
737: cn_imp_maps_pkg.delete_row
738: (p_imp_map_id => l_imp_map.imp_map_id);
739: -- End of API body.
740:

Line 737: cn_imp_maps_pkg.delete_row

733: RAISE FND_API.G_EXC_ERROR;
734: END IF;
735:
736: -- Call API to delete cn_imp_maps
737: cn_imp_maps_pkg.delete_row
738: (p_imp_map_id => l_imp_map.imp_map_id);
739: -- End of API body.
740:
741: -- Standard check of p_commit.

Line 787: END CN_IMP_MAPS_PVT;

783: );
784: END Delete_Imp_map;
785:
786:
787: END CN_IMP_MAPS_PVT;