APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_EVT_PROD_RELATIONSHIPS

Line 199: delete from msd_evt_prod_relationships

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
200: where event_id = p_event_id
201: and instance = p_instance_id;
202:
203: delete from msd_event_products

Line 275: /* This procedure will insert supersession related item's relation information into msd_evt_prod_relationships table */

271: rollback;
272:
273: END insert_event_products;
274:
275: /* This procedure will insert supersession related item's relation information into msd_evt_prod_relationships table */
276:
277: PROCEDURE insert_evt_prod_relationships (
278: errbuf out NOCOPY varchar2,
279: retcode out NOCOPY varchar2,

Line 296: INSERT INTO msd_evt_prod_relationships (

292: ) IS
293:
294: BEGIN
295:
296: INSERT INTO msd_evt_prod_relationships (
297: instance,
298: event_id,
299: seq_id,
300: relation_id,

Line 603: select msd_evt_prod_relationships_s.nextval

599: IF l_count <> 0 THEN
600:
601: l_relation_id := NULL;
602:
603: select msd_evt_prod_relationships_s.nextval
604: into l_relation_id
605: from dual;
606:
607: l_qty_mod_type := 2;

Line 611: /* Insert base items into MSD_EVT_PROD_RELATIONSHIPS table */

607: l_qty_mod_type := 2;
608: l_qty_mod_factor := 0;
609: l_npi_prd_relshp := 1;
610:
611: /* Insert base items into MSD_EVT_PROD_RELATIONSHIPS table */
612: msd_item_relationships_pkg.insert_evt_prod_relationships(
613: errbuf => errbuf,
614: retcode => retcode,
615: p_instance_id => p_instance_id,

Line 630: select msd_evt_prod_relationships_s.nextval

626: l_end_time=>null ); /*--Bug#4707819--*/
627:
628: l_relation_id := NULL;
629:
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

Line 642: /* Insert cannabilized items into MSD_EVT_PROD_RELATIONSHIPS table */

638: l_qty_mod_type := 2;
639: l_qty_mod_factor := 100;
640: l_npi_prd_relshp := 2;
641:
642: /* Insert cannabilized items into MSD_EVT_PROD_RELATIONSHIPS table */
643: msd_item_relationships_pkg.insert_evt_prod_relationships(
644: errbuf => errbuf,
645: retcode => retcode,
646: p_instance_id => p_instance_id,