APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_EVENTS

Line 91: FROM msd_events

87: l_instance_id number;
88:
89: CURSOR auto_update_events_c1 IS
90: SELECT event_name
91: FROM msd_events
92: where auto_update_ss_flag = 'Y'
93: and event_type = 3
94: and introduction_type = 2;
95:

Line 152: /* Get auto update events list by checking auto_update_ss_flag column in MSD_EVENTS table */

148: OPEN auto_update_events_c1;
149: LOOP
150: l_event_name := NULL;
151:
152: /* Get auto update events list by checking auto_update_ss_flag column in MSD_EVENTS table */
153:
154: FETCH auto_update_events_c1 INTO l_event_name;
155: EXIT WHEN auto_update_events_c1%NOTFOUND;
156:

Line 219: /* This procedure will insert supersession new item information into MSD_EVENTS_PRODUCTS */

215:
216:
217: END delete_events_data;
218:
219: /* This procedure will insert supersession new item information into MSD_EVENTS_PRODUCTS */
220:
221: PROCEDURE insert_event_products (
222: errbuf out NOCOPY varchar2,
223: retcode out NOCOPY varchar2,

Line 531: from msd_events

527: BEGIN
528:
529: select event_id
530: into l_event_id
531: from msd_events
532: where event_name = p_event_name;
533:
534: /* Delete refresh events before updating with supersession item relationships */
535: