APPS.PAYWSDYG_PKG dependencies on PAY_TRIGGER_INITIALISATIONS

Line 318: SELECT pay_trigger_initialisations_s.NEXTVAL

314: ) RETURN NUMBER IS
315: --
316: -- Fetch the next primary key value from the database sequence
317: CURSOR get_id IS
318: SELECT pay_trigger_initialisations_s.NEXTVAL
319: FROM dual;
320: --
321: l_rc NUMBER;
322: --

Line 331: INSERT INTO pay_trigger_initialisations(

327: FETCH get_id INTO l_rc;
328: CLOSE get_id;
329: --
330: -- Insert the new row
331: INSERT INTO pay_trigger_initialisations(
332: initialisation_id,
333: event_id,
334: process_order,
335: plsql_code,

Line 1121: FROM pay_trigger_initialisations

1117: CURSOR get_inits(cp_id IN NUMBER,cp_comp IN NUMBER) IS
1118: SELECT initialisation_id,
1119: plsql_code,
1120: process_type
1121: FROM pay_trigger_initialisations
1122: WHERE (initialisation_id = cp_comp OR cp_comp IS NULL)
1123: AND (event_id = cp_id OR cp_id IS NULL);
1124: --
1125: -- Get the component we asked for, or all of them if the ID's NULL

Line 2002: FROM pay_trigger_initialisations

1998: SELECT initialisation_id,
1999: plsql_code,
2000: process_type,
2001: process_order
2002: FROM pay_trigger_initialisations
2003: WHERE event_id = cp_id
2004: ORDER BY process_order;
2005: --
2006: -- Get the name of the variable that the return value of a function or

Line 2532: FROM pay_trigger_initialisations

2528: --
2529: -- Get all the initialisations that this event uses
2530: CURSOR get_inits(cp_id IN NUMBER) IS
2531: SELECT initialisation_id
2532: FROM pay_trigger_initialisations
2533: WHERE event_id = cp_id;
2534: --
2535: -- Get all the components that this event uses
2536: CURSOR get_comps(cp_id IN NUMBER) IS

Line 2564: FROM pay_trigger_initialisations

2560: FOR l_rec IN get_inits(p_id) LOOP
2561: delete_initialisation_children(l_rec.initialisation_id);
2562: END LOOP;
2563: DELETE
2564: FROM pay_trigger_initialisations
2565: WHERE event_id = p_id;
2566: --
2567: -- Fetch all the components, delete their children and finally
2568: -- the components themselves