DBA Data[Home] [Help]

APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on INV_GENEALOGY_PUB

Line 318: inv_genealogy_pub.delete_eam_row(

314:
315: OR ((p_start_date_active <= i.end_date_active)
316: AND (l_end_date_active >= i.end_date_active)) THEN
317:
318: inv_genealogy_pub.delete_eam_row(
319: p_api_version=>1.0,
320: p_object_id => l_gen_object_id,
321: p_start_date_active=>i.start_date_active,
322: p_end_date_active=>i.end_date_active,

Line 330: inv_genealogy_pub.delete_eam_row(

326: l_pn_gen_mode := 0;
327: END IF;
328: ELSE
329: IF (p_start_date_active <= i.end_date_active) THEN
330: inv_genealogy_pub.delete_eam_row(
331: p_api_version=>1.0,
332: p_object_id => l_gen_object_id,
333: p_start_date_active=>i.start_date_active,
334: p_end_date_active=>i.end_date_active,

Line 347: inv_genealogy_pub.delete_eam_row(

343: IF l_end_date_active IS NULL THEN
344: if p_start_date_active = i.start_date_active then
345: l_pn_gen_mode := 2;
346: else
347: inv_genealogy_pub.delete_eam_row(
348: p_api_version=>1.0,
349: p_object_id => l_gen_object_id,
350: p_start_date_active=>i.start_date_active,
351: p_end_date_active=>i.end_date_active,

Line 364: inv_genealogy_pub.delete_eam_row(

360: IF (p_start_date_active = i.start_date_active) THEN
361: l_pn_gen_mode := 1;
362: ELSIF (p_start_date_active >= i.start_date_active)
363: OR (l_end_date_active >= i.start_date_active) THEN
364: inv_genealogy_pub.delete_eam_row(
365: p_api_version=>1.0,
366: p_object_id => l_gen_object_id,
367: p_start_date_active=>i.start_date_active,
368: p_end_date_active=>i.end_date_active,

Line 383: inv_genealogy_pub.insert_genealogy(

379: END IF;
380: END IF;
381:
382: if (l_pn_gen_mode = 0) then
383: inv_genealogy_pub.insert_genealogy(
384: p_api_version => 1.0,
385: p_object_type => 2,
386: p_parent_object_type => 2,
387: p_object_number => p_serial_number,

Line 404: inv_genealogy_pub.update_genealogy(

400: RAISE fnd_api.g_exc_error;
401: end if;
402:
403: elsif (l_pn_gen_mode = 1) then
404: inv_genealogy_pub.update_genealogy(
405: p_api_version => 1.0,
406: p_object_type => 2,
407: p_object_number => p_serial_number,
408: p_inventory_item_id => p_inventory_item_id,