DBA Data[Home] [Help]

APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_EVENT_PRODUCTS

Line 203: delete from msd_event_products

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
204: where event_id = p_event_id
205: and instance = p_instance_id;
206:
207: -- commit;

Line 236: INSERT INTO msd_event_products (

232: ) IS
233:
234: BEGIN
235:
236: INSERT INTO msd_event_products (
237: instance,
238: event_id,
239: seq_id,
240: product_lvl_id,

Line 555: SELECT msd_event_products_s.nextval

551: EXIT WHEN new_item_c1%NOTFOUND;
552:
553: l_seq_id := null;
554:
555: SELECT msd_event_products_s.nextval
556: INTO l_seq_id
557: FROM dual;
558:
559: /* Insert new items into MSD_EVENT_PRODUCTS table */

Line 559: /* Insert new items into MSD_EVENT_PRODUCTS table */

555: SELECT msd_event_products_s.nextval
556: INTO l_seq_id
557: FROM dual;
558:
559: /* Insert new items into MSD_EVENT_PRODUCTS table */
560:
561: msd_item_relationships_pkg.insert_event_products(
562: errbuf => errbuf,
563: retcode => retcode,