DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_CCEOI_VAR_PVT

Line 43: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

39: ;
40: --
41: -- Insert the record into the application tables
42: PROCEDURE Insert_CCEntry(
43: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
44: ;
45: --
46: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE
47: --Added NOCOPY hint to x_return_status OUT

Line 50: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,

46: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE
47: --Added NOCOPY hint to x_return_status OUT
48: --parameter to comply with GSCC File.Sql.39 standard. Bug:4410902
49: PROCEDURE Insert_CCIEntry(
50: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
51: x_return_status OUT NOCOPY VARCHAR2 )
52: ;
53: --
54: -- Insert record into Cycle Count Interface error table

Line 139: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.Inv_Item_rec_type ,

135: x_msg_count OUT NOCOPY NUMBER ,
136: x_msg_data OUT NOCOPY VARCHAR2 ,
137: x_errorcode OUT NOCOPY NUMBER ,
138: p_cycle_count_header_id IN NUMBER ,
139: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.Inv_Item_rec_type ,
140: p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,
141: p_subinventory IN VARCHAR2 ,
142: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
143: p_organization_id IN number,

Line 140: p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,

136: x_msg_data OUT NOCOPY VARCHAR2 ,
137: x_errorcode OUT NOCOPY NUMBER ,
138: p_cycle_count_header_id IN NUMBER ,
139: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.Inv_Item_rec_type ,
140: p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,
141: p_subinventory IN VARCHAR2 ,
142: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
143: p_organization_id IN number,
144: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)

Line 142: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,

138: p_cycle_count_header_id IN NUMBER ,
139: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.Inv_Item_rec_type ,
140: p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,
141: p_subinventory IN VARCHAR2 ,
142: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
143: p_organization_id IN number,
144: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
145: ;
146: --

Line 204: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

200: x_msg_count OUT NOCOPY NUMBER ,
201: x_msg_data OUT NOCOPY VARCHAR2 ,
202: x_errorcode OUT NOCOPY NUMBER ,
203: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
205: ;
206: --
207: -- updates CC entry record information
208: PROCEDURE Update_CCEntry(

Line 215: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,

211: -- updates interface record information
212: --Added NOCOPY hint to x_return_status OUT
213: --parameter to comply with GSCC File.Sql.39 standard. Bug:4410902
214: PROCEDURE Update_CCIEntry(
215: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
216: x_return_status OUT NOCOPY VARCHAR2 );
217: --
218: FUNCTION check_serial_location(P_issue_receipt IN VARCHAR2,
219: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE ) return BOOLEAN;