APPS.MTL_MFG_PART_NUMBERS_PKG dependencies on MTL_MFG_PART_NUMBERS

Line 1: PACKAGE BODY MTL_MFG_PART_NUMBERS_PKG as

1: PACKAGE BODY MTL_MFG_PART_NUMBERS_PKG as
2: /* $Header: INVIDMPB.pls 120.2.12010000.2 2008/07/29 12:52:47 ptkumar ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 33: CURSOR C IS SELECT rowid FROM mtl_mfg_part_numbers

29: X_Attribute13 VARCHAR2,
30: X_Attribute14 VARCHAR2,
31: X_Attribute15 VARCHAR2
32: ) IS
33: CURSOR C IS SELECT rowid FROM mtl_mfg_part_numbers
34: WHERE manufacturer_id = X_Manufacturer_Id
35: AND mfg_part_num = X_Mfg_Part_Num
36: AND inventory_item_id = X_Inventory_Item_Id;
37:

Line 41: INSERT INTO mtl_mfg_part_numbers(

37:
38: BEGIN
39:
40:
41: INSERT INTO mtl_mfg_part_numbers(
42:
43: manufacturer_id,
44: mfg_part_num,
45: inventory_item_id,

Line 168: FROM mtl_mfg_part_numbers

164: X_Attribute15 VARCHAR2
165: ) IS
166: CURSOR C IS
167: SELECT *
168: FROM mtl_mfg_part_numbers
169: WHERE rowid = X_Rowid
170: FOR UPDATE of Manufacturer_Id NOWAIT;
171: Recinfo C%ROWTYPE;
172:

Line 282: UPDATE mtl_mfg_part_numbers

278: X_Attribute15 VARCHAR2
279:
280: ) IS
281: BEGIN
282: UPDATE mtl_mfg_part_numbers
283: SET
284: manufacturer_id = X_Manufacturer_Id,
285: mfg_part_num = X_Mfg_Part_Num,
286: inventory_item_id = X_Inventory_Item_Id,

Line 351: l_Inventory_Item_Id mtl_mfg_part_numbers.INVENTORY_ITEM_ID%TYPE;

347:
348:
349: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
350: --R12 Business Events
351: l_Inventory_Item_Id mtl_mfg_part_numbers.INVENTORY_ITEM_ID%TYPE;
352: l_Organization_Id mtl_mfg_part_numbers.ORGANIZATION_ID%TYPE;
353: l_Mfg_Part_Num mtl_mfg_part_numbers.MFG_PART_NUM%TYPE;
354: l_Manufacturer_ID mtl_mfg_part_numbers.MANUFACTURER_ID%TYPE;
355:

Line 352: l_Organization_Id mtl_mfg_part_numbers.ORGANIZATION_ID%TYPE;

348:
349: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
350: --R12 Business Events
351: l_Inventory_Item_Id mtl_mfg_part_numbers.INVENTORY_ITEM_ID%TYPE;
352: l_Organization_Id mtl_mfg_part_numbers.ORGANIZATION_ID%TYPE;
353: l_Mfg_Part_Num mtl_mfg_part_numbers.MFG_PART_NUM%TYPE;
354: l_Manufacturer_ID mtl_mfg_part_numbers.MANUFACTURER_ID%TYPE;
355:
356: BEGIN

Line 353: l_Mfg_Part_Num mtl_mfg_part_numbers.MFG_PART_NUM%TYPE;

349: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
350: --R12 Business Events
351: l_Inventory_Item_Id mtl_mfg_part_numbers.INVENTORY_ITEM_ID%TYPE;
352: l_Organization_Id mtl_mfg_part_numbers.ORGANIZATION_ID%TYPE;
353: l_Mfg_Part_Num mtl_mfg_part_numbers.MFG_PART_NUM%TYPE;
354: l_Manufacturer_ID mtl_mfg_part_numbers.MANUFACTURER_ID%TYPE;
355:
356: BEGIN
357: --R12 Fetch the parameter values to be passed to the event

Line 354: l_Manufacturer_ID mtl_mfg_part_numbers.MANUFACTURER_ID%TYPE;

350: --R12 Business Events
351: l_Inventory_Item_Id mtl_mfg_part_numbers.INVENTORY_ITEM_ID%TYPE;
352: l_Organization_Id mtl_mfg_part_numbers.ORGANIZATION_ID%TYPE;
353: l_Mfg_Part_Num mtl_mfg_part_numbers.MFG_PART_NUM%TYPE;
354: l_Manufacturer_ID mtl_mfg_part_numbers.MANUFACTURER_ID%TYPE;
355:
356: BEGIN
357: --R12 Fetch the parameter values to be passed to the event
358: SELECT INVENTORY_ITEM_ID,

Line 367: FROM mtl_mfg_part_numbers

363: l_Inventory_Item_Id,
364: l_Organization_Id,
365: l_Mfg_Part_Num,
366: l_Manufacturer_ID
367: FROM mtl_mfg_part_numbers
368: WHERE rowid = X_Rowid;
369:
370:
371: DELETE FROM mtl_mfg_part_numbers

Line 371: DELETE FROM mtl_mfg_part_numbers

367: FROM mtl_mfg_part_numbers
368: WHERE rowid = X_Rowid;
369:
370:
371: DELETE FROM mtl_mfg_part_numbers
372: WHERE rowid = X_Rowid;
373:
374: if (SQL%NOTFOUND) then
375: Raise NO_DATA_FOUND;

Line 430: END MTL_MFG_PART_NUMBERS_PKG;

426: WHEN OTHERS THEN
427: NULL;
428: END Call_Sync_Index;
429:
430: END MTL_MFG_PART_NUMBERS_PKG;