APPS.PAYWSDYG_PKG dependencies on PAY_TRIGGER_SUPPORT

Line 367: SELECT pay_trigger_support_s.NEXTVAL

363: ) RETURN NUMBER IS
364: --
365: -- Fetch the next value from the primary key generating sequence
366: CURSOR get_id IS
367: SELECT pay_trigger_support_s.NEXTVAL
368: FROM dual;
369: --
370: l_rc NUMBER;
371: --

Line 380: INSERT INTO pay_trigger_support(

376: FETCH get_id INTO l_rc;
377: CLOSE get_id;
378: --
379: -- Insert the data into the table
380: INSERT INTO pay_trigger_support(
381: support_id,
382: event_id,
383: header_code,
384: body_code

Line 1214: FROM pay_trigger_support

1210: --
1211: -- Fetch the last saved version of the code from the database table
1212: CURSOR get_old(cp_id IN NUMBER) IS
1213: SELECT header_code,body_code
1214: FROM pay_trigger_support
1215: WHERE support_id = cp_id;
1216: --
1217: l_h CLOB;
1218: l_b CLOB;

Line 1806: pay_trigger_support pts

1802: pte.table_name,
1803: pts.header_code,
1804: pts.body_code
1805: FROM pay_trigger_events pte,
1806: pay_trigger_support pts
1807: WHERE pte.event_id = pts.event_id
1808: AND pts.support_id = cp_id;
1809: --
1810: l_id NUMBER;

Line 2554: FROM pay_trigger_support

2550: --
2551: -- Drop the support package and delete it's definition
2552: drop_package(l_tname,get_package_name(p_id,l_tname));
2553: DELETE
2554: FROM pay_trigger_support
2555: WHERE event_id = p_id;
2556: --
2557: -- Don't delete the actual event, the caller (e.g. Forms) must do this
2558: END delete_event_children;