APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_EVT_PRODUCT_DETAILS

Line 195: delete from msd_evt_product_details

191: ) IS
192:
193: BEGIN
194:
195: delete from msd_evt_product_details
196: where event_id = p_event_id
197: and instance = p_instance_id;
198:
199: delete from msd_evt_prod_relationships

Line 365: INSERT INTO msd_evt_product_details (

361: ) IS
362:
363: BEGIN
364:
365: INSERT INTO msd_evt_product_details (
366: instance,
367: event_id,
368: seq_id,
369: detail_id,

Line 634: select msd_evt_product_details_s.nextval

630: select msd_evt_prod_relationships_s.nextval
631: into l_relation_id
632: from dual;
633:
634: select msd_evt_product_details_s.nextval
635: into l_detail_id
636: from dual;
637:
638: l_qty_mod_type := 2;

Line 659: /* Insert cannabilized items details into MSD_EVT_PRODUCT_DETAILS table */

655: l_npi_prd_relshp => l_npi_prd_relshp,
656: l_start_time => l_start_time, /*--Bug#4707819--*/
657: l_end_time =>l_end_time ); /*--Bug#4707819--*/
658:
659: /* Insert cannabilized items details into MSD_EVT_PRODUCT_DETAILS table */
660: msd_item_relationships_pkg.insert_evt_product_details(
661: errbuf => errbuf,
662: retcode => retcode,
663: p_instance_id => p_instance_id,