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 1973: FROM pay_trigger_initialisations

1969: SELECT initialisation_id,
1970: plsql_code,
1971: process_type,
1972: process_order
1973: FROM pay_trigger_initialisations
1974: WHERE event_id = cp_id
1975: ORDER BY process_order;
1976: --
1977: -- Get the name of the variable that the return value of a function or

Line 2502: FROM pay_trigger_initialisations

2498: --
2499: -- Get all the initialisations that this event uses
2500: CURSOR get_inits(cp_id IN NUMBER) IS
2501: SELECT initialisation_id
2502: FROM pay_trigger_initialisations
2503: WHERE event_id = cp_id;
2504: --
2505: -- Get all the components that this event uses
2506: CURSOR get_comps(cp_id IN NUMBER) IS

Line 2534: FROM pay_trigger_initialisations

2530: FOR l_rec IN get_inits(p_id) LOOP
2531: delete_initialisation_children(l_rec.initialisation_id);
2532: END LOOP;
2533: DELETE
2534: FROM pay_trigger_initialisations
2535: WHERE event_id = p_id;
2536: --
2537: -- Fetch all the components, delete their children and finally
2538: -- the components themselves