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 2007/06/14 12:48:55 nshariff 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 2007/06/14 12:48:55 nshariff 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 456: EGO_Item_Catalog_Pub.Process_Catalog_Group

452: BEGIN
453:
454: ---------------------------------------------------
455: -- Insert catalog group
456: EGO_Item_Catalog_Pub.Process_Catalog_Group
457: ( p_Catalog_Group_Id => p_Catalog_Group_Id
458: , p_Parent_Catalog_Group_Id => p_Parent_Catalog_Group_Id
459: , p_Description => p_Description
460: , p_Item_Creation_Allowed_Flag => p_Item_Creation_Allowed_Flag

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

520: , x_message_type => l_message_type
521: );
522:
523: x_msg_count := ERROR_HANDLER.Get_Message_Count();
524: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;
525: END IF;
526:
527: EXCEPTION
528: WHEN OTHERS THEN

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

541: , x_message_type => l_message_type
542: );
543:
544: x_msg_count := ERROR_HANDLER.Get_Message_Count();
545: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.CREATE_CATALOG_GROUP '||l_message_list;
546:
547: END CREATE_CATALOG_GROUP;
548:
549: ---------------------------------------------------------

Line 619: EGO_Item_Catalog_Pub.Process_Catalog_Group

615: BEGIN
616:
617: ---------------------------------------------------
618: -- Update catalog group
619: EGO_Item_Catalog_Pub.Process_Catalog_Group
620: ( p_Catalog_Group_Id => p_Catalog_Group_Id
621: , p_Parent_Catalog_Group_Id => p_Parent_Catalog_Group_Id
622: , p_Description => p_Description
623: , p_Item_Creation_Allowed_Flag => p_Item_Creation_Allowed_Flag

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

687: , x_message_type => l_message_type
688: );
689:
690: x_msg_count := ERROR_HANDLER.Get_Message_Count();
691: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;
692: END IF;
693:
694:
695:

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

734: , x_message_type => l_message_type
735: );
736:
737: x_msg_count := ERROR_HANDLER.Get_Message_Count();
738: x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;
739:
740: END UPDATE_CATALOG_GROUP;
741:
742: ---------------------------------------------------------------

Line 1103: END EGO_ITEM_CATALOG_PUB;

1099:
1100:
1101:
1102:
1103: END EGO_ITEM_CATALOG_PUB;