APPS.INV_ENI_ITEMS_STAR_PKG dependencies on ENI_ITEMS_STAR_PKG

Line 1: Package Body INV_ENI_ITEMS_STAR_PKG AS

1: Package Body INV_ENI_ITEMS_STAR_PKG AS
2: /* $Header: INVENICB.pls 120.4.12020000.2 2012/07/13 08:20:14 swuppala ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ENI_ITEMS_STAR_PKG';
5:

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

1: Package Body INV_ENI_ITEMS_STAR_PKG AS
2: /* $Header: INVENICB.pls 120.4.12020000.2 2012/07/13 08:20:14 swuppala ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ENI_ITEMS_STAR_PKG';
5:
6:
7: --**********************************************************************
8: -- Maintains STAR table when changes are detected on MTL_ITEM_CATEGORIES

Line 26: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y')

22: BEGIN
23:
24: IF (INV_ITEM_UTIL.Object_Exists
25: (p_object_type => 'PACKAGE',
26: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y')
27: THEN
28:
29: --Start: bug 12416965
30: /*EXECUTE IMMEDIATE

Line 32: ' ENI_ITEMS_STAR_PKG.Sync_Category_Assignments( '||

28:
29: --Start: bug 12416965
30: /*EXECUTE IMMEDIATE
31: ' BEGIN '||
32: ' ENI_ITEMS_STAR_PKG.Sync_Category_Assignments( '||
33: ' p_api_version => :p_api_version '||
34: ' , p_init_msg_list => :p_init_msg_list '||
35: ' , p_inventory_item_id => :p_Inventory_Item_ID '||
36: ' , p_organization_id => :p_Organization_ID '||

Line 49: ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(

45: OUT x_return_status,
46: OUT x_msg_count,
47: OUT x_msg_data; */
48:
49: ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
50: p_api_version => p_api_version
51: , p_init_msg_list => p_init_msg_list
52: , p_inventory_item_id => p_inventory_item_id
53: , p_organization_id => p_organization_id

Line 173: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN

169: BEGIN
170:
171: IF (INV_ITEM_UTIL.Object_Exists
172: (p_object_type => 'PACKAGE',
173: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
174: -- the package exists
175: EXECUTE IMMEDIATE
176: ' BEGIN '||
177: ' ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI '||

Line 177: ' ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI '||

173: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
174: -- the package exists
175: EXECUTE IMMEDIATE
176: ' BEGIN '||
177: ' ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI '||
178: ' ( '||
179: ' p_api_version => :p_api_version '||
180: ' , p_init_msg_list => :p_init_msg_list '||
181: ' , p_set_process_id => :p_set_process_id '||

Line 213: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN

209: BEGIN
210:
211: IF (INV_ITEM_UTIL.Object_Exists
212: (p_object_type => 'PACKAGE',
213: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
214: -- the package exists
215: EXECUTE IMMEDIATE
216: ' BEGIN '||
217: ' ENI_ITEMS_STAR_PKG.Sync_Star_ItemCatg_From_COI '||

Line 217: ' ENI_ITEMS_STAR_PKG.Sync_Star_ItemCatg_From_COI '||

213: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
214: -- the package exists
215: EXECUTE IMMEDIATE
216: ' BEGIN '||
217: ' ENI_ITEMS_STAR_PKG.Sync_Star_ItemCatg_From_COI '||
218: ' ( '||
219: ' p_api_version => :p_api_version '||
220: ' , p_init_msg_list => :p_init_msg_list '||
221: ' , p_set_process_id => :p_set_process_id '||

Line 243: End INV_ENI_ITEMS_STAR_PKG;

239: -- Bug 4569555 RAISE;
240: END Sync_Star_ItemCatg_From_COI;
241:
242:
243: End INV_ENI_ITEMS_STAR_PKG;