eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_CATALOG_PUB dependencies on EGO_ITEM_CATALOG_PUB

Line 1: PACKAGE BODY EGO_ITEM_CATALOG_PUB AS

1: PACKAGE BODY EGO_ITEM_CATALOG_PUB AS
2: /* $Header: EGOBCAGB.pls 120.7.12010000.3 2009/05/04 07:16:58 chechand ship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_PUB';
5: g_app_name VARCHAR2(3) := 'EGO';

Line 4: g_pkg_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_PUB';

1: PACKAGE BODY EGO_ITEM_CATALOG_PUB AS
2: /* $Header: EGOBCAGB.pls 120.7.12010000.3 2009/05/04 07:16:58 chechand ship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_PUB';
5: g_app_name VARCHAR2(3) := 'EGO';
6: g_current_user_id NUMBER := EGO_SCTX.Get_User_Id();
7: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
8: g_plsql_err VARCHAR2(17) := 'EGO_PLSQL_ERR';

Line 126: , p_catalog_group_tbl IN Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type

122: Procedure Process_Catalog_Groups
123: ( p_bo_identifier IN VARCHAR2 := 'ICG'
124: , p_api_version_number IN NUMBER := 1.0
125: , p_init_msg_list IN BOOLEAN := FALSE
126: , p_catalog_group_tbl IN Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
127: , p_user_id IN NUMBER
128: , p_language_code IN VARCHAR2 := 'US'
129: , x_catalog_group_tbl OUT NOCOPY Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
130: , x_return_status OUT NOCOPY VARCHAR2

Line 129: , x_catalog_group_tbl OUT NOCOPY Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type

125: , p_init_msg_list IN BOOLEAN := FALSE
126: , p_catalog_group_tbl IN Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
127: , p_user_id IN NUMBER
128: , p_language_code IN VARCHAR2 := 'US'
129: , x_catalog_group_tbl OUT NOCOPY Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
130: , x_return_status OUT NOCOPY VARCHAR2
131: , x_msg_count OUT NOCOPY NUMBER
132: , p_debug IN VARCHAR2 := 'N'
133: , p_output_dir IN VARCHAR2 := NULL

Line 158: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;

154: --
155:
156: FOR i in 1..20
157: LOOP
158: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
159: END LOOP;
160:
161: EGO_Globals.G_Catalog_Group_Rec := null;
162:

Line 334: l_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;

330: , p_debug_filename IN VARCHAR2 := 'Ego_Catalog_Grp.log'
331: , x_catalog_group_id OUT NOCOPY NUMBER
332: , x_catalog_group_name OUT NOCOPY VARCHAR2
333: ) IS
334: l_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;
335: x_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;
336: BEGIN
337: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name := p_catalog_group_name;
338: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name := p_parent_catalog_group_name;

Line 335: x_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;

331: , x_catalog_group_id OUT NOCOPY NUMBER
332: , x_catalog_group_name OUT NOCOPY VARCHAR2
333: ) IS
334: l_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;
335: x_catalog_group_tbl EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;
336: BEGIN
337: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name := p_catalog_group_name;
338: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name := p_parent_catalog_group_name;
339: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id := p_catalog_group_id;

Line 372: EGO_Item_Catalog_Pub.Process_Catalog_Groups

368: l_catalog_group_tbl(1) := EGO_Globals.G_Catalog_Group_Rec;
369:
370: -- -- dbms_output.put_line('local table count of records before start : ' || l_catalog_group_tbl.count);
371:
372: EGO_Item_Catalog_Pub.Process_Catalog_Groups
373: ( p_catalog_group_tbl => l_catalog_group_tbl
374: , p_user_id => p_user_id
375: , p_Language_Code => p_Language_Code
376: , x_catalog_group_tbl => x_catalog_group_tbl

Line 480: EGO_Item_Catalog_Pub.Process_Catalog_Group

476: END IF;
477:
478: ---------------------------------------------------
479: -- Insert catalog group
480: EGO_Item_Catalog_Pub.Process_Catalog_Group
481: ( p_Catalog_Group_Id => p_Catalog_Group_Id
482: , p_Parent_Catalog_Group_Id => p_Parent_Catalog_Group_Id
483: , p_Description => p_Description
484: , p_Item_Creation_Allowed_Flag => p_Item_Creation_Allowed_Flag

Line 590: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;

586: , x_message_type => l_message_type
587: );
588:
589: x_msg_count := ERROR_HANDLER.Get_Message_Count();
590: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;
591: END IF;
592:
593: EXCEPTION
594: WHEN OTHERS THEN

Line 611: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;

607: , x_message_type => l_message_type
608: );
609:
610: x_msg_count := ERROR_HANDLER.Get_Message_Count();
611: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;
612:
613: END CREATE_CATALOG_GROUP;
614:
615: ---------------------------------------------------------

Line 685: EGO_Item_Catalog_Pub.Process_Catalog_Group

681: BEGIN
682:
683: ---------------------------------------------------
684: -- Update catalog group
685: EGO_Item_Catalog_Pub.Process_Catalog_Group
686: ( p_Catalog_Group_Id => p_Catalog_Group_Id
687: , p_Parent_Catalog_Group_Id => p_Parent_Catalog_Group_Id
688: , p_Description => p_Description
689: , p_Item_Creation_Allowed_Flag => p_Item_Creation_Allowed_Flag

Line 757: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;

753: , x_message_type => l_message_type
754: );
755:
756: x_msg_count := ERROR_HANDLER.Get_Message_Count();
757: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;
758: END IF;
759:
760:
761:

Line 804: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;

800: , x_message_type => l_message_type
801: );
802:
803: x_msg_count := ERROR_HANDLER.Get_Message_Count();
804: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;
805:
806: END UPDATE_CATALOG_GROUP;
807:
808: ---------------------------------------------------------------

Line 1169: END EGO_ITEM_CATALOG_PUB;

1165:
1166:
1167:
1168:
1169: END EGO_ITEM_CATALOG_PUB;