[Home] [Help]
171: --
172: -- Get the next primary key value from the database sequence
173: CURSOR get_id IS
174: SELECT pay_trigger_parameters_s.NEXTVAL
175: FROM dual;
176: --
177: -- Find any existing parameter matching the name, type and usage ID
178: CURSOR get_existing(
179: cp_id IN NUMBER,
264: --
265: -- Get the next value from the primary key sequence
266: CURSOR get_id IS
267: SELECT pay_trigger_declarations_s.NEXTVAL
268: FROM dual;
269: --
270: l_rc NUMBER;
271: --
272: BEGIN
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: --
323: BEGIN
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: --
372: BEGIN
1741: p_name := l_dyt_pkg;
1742: ELSE
1743: -- type is just original 'T' Trigger mechanism so use existing code
1744: -- >> GENERATE DBMS TRIGGER
1745: hr_utility.trace(' Handle Dynamic Triggers as Individual Database Trigger Style.');
1746: -- Get the trigger name in the standard format
1747: --if weve got an old crap dyt_pkg, then dump it
1748: if (l_dyt_pkg is not null) then
1749: drop_package(l_table,l_dyt_pkg);
4245: l_rc NUMBER(15);
4246: --
4247: CURSOR csr_chk_tabname IS
4248: SELECT 1
4249: FROM dual
4250: WHERE EXISTS (
4251: SELECT 1
4252: FROM fnd_tables tab
4253: WHERE tab.table_name = p_table
4296: l_rc NUMBER(15);
4297: --
4298: CURSOR csr_chk_column IS
4299: SELECT 1
4300: FROM dual
4301: WHERE EXISTS (
4302: SELECT 1
4303: FROM fnd_columns col,fnd_tables tab
4304: WHERE tab.table_name = p_table
4353: l_rc NUMBER(15);
4354: --
4355: CURSOR csr_chk_owner IS
4356: SELECT 1
4357: FROM dual
4358: WHERE EXISTS (
4359: SELECT 1
4360: FROM fnd_tables tab,
4361: fnd_product_installations prd,