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_PUB dependencies on EGO_ITEM_PUB

Line 1: PACKAGE BODY EGO_ITEM_PUB AS

1: PACKAGE BODY EGO_ITEM_PUB AS
2: /* $Header: EGOPITMB.pls 120.40.12020000.6 2012/11/19 12:12:02 vijoshi ship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOPITMB.pls';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_PUB';

1: PACKAGE BODY EGO_ITEM_PUB AS
2: /* $Header: EGOPITMB.pls 120.40.12020000.6 2012/11/19 12:12:02 vijoshi ship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOPITMB.pls';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_PUB';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9:

Line 14: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

10: PROCEDURE initialize_item_info
11: (p_inventory_item_id IN NUMBER
12: ,p_organization_id IN NUMBER
13: ,p_tab_index IN INTEGER
14: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
15: ,x_return_status OUT NOCOPY VARCHAR2
16: ,x_msg_count OUT NOCOPY NUMBER);
17:
18: PROCEDURE initialize_template_info

Line 24: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

20: ,p_template_name IN VARCHAR2
21: ,p_organization_id IN NUMBER
22: ,p_organization_code IN VARCHAR2
23: ,p_tab_index IN INTEGER
24: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER);
27:
28:

Line 120: ,p_Item_Tbl IN EGO_Item_PUB.Item_Tbl_Type

116: PROCEDURE Process_Items(
117: p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
119: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
120: ,p_Item_Tbl IN EGO_Item_PUB.Item_Tbl_Type
121: ,x_Item_Tbl OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
122: ,p_Role_Grant_Tbl IN EGO_Item_PUB.Role_Grant_Tbl_Type DEFAULT EGO_Item_PUB.G_MISS_Role_Grant_Tbl
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER) IS

Line 121: ,x_Item_Tbl OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type

117: p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
119: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
120: ,p_Item_Tbl IN EGO_Item_PUB.Item_Tbl_Type
121: ,x_Item_Tbl OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
122: ,p_Role_Grant_Tbl IN EGO_Item_PUB.Role_Grant_Tbl_Type DEFAULT EGO_Item_PUB.G_MISS_Role_Grant_Tbl
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER) IS
125:

Line 122: ,p_Role_Grant_Tbl IN EGO_Item_PUB.Role_Grant_Tbl_Type DEFAULT EGO_Item_PUB.G_MISS_Role_Grant_Tbl

118: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
119: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
120: ,p_Item_Tbl IN EGO_Item_PUB.Item_Tbl_Type
121: ,x_Item_Tbl OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
122: ,p_Role_Grant_Tbl IN EGO_Item_PUB.Role_Grant_Tbl_Type DEFAULT EGO_Item_PUB.G_MISS_Role_Grant_Tbl
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER) IS
125:
126: l_api_name CONSTANT VARCHAR2(30) := 'Process_Items';

Line 130: l_item_tbl EGO_Item_PUB.Item_Tbl_Type;

126: l_api_name CONSTANT VARCHAR2(30) := 'Process_Items';
127: l_api_version CONSTANT NUMBER := 1.0;
128: l_return_status VARCHAR2(1) := G_MISS_CHAR;
129: l_tab_index NUMBER := p_Item_Tbl.FIRST;
130: l_item_tbl EGO_Item_PUB.Item_Tbl_Type;
131:
132: BEGIN
133:
134: x_return_status := G_RET_STS_SUCCESS;

Line 309: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;

305:
306: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item';
307: l_api_version CONSTANT NUMBER := 1.0;
308: l_return_status VARCHAR2(1) := G_MISS_CHAR;
309: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;
310: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;
311: indx BINARY_INTEGER := 1;
312:
313: BEGIN

Line 310: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;

306: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item';
307: l_api_version CONSTANT NUMBER := 1.0;
308: l_return_status VARCHAR2(1) := G_MISS_CHAR;
309: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;
310: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;
311: indx BINARY_INTEGER := 1;
312:
313: BEGIN
314: l_Item_Tbl(indx).Transaction_Type := p_Transaction_Type;

Line 416: EGO_Item_PUB.Process_Items(

412:
413: END IF;
414:
415: IF (l_return_status IN (FND_API.G_RET_STS_SUCCESS,G_MISS_CHAR) ) THEN
416: EGO_Item_PUB.Process_Items(
417: p_api_version => 1.0
418: , p_init_msg_list => p_init_msg_list
419: , p_commit => p_commit
420: , p_Item_Tbl => l_Item_Tbl

Line 913: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;

909:
910: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Scalar';
911: l_api_version CONSTANT NUMBER := 1.0;
912: indx BINARY_INTEGER := 1;
913: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
916: l_approval_status VARCHAR2(30);
917: l_template_applied BOOLEAN := FALSE;

Line 914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;

910: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Scalar';
911: l_api_version CONSTANT NUMBER := 1.0;
912: indx BINARY_INTEGER := 1;
913: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
916: l_approval_status VARCHAR2(30);
917: l_template_applied BOOLEAN := FALSE;
918: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;

Line 915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;

911: l_api_version CONSTANT NUMBER := 1.0;
912: indx BINARY_INTEGER := 1;
913: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
916: l_approval_status VARCHAR2(30);
917: l_template_applied BOOLEAN := FALSE;
918: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;
919:

Line 1082: EGO_ITEM_PUB.Update_Item_Number (

1078: ---
1079:
1080: IF p_transaction_type = G_TTYPE_UPDATE AND l_item_tbl(indx).process_item_record = 1 THEN
1081:
1082: EGO_ITEM_PUB.Update_Item_Number (
1083: p_Inventory_Item_Id => REPLACE_G_MISS_NUM(p_inventory_item_id,null)
1084: ,p_item_number => p_item_number
1085: ,p_New_Segment1 => p_Segment1
1086: ,p_New_Segment2 => p_Segment2

Line 1630: EGO_ITEM_PUB.Update_Item_Approval_Status (

1626: -- fix for bug#8975836
1627: IF ((p_transaction_type = G_TTYPE_CREATE) OR
1628: (p_transaction_type = G_TTYPE_UPDATE and p_approval_status <> G_MISS_CHAR)) THEN
1629: IF NVL(p_process_control,'PLM_UI:N') <> 'EGO_INTERFACE_HANDLER' THEN --R12 C
1630: EGO_ITEM_PUB.Update_Item_Approval_Status (
1631: p_inventory_item_id => x_inventory_item_id
1632: ,p_organization_id => x_organization_id
1633: ,p_approval_status => l_approval_status );
1634: END IF;

Line 1699: ,p_Item_Org_Assignment_Tbl IN EGO_Item_PUB.Item_Org_Assignment_Tbl_Type

1695: PROCEDURE Process_Item_Org_Assignments(
1696: p_api_version IN NUMBER
1697: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
1698: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1699: ,p_Item_Org_Assignment_Tbl IN EGO_Item_PUB.Item_Org_Assignment_Tbl_Type
1700: ,x_return_status OUT NOCOPY VARCHAR2
1701: ,x_msg_count OUT NOCOPY NUMBER) IS
1702:
1703: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';

Line 1760: l_Item_Org_Assignment_Tbl EGO_Item_PUB.Item_Org_Assignment_Tbl_Type;

1756:
1757: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Item_To_Org';
1758: l_api_version CONSTANT NUMBER := 1.0;
1759: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1760: l_Item_Org_Assignment_Tbl EGO_Item_PUB.Item_Org_Assignment_Tbl_Type;
1761: indx BINARY_INTEGER := 1;
1762: BEGIN
1763:
1764: l_Item_Org_Assignment_Tbl(indx).Inventory_Item_Id := p_Inventory_Item_Id;

Line 1770: EGO_Item_PUB.Process_Item_Org_Assignments(

1766: l_Item_Org_Assignment_Tbl(indx).Organization_Id := p_Organization_Id;
1767: l_Item_Org_Assignment_Tbl(indx).Organization_Code := p_Organization_Code;
1768: l_Item_Org_Assignment_Tbl(indx).Primary_Uom_Code := p_Primary_Uom_Code;
1769:
1770: EGO_Item_PUB.Process_Item_Org_Assignments(
1771: p_api_version => 1.0
1772: , p_init_msg_list => p_init_msg_list
1773: , p_commit => p_commit
1774: , p_Item_Org_Assignment_Tbl => l_Item_Org_Assignment_Tbl

Line 1824: ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type

1820: ,p_New_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1821: ,p_New_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1822: ,p_New_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1823: ,p_New_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1824: ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
1825: ,x_return_status OUT NOCOPY VARCHAR2) IS
1826:
1827: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1828: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

Line 2288: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

2284: ---------------------------------------------------------------------------
2285: PROCEDURE initialize_item_info (p_inventory_item_id IN NUMBER
2286: ,p_organization_id IN NUMBER
2287: ,p_tab_index IN INTEGER
2288: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
2289: ,x_return_status OUT NOCOPY VARCHAR2
2290: ,x_msg_count OUT NOCOPY NUMBER) IS
2291:
2292: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER

Line 2690: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

2686: ,p_template_name IN VARCHAR2
2687: ,p_organization_id IN NUMBER
2688: ,p_organization_code IN VARCHAR2
2689: ,p_tab_index IN INTEGER
2690: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
2691: ,x_return_status OUT NOCOPY VARCHAR2
2692: ,x_msg_count OUT NOCOPY NUMBER) IS
2693:
2694: CURSOR c_get_context_org (cp_template_id IN NUMBER) IS

Line 3645: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);

3641: ELSIF (P_ITEM_STATUS = L_CURRENT_STATUS_CODE) THEN
3642: L_UPDATE_STATUS_HIS_IND := FALSE;
3643: END IF;
3644:
3645: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
3646: /*Changed for bug 7660662*/
3647:
3648: --IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3649: /*Changes for bug 7659489. Even when ICC is not associated to an item changes to Item status should be inserted into MTL_PENDING_ITEM_STATUSES

Line 3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');

3647:
3648: --IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3649: /*Changes for bug 7659489. Even when ICC is not associated to an item changes to Item status should be inserted into MTL_PENDING_ITEM_STATUSES
3650: so that the history of changes is properly logged*/
3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3652: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3653: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3654:
3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL

Line 3725: /L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');/ /Commented for bug 7659489/

3721: P_ITEM_STATUS);
3722: END IF;
3723: /*End of bug 7659489*/
3724: ELSE
3725: /*L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');*/ /*Commented for bug 7659489*/
3726:
3727: /*IF Master control then insert for all the organizations with Pending status as 'N'*/
3728: IF ((L_CONTROL_LEVEL = 1) AND (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID))
3729: THEN

Line 5001: END EGO_ITEM_PUB;

4997: , p_data => x_msg_data
4998: );
4999: END Prep_Batch_Data_For_Import_UI;
5000:
5001: END EGO_ITEM_PUB;