DBA Data[Home] [Help]

APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on INV_GENEALOGY_PUB

Line 324: inv_genealogy_pub.delete_eam_row(

320:
321: OR ((p_start_date_active <= i.end_date_active)
322: AND (l_end_date_active >= i.end_date_active)) THEN
323:
324: inv_genealogy_pub.delete_eam_row(
325: p_api_version=>1.0,
326: p_object_id => l_gen_object_id,
327: p_start_date_active=>i.start_date_active,
328: p_end_date_active=>i.end_date_active,

Line 336: inv_genealogy_pub.delete_eam_row(

332: l_pn_gen_mode := 0;
333: END IF;
334: ELSE
335: IF (p_start_date_active <= i.end_date_active) THEN
336: inv_genealogy_pub.delete_eam_row(
337: p_api_version=>1.0,
338: p_object_id => l_gen_object_id,
339: p_start_date_active=>i.start_date_active,
340: p_end_date_active=>i.end_date_active,

Line 353: inv_genealogy_pub.delete_eam_row(

349: IF l_end_date_active IS NULL THEN
350: if p_start_date_active = i.start_date_active then
351: l_pn_gen_mode := 2;
352: else
353: inv_genealogy_pub.delete_eam_row(
354: p_api_version=>1.0,
355: p_object_id => l_gen_object_id,
356: p_start_date_active=>i.start_date_active,
357: p_end_date_active=>i.end_date_active,

Line 370: inv_genealogy_pub.delete_eam_row(

366: IF (p_start_date_active = i.start_date_active) THEN
367: l_pn_gen_mode := 1;
368: ELSIF (p_start_date_active >= i.start_date_active)
369: OR (l_end_date_active >= i.start_date_active) THEN
370: inv_genealogy_pub.delete_eam_row(
371: p_api_version=>1.0,
372: p_object_id => l_gen_object_id,
373: p_start_date_active=>i.start_date_active,
374: p_end_date_active=>i.end_date_active,

Line 389: inv_genealogy_pub.insert_genealogy(

385: END IF;
386: END IF;
387:
388: if (l_pn_gen_mode = 0) then
389: inv_genealogy_pub.insert_genealogy(
390: p_api_version => 1.0,
391: p_object_type => 2,
392: p_parent_object_type => 2,
393: p_object_number => p_serial_number,

Line 410: inv_genealogy_pub.update_genealogy(

406: RAISE fnd_api.g_exc_error;
407: end if;
408:
409: elsif (l_pn_gen_mode = 1) then
410: inv_genealogy_pub.update_genealogy(
411: p_api_version => 1.0,
412: p_object_type => 2,
413: p_object_number => p_serial_number,
414: p_inventory_item_id => p_inventory_item_id,