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.22.12010000.2 2008/11/26 22:03:46 akbharga 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.22.12010000.2 2008/11/26 22:03:46 akbharga 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 300: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;

296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item';
298: l_api_version CONSTANT NUMBER := 1.0;
299: l_return_status VARCHAR2(1) := G_MISS_CHAR;
300: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;
301: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;
302: indx BINARY_INTEGER := 1;
303:
304: BEGIN

Line 301: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;

297: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item';
298: l_api_version CONSTANT NUMBER := 1.0;
299: l_return_status VARCHAR2(1) := G_MISS_CHAR;
300: l_Item_Tbl EGO_Item_PUB.Item_Tbl_Type;
301: l_Item_Tbl_out EGO_Item_PUB.Item_Tbl_Type;
302: indx BINARY_INTEGER := 1;
303:
304: BEGIN
305: l_Item_Tbl(indx).Transaction_Type := p_Transaction_Type;

Line 407: EGO_Item_PUB.Process_Items(

403:
404: END IF;
405:
406: IF (l_return_status IN (FND_API.G_RET_STS_SUCCESS,G_MISS_CHAR) ) THEN
407: EGO_Item_PUB.Process_Items(
408: p_api_version => 1.0
409: , p_init_msg_list => p_init_msg_list
410: , p_commit => p_commit
411: , p_Item_Tbl => l_Item_Tbl

Line 899: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;

895:
896: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Scalar';
897: l_api_version CONSTANT NUMBER := 1.0;
898: indx BINARY_INTEGER := 1;
899: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
900: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
901: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
902: l_approval_status VARCHAR2(30);
903: l_template_applied BOOLEAN := FALSE;

Line 900: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;

896: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Scalar';
897: l_api_version CONSTANT NUMBER := 1.0;
898: indx BINARY_INTEGER := 1;
899: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
900: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
901: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
902: l_approval_status VARCHAR2(30);
903: l_template_applied BOOLEAN := FALSE;
904: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;

Line 901: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;

897: l_api_version CONSTANT NUMBER := 1.0;
898: indx BINARY_INTEGER := 1;
899: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
900: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
901: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
902: l_approval_status VARCHAR2(30);
903: l_template_applied BOOLEAN := FALSE;
904: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;
905:

Line 1050: EGO_ITEM_PUB.Update_Item_Number (

1046: END IF;
1047:
1048: IF p_transaction_type = G_TTYPE_UPDATE AND l_item_tbl(indx).process_item_record = 1 THEN
1049:
1050: EGO_ITEM_PUB.Update_Item_Number (
1051: p_Inventory_Item_Id => REPLACE_G_MISS_NUM(p_inventory_item_id,null)
1052: ,p_item_number => p_item_number
1053: ,p_New_Segment1 => p_Segment1
1054: ,p_New_Segment2 => p_Segment2

Line 1549: EGO_ITEM_PUB.Update_Item_Approval_Status (

1545: l_approval_status := p_approval_status;
1546: END IF;
1547:
1548: IF NVL(p_process_control,'PLM_UI:N') <> 'EGO_INTERFACE_HANDLER' THEN --R12 C
1549: EGO_ITEM_PUB.Update_Item_Approval_Status (
1550: p_inventory_item_id => x_inventory_item_id
1551: ,p_organization_id => x_organization_id
1552: ,p_approval_status => l_approval_status );
1553: END IF;

Line 1617: ,p_Item_Org_Assignment_Tbl IN EGO_Item_PUB.Item_Org_Assignment_Tbl_Type

1613: PROCEDURE Process_Item_Org_Assignments(
1614: p_api_version IN NUMBER
1615: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
1616: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1617: ,p_Item_Org_Assignment_Tbl IN EGO_Item_PUB.Item_Org_Assignment_Tbl_Type
1618: ,x_return_status OUT NOCOPY VARCHAR2
1619: ,x_msg_count OUT NOCOPY NUMBER) IS
1620:
1621: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';

Line 1678: l_Item_Org_Assignment_Tbl EGO_Item_PUB.Item_Org_Assignment_Tbl_Type;

1674:
1675: l_api_name CONSTANT VARCHAR2(30) := 'Assign_Item_To_Org';
1676: l_api_version CONSTANT NUMBER := 1.0;
1677: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1678: l_Item_Org_Assignment_Tbl EGO_Item_PUB.Item_Org_Assignment_Tbl_Type;
1679: indx BINARY_INTEGER := 1;
1680: BEGIN
1681:
1682: l_Item_Org_Assignment_Tbl(indx).Inventory_Item_Id := p_Inventory_Item_Id;

Line 1688: EGO_Item_PUB.Process_Item_Org_Assignments(

1684: l_Item_Org_Assignment_Tbl(indx).Organization_Id := p_Organization_Id;
1685: l_Item_Org_Assignment_Tbl(indx).Organization_Code := p_Organization_Code;
1686: l_Item_Org_Assignment_Tbl(indx).Primary_Uom_Code := p_Primary_Uom_Code;
1687:
1688: EGO_Item_PUB.Process_Item_Org_Assignments(
1689: p_api_version => 1.0
1690: , p_init_msg_list => p_init_msg_list
1691: , p_commit => p_commit
1692: , p_Item_Org_Assignment_Tbl => l_Item_Org_Assignment_Tbl

Line 1742: ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type

1738: ,p_New_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1739: ,p_New_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1740: ,p_New_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1741: ,p_New_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1742: ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
1743: ,x_return_status OUT NOCOPY VARCHAR2) IS
1744:
1745: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1746: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

Line 2137: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

2133: ---------------------------------------------------------------------------
2134: PROCEDURE initialize_item_info (p_inventory_item_id IN NUMBER
2135: ,p_organization_id IN NUMBER
2136: ,p_tab_index IN INTEGER
2137: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
2138: ,x_return_status OUT NOCOPY VARCHAR2
2139: ,x_msg_count OUT NOCOPY NUMBER) IS
2140:
2141: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER

Line 2539: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type

2535: ,p_template_name IN VARCHAR2
2536: ,p_organization_id IN NUMBER
2537: ,p_organization_code IN VARCHAR2
2538: ,p_tab_index IN INTEGER
2539: ,x_item_table IN OUT NOCOPY EGO_ITEM_PUB.Item_Tbl_Type
2540: ,x_return_status OUT NOCOPY VARCHAR2
2541: ,x_msg_count OUT NOCOPY NUMBER) IS
2542:
2543: CURSOR c_get_context_org (cp_template_id IN NUMBER) IS

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

3422: END IF;
3423: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3424: X_MSG_COUNT := 0;
3425:
3426: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
3427:
3428: IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3429: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3430: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL

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

3432:
3433: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3434: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3435: ELSE
3436: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3437:
3438: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
3439: -- and pending_flag = N.
3440: INSERT INTO MTL_PENDING_ITEM_STATUS(

Line 4731: END EGO_ITEM_PUB;

4727: , p_data => x_msg_data
4728: );
4729: END Prep_Batch_Data_For_Import_UI;
4730:
4731: END EGO_ITEM_PUB;