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 2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;

2236: )
2237: IS
2238: l_count NUMBER := 0;
2239: l_rowid VARCHAR2(100);
2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;

Line 2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;

2237: IS
2238: l_count NUMBER := 0;
2239: l_rowid VARCHAR2(100);
2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;

Line 2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;

2238: l_count NUMBER := 0;
2239: l_rowid VARCHAR2(100);
2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;

Line 2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;

2239: l_rowid VARCHAR2(100);
2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;

Line 2244: l_description mtl_mfg_part_numbers.description%TYPE;

2240: l_manufacturer_id mtl_mfg_part_numbers.manufacturer_id%TYPE;
2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;

Line 2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;

2241: l_mfg_part_num mtl_mfg_part_numbers.mfg_part_num%TYPE;
2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;

Line 2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;

2242: l_inventory_item_id mtl_mfg_part_numbers.inventory_item_id%TYPE;
2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;

Line 2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;

2243: l_organization_id mtl_mfg_part_numbers.organization_id%TYPE;
2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;

Line 2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;

2244: l_description mtl_mfg_part_numbers.description%TYPE;
2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;

Line 2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;

2245: l_attribute_category mtl_mfg_part_numbers.attribute_category%TYPE;
2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;

Line 2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;

2246: l_attribute1 mtl_mfg_part_numbers.attribute1%TYPE;
2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;

Line 2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;

2247: l_attribute2 mtl_mfg_part_numbers.attribute2%TYPE;
2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;

Line 2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;

2248: l_attribute3 mtl_mfg_part_numbers.attribute3%TYPE;
2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;

Line 2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;

2249: l_attribute4 mtl_mfg_part_numbers.attribute4%TYPE;
2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;

Line 2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;

2250: l_attribute5 mtl_mfg_part_numbers.attribute5%TYPE;
2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;

Line 2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;

2251: l_attribute6 mtl_mfg_part_numbers.attribute6%TYPE;
2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;

Line 2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;

2252: l_attribute7 mtl_mfg_part_numbers.attribute7%TYPE;
2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;

Line 2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;

2253: l_attribute8 mtl_mfg_part_numbers.attribute8%TYPE;
2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
2261: l_output_status inv_ebi_output_status;

Line 2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;

2254: l_attribute9 mtl_mfg_part_numbers.attribute9%TYPE;
2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
2261: l_output_status inv_ebi_output_status;
2262: CURSOR c_mfg_part_num(

Line 2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;

2255: l_attribute10 mtl_mfg_part_numbers.attribute10%TYPE;
2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
2261: l_output_status inv_ebi_output_status;
2262: CURSOR c_mfg_part_num(
2263: p_manufacturer_id IN NUMBER

Line 2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;

2256: l_attribute11 mtl_mfg_part_numbers.attribute11%TYPE;
2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
2261: l_output_status inv_ebi_output_status;
2262: CURSOR c_mfg_part_num(
2263: p_manufacturer_id IN NUMBER
2264: ,p_mfg_part_num IN VARCHAR2

Line 2291: FROM mtl_mfg_part_numbers

2287: ,attribute12
2288: ,attribute13
2289: ,attribute14
2290: ,attribute15
2291: FROM mtl_mfg_part_numbers
2292: WHERE manufacturer_id = p_manufacturer_id
2293: AND mfg_part_num = p_mfg_part_num
2294: AND organization_id = p_organization_id
2295: AND inventory_item_id = p_inventory_item_id;

Line 2390: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2386: l_attribute15 := p_mfg_part_obj.attribute15;
2387: END IF;
2388:
2389: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
2390: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2391: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2392: x_rowid => l_rowid
2393: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2394: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 2391: MTL_MFG_PART_NUMBERS_PKG.insert_row(

2387: END IF;
2388:
2389: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
2390: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2391: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2392: x_rowid => l_rowid
2393: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2394: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
2395: ,x_inventory_item_id => p_inventory_item_id

Line 2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2416: ,x_attribute13 => p_mfg_part_obj.attribute13
2417: ,x_attribute14 => p_mfg_part_obj.attribute14
2418: ,x_attribute15 => p_mfg_part_obj.attribute15
2419: );
2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2421: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2423: MTL_MFG_PART_NUMBERS_PKG.update_row(
2424: x_rowid => l_rowid

Line 2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

2418: ,x_attribute15 => p_mfg_part_obj.attribute15
2419: );
2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2421: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2423: MTL_MFG_PART_NUMBERS_PKG.update_row(
2424: x_rowid => l_rowid
2425: ,x_manufacturer_id => l_manufacturer_id
2426: ,x_mfg_part_num => l_mfg_part_num

Line 2423: MTL_MFG_PART_NUMBERS_PKG.update_row(

2419: );
2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2421: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2423: MTL_MFG_PART_NUMBERS_PKG.update_row(
2424: x_rowid => l_rowid
2425: ,x_manufacturer_id => l_manufacturer_id
2426: ,x_mfg_part_num => l_mfg_part_num
2427: ,x_inventory_item_id => l_inventory_item_id

Line 2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

2446: ,x_attribute13 => l_attribute13
2447: ,x_attribute14 => l_attribute14
2448: ,x_attribute15 => l_attribute15
2449: );
2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

Line 2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

2448: ,x_attribute15 => l_attribute15
2449: );
2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN

Line 2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);

2449: );
2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

Line 2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(

Line 2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2459: x_rowid => l_rowid
2460: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2461: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(

2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2459: x_rowid => l_rowid
2460: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2461: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
2462: ,x_inventory_item_id => p_inventory_item_id

Line 2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2483: ,x_attribute13 => p_mfg_part_obj.attribute13
2484: ,x_attribute14 => p_mfg_part_obj.attribute14
2485: ,x_attribute15 => p_mfg_part_obj.attribute15
2486: );
2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2488: ELSE
2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2490: MTL_MFG_PART_NUMBERS_PKG.update_row(
2491: x_rowid => l_rowid

Line 2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

2485: ,x_attribute15 => p_mfg_part_obj.attribute15
2486: );
2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2488: ELSE
2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2490: MTL_MFG_PART_NUMBERS_PKG.update_row(
2491: x_rowid => l_rowid
2492: ,x_manufacturer_id => l_manufacturer_id
2493: ,x_mfg_part_num => l_mfg_part_num

Line 2490: MTL_MFG_PART_NUMBERS_PKG.update_row(

2486: );
2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2488: ELSE
2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2490: MTL_MFG_PART_NUMBERS_PKG.update_row(
2491: x_rowid => l_rowid
2492: ,x_manufacturer_id => l_manufacturer_id
2493: ,x_mfg_part_num => l_mfg_part_num
2494: ,x_inventory_item_id => l_inventory_item_id

Line 2517: INV_EBI_UTIL.debug_line('STEP: 110 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

2513: ,x_attribute13 => l_attribute13
2514: ,x_attribute14 => l_attribute14
2515: ,x_attribute15 => l_attribute15
2516: );
2517: INV_EBI_UTIL.debug_line('STEP: 110 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2518: END IF;
2519: END IF;
2520: CLOSE c_mfg_part_num;
2521: ELSE

Line 3489: FROM mtl_mfg_part_numbers

3485:
3486: CURSOR c_mfr_part_cursor(p_item_id IN NUMBER,p_org_id IN NUMBER) IS
3487: SELECT
3488: manufacturer_id,mfg_part_num
3489: FROM mtl_mfg_part_numbers
3490: WHERE inventory_item_id = p_item_id AND organization_id=p_org_id;
3491:
3492: BEGIN
3493: l_item_attr_tbl := inv_ebi_item_attr_tbl();