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.INV_EBI_ITEM_HELPER dependencies on MTL_MFG_PART_NUMBERS

Line 3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;

3255: )
3256: IS
3257: l_count NUMBER := 0;
3258: l_rowid VARCHAR2(100);
3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;

Line 3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;

3256: IS
3257: l_count NUMBER := 0;
3258: l_rowid VARCHAR2(100);
3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;

Line 3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;

3257: l_count NUMBER := 0;
3258: l_rowid VARCHAR2(100);
3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;

Line 3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;

3258: l_rowid VARCHAR2(100);
3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;

Line 3263: l_description mtl_mfg_part_numbers.description%TYPE;

3259: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;

Line 3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;

3260: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;

Line 3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;

3261: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;

Line 3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;

3262: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;

Line 3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;

3263: l_description mtl_mfg_part_numbers.description%TYPE;
3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;

Line 3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;

3264: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;

Line 3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;

3265: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;

Line 3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;

3266: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;

Line 3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;

3267: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;

Line 3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;

3268: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;

Line 3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;

3269: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;

Line 3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;

3270: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;

Line 3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;

3271: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;

Line 3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;

3272: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
3280: l_output_status inv_ebi_output_status;

Line 3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;

3273: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
3280: l_output_status inv_ebi_output_status;
3281: CURSOR c_mfg_part_num(

Line 3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;

3274: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
3280: l_output_status inv_ebi_output_status;
3281: CURSOR c_mfg_part_num(
3282: p_manufacturer_id IN NUMBER

Line 3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;

3275: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
3276: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
3277: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
3278: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
3279: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
3280: l_output_status inv_ebi_output_status;
3281: CURSOR c_mfg_part_num(
3282: p_manufacturer_id IN NUMBER
3283: ,p_mfg_part_num IN VARCHAR2

Line 3310: FROM mtl_mfg_part_numbers

3306: ,attribute12
3307: ,attribute13
3308: ,attribute14
3309: ,attribute15
3310: FROM mtl_mfg_part_numbers
3311: WHERE manufacturer_id = p_manufacturer_id
3312: AND mfg_part_num = p_mfg_part_num
3313: AND organization_id = p_organization_id
3314: AND inventory_item_id = p_inventory_item_id;

Line 3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3407: l_attribute15 := p_mfg_part_obj.attribute15;
3408: END IF;
3409:
3410: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3413: x_rowid => l_rowid
3414: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3415: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(

3408: END IF;
3409:
3410: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3413: x_rowid => l_rowid
3414: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3415: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3416: ,x_inventory_item_id => p_inventory_item_id

Line 3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3437: ,x_attribute13 => p_mfg_part_obj.attribute13
3438: ,x_attribute14 => p_mfg_part_obj.attribute14
3439: ,x_attribute15 => p_mfg_part_obj.attribute15
3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid

Line 3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

3439: ,x_attribute15 => p_mfg_part_obj.attribute15
3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid
3446: ,x_manufacturer_id => l_manufacturer_id
3447: ,x_mfg_part_num => l_mfg_part_num

Line 3444: MTL_MFG_PART_NUMBERS_PKG.update_row(

3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid
3446: ,x_manufacturer_id => l_manufacturer_id
3447: ,x_mfg_part_num => l_mfg_part_num
3448: ,x_inventory_item_id => l_inventory_item_id

Line 3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

3467: ,x_attribute13 => l_attribute13
3468: ,x_attribute14 => l_attribute14
3469: ,x_attribute15 => l_attribute15
3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

Line 3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

3469: ,x_attribute15 => l_attribute15
3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN

Line 3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);

3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

Line 3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(

Line 3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3480: x_rowid => l_rowid
3481: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3482: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(

3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3480: x_rowid => l_rowid
3481: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3482: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3483: ,x_inventory_item_id => p_inventory_item_id

Line 3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3504: ,x_attribute13 => p_mfg_part_obj.attribute13
3505: ,x_attribute14 => p_mfg_part_obj.attribute14
3506: ,x_attribute15 => p_mfg_part_obj.attribute15
3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid

Line 3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

3506: ,x_attribute15 => p_mfg_part_obj.attribute15
3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid
3513: ,x_manufacturer_id => l_manufacturer_id
3514: ,x_mfg_part_num => l_mfg_part_num

Line 3511: MTL_MFG_PART_NUMBERS_PKG.update_row(

3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid
3513: ,x_manufacturer_id => l_manufacturer_id
3514: ,x_mfg_part_num => l_mfg_part_num
3515: ,x_inventory_item_id => l_inventory_item_id

Line 3538: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

3534: ,x_attribute13 => l_attribute13
3535: ,x_attribute14 => l_attribute14
3536: ,x_attribute15 => l_attribute15
3537: );
3538: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3539: END IF;
3540: END IF;
3541: CLOSE c_mfg_part_num;
3542: ELSE

Line 5005: FROM mtl_mfg_part_numbers

5001:
5002: CURSOR c_mfr_part_cursor(p_item_id IN NUMBER,p_org_id IN NUMBER) IS
5003: SELECT
5004: manufacturer_id,mfg_part_num
5005: FROM mtl_mfg_part_numbers
5006: WHERE inventory_item_id = p_item_id AND organization_id=p_org_id;
5007:
5008: BEGIN
5009: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.get_item_attributes');