DBA Data[Home] [Help]

APPS.EGO_UI_ITEM_PUB dependencies on EGO_ITEM_PUB

Line 19: g_in_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;

15: g_USER_ID NUMBER := FND_GLOBAL.User_Id;
16: g_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
17:
18: -- the below variables are used for copy item
19: g_in_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
20: g_out_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
21: -- end of global variables for copy_item_functionality
22:
23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;

Line 20: g_out_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;

16: g_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
17:
18: -- the below variables are used for copy item
19: g_in_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
20: g_out_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
21: -- end of global variables for copy_item_functionality
22:
23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;
24: --g_MISS_NUM NUMBER := FND_API.g_MISS_NUM;

Line 1950: developer_debug (' Before calling ego_item_pub.process_items');

1946: g_in_item_tbl(0).Long_Description := p_long_description;
1947: g_in_item_tbl(0).Primary_Uom_Code := p_primary_uom_code;
1948: g_in_item_tbl(0).Inventory_Item_Status_Code := p_Inventory_Item_Status_Code;
1949:
1950: developer_debug (' Before calling ego_item_pub.process_items');
1951: EGO_ITEM_PUB.Process_Items
1952: (p_api_version => 1.0
1953: ,p_init_msg_list => FND_API.g_FALSE
1954: ,p_commit => FND_API.g_FALSE

Line 1951: EGO_ITEM_PUB.Process_Items

1947: g_in_item_tbl(0).Primary_Uom_Code := p_primary_uom_code;
1948: g_in_item_tbl(0).Inventory_Item_Status_Code := p_Inventory_Item_Status_Code;
1949:
1950: developer_debug (' Before calling ego_item_pub.process_items');
1951: EGO_ITEM_PUB.Process_Items
1952: (p_api_version => 1.0
1953: ,p_init_msg_list => FND_API.g_FALSE
1954: ,p_commit => FND_API.g_FALSE
1955: ,p_Item_Tbl => g_in_item_tbl

Line 1956: ,p_Role_Grant_Tbl => EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL

1952: (p_api_version => 1.0
1953: ,p_init_msg_list => FND_API.g_FALSE
1954: ,p_commit => FND_API.g_FALSE
1955: ,p_Item_Tbl => g_in_item_tbl
1956: ,p_Role_Grant_Tbl => EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL
1957: ,x_Item_Tbl => g_out_item_tbl
1958: ,x_return_status => x_return_status
1959: ,x_msg_count => x_msg_count
1960: );

Line 1966: -- messages already logged by EGO_ITEM_PUB

1962: -- item created successfully
1963: x_inventory_item_id := g_out_item_tbl(0).inventory_item_id;
1964: x_organization_id := g_out_item_tbl(0).organization_id;
1965: ELSE
1966: -- messages already logged by EGO_ITEM_PUB
1967: RETURN;
1968: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS
1969: OPEN c_fnd_object_id (cp_object_name => G_OBJECT_NAME);
1970: FETCH c_fnd_object_id INTO l_object_id;

Line 2085: -- EGO_ITEM_PUB.Seed_Item_Long_Desc_Attr_Group

2081: -----------------------------------------------------------------------
2082: -- Dylan added this clean-up procedure to deal with duplicate
2083: -- Item Long Desc AG rows from the above calls to Copy_User_Attrs_Data
2084: -- in conjunction with the call that's made to
2085: -- EGO_ITEM_PUB.Seed_Item_Long_Desc_Attr_Group
2086: -- from
2087: -- INVPOPIF.inopinp_OI_process_create
2088: -----------------------------------------------------------------------
2089: Delete_Extra_Item_Long_Desc_AG(x_inventory_item_id, x_organization_id);

Line 2742: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;

2738: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Scalar';
2739: l_api_version CONSTANT NUMBER := 1.0;
2740:
2741: indx BINARY_INTEGER := 1;
2742: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
2743: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
2744:
2745: BEGIN
2746: developer_debug (' ISS: Started Item Scalar Signature ');

Line 2743: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;

2739: l_api_version CONSTANT NUMBER := 1.0;
2740:
2741: indx BINARY_INTEGER := 1;
2742: l_item_tbl EGO_ITEM_PUB.Item_Tbl_Type;
2743: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
2744:
2745: BEGIN
2746: developer_debug (' ISS: Started Item Scalar Signature ');
2747:

Line 3151: EGO_ITEM_PUB.Update_Item_Number (

3147: --
3148: -- transaction type = 'UPDATE'
3149: --
3150: developer_debug (' ISS: calling Update_item_number ');
3151: EGO_ITEM_PUB.Update_Item_Number (
3152: p_Inventory_Item_Id => x_inventory_item_id
3153: ,p_Item_Number => p_Item_Number
3154: ,p_Segment1 => NULL
3155: ,p_Segment2 => NULL

Line 3206: developer_debug (' ISS: calling EGO_ITEM_PUB.Update_Item_Approval_Status ');

3202: END IF;
3203: END IF;
3204: -- common processing after update
3205: -- call the update approval status routine now
3206: developer_debug (' ISS: calling EGO_ITEM_PUB.Update_Item_Approval_Status ');
3207: developer_debug (' ISS: inventory_item_id -> '||to_char(x_inventory_item_id));
3208: developer_debug (' ISS: organization_id -> '||to_char(x_organization_id));
3209: developer_debug (' ISS: approval_status -> '||p_approval_status);
3210: EGO_ITEM_PUB.Update_Item_Approval_Status (

Line 3210: EGO_ITEM_PUB.Update_Item_Approval_Status (

3206: developer_debug (' ISS: calling EGO_ITEM_PUB.Update_Item_Approval_Status ');
3207: developer_debug (' ISS: inventory_item_id -> '||to_char(x_inventory_item_id));
3208: developer_debug (' ISS: organization_id -> '||to_char(x_organization_id));
3209: developer_debug (' ISS: approval_status -> '||p_approval_status);
3210: EGO_ITEM_PUB.Update_Item_Approval_Status (
3211: p_inventory_item_id => x_inventory_item_id
3212: ,p_organization_id => x_organization_id
3213: ,p_approval_status => p_approval_status
3214: );