DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PVT dependencies on INV_ITEM_GRP

Line 83: l_error_tbl INV_Item_GRP.Error_tbl_type;

79:
80:
81: -- added for Creation of Inventory Item sranka
82: l_count NUMBER;
83: l_error_tbl INV_Item_GRP.Error_tbl_type;
84: l_item_rec_out INV_Item_GRP.Item_rec_type;
85: l_Item_rec INV_Item_GRP.Item_rec_type;
86: l_pricelist_line_id NUMBER;
87: l_inventory_item_id NUMBER ;

Line 84: l_item_rec_out INV_Item_GRP.Item_rec_type;

80:
81: -- added for Creation of Inventory Item sranka
82: l_count NUMBER;
83: l_error_tbl INV_Item_GRP.Error_tbl_type;
84: l_item_rec_out INV_Item_GRP.Item_rec_type;
85: l_Item_rec INV_Item_GRP.Item_rec_type;
86: l_pricelist_line_id NUMBER;
87: l_inventory_item_id NUMBER ;
88: l_return_status VARCHAR2(1);

Line 85: l_Item_rec INV_Item_GRP.Item_rec_type;

81: -- added for Creation of Inventory Item sranka
82: l_count NUMBER;
83: l_error_tbl INV_Item_GRP.Error_tbl_type;
84: l_item_rec_out INV_Item_GRP.Item_rec_type;
85: l_Item_rec INV_Item_GRP.Item_rec_type;
86: l_pricelist_line_id NUMBER;
87: l_inventory_item_id NUMBER ;
88: l_return_status VARCHAR2(1);
89: l_operation VARCHAR2(30);

Line 221: x_Item_rec OUT NOCOPY INV_Item_GRP.Item_rec_type,

217:
218:
219: PROCEDURE create_inventory_item(
220: p_ptr_prgm_rec IN ptr_prgm_rec_type,
221: x_Item_rec OUT NOCOPY INV_Item_GRP.Item_rec_type,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_Error_tbl OUT NOCOPY INV_Item_GRP.Error_tbl_type
224: )
225: IS

Line 223: x_Error_tbl OUT NOCOPY INV_Item_GRP.Error_tbl_type

219: PROCEDURE create_inventory_item(
220: p_ptr_prgm_rec IN ptr_prgm_rec_type,
221: x_Item_rec OUT NOCOPY INV_Item_GRP.Item_rec_type,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_Error_tbl OUT NOCOPY INV_Item_GRP.Error_tbl_type
224: )
225: IS
226:
227: l_item_rec INV_Item_GRP.Item_rec_type;

Line 227: l_item_rec INV_Item_GRP.Item_rec_type;

223: x_Error_tbl OUT NOCOPY INV_Item_GRP.Error_tbl_type
224: )
225: IS
226:
227: l_item_rec INV_Item_GRP.Item_rec_type;
228: l_ptr_prgm_rec ptr_prgm_rec_type := p_ptr_prgm_rec;
229: l_no NUMBER;
230: l_flag VARCHAR2(1);
231:

Line 350: INV_Item_GRP.Create_Item

346: END IF;
347:
348: -- calling the inventory creation API
349:
350: INV_Item_GRP.Create_Item
351: ( p_commit => FND_API.G_FALSE
352: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
353: , p_Item_rec => l_item_rec /*P_ITEM_REC_In*/
354: , x_Item_rec => l_item_rec_out /*P_ITEM_REC_Out*/

Line 5740: l_item_rec INV_Item_GRP.Item_rec_type;

5736:
5737: l_api_version_number CONSTANT NUMBER := 1.0;
5738: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_item_if_not_exists';
5739: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5740: l_item_rec INV_Item_GRP.Item_rec_type;
5741: l_ptr_prgm_rec ptr_prgm_rec_type;
5742:
5743: CURSOR c_get_program_info IS
5744: SELECT *