[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
1770: p_name := l_dyt_pkg;
1771: ELSE
1772: -- type is just original 'T' Trigger mechanism so use existing code
1773: -- >> GENERATE DBMS TRIGGER
1774: hr_utility.trace(' Handle Dynamic Triggers as Individual Database Trigger Style.');
1775: -- Get the trigger name in the standard format
1776: --if weve got an old crap dyt_pkg, then dump it
1777: if (l_dyt_pkg is not null) then
1778: drop_package(l_table,l_dyt_pkg);
4283: l_rc NUMBER(15);
4284: --
4285: CURSOR csr_chk_tabname IS
4286: SELECT 1
4287: FROM dual
4288: WHERE EXISTS (
4289: SELECT 1
4290: FROM fnd_tables tab
4291: WHERE tab.table_name = p_table
4334: l_rc NUMBER(15);
4335: --
4336: CURSOR csr_chk_column IS
4337: SELECT 1
4338: FROM dual
4339: WHERE EXISTS (
4340: SELECT 1
4341: FROM fnd_columns col,fnd_tables tab
4342: WHERE tab.table_name = p_table
4391: l_rc NUMBER(15);
4392: --
4393: CURSOR csr_chk_owner IS
4394: SELECT 1
4395: FROM dual
4396: WHERE EXISTS (
4397: SELECT 1
4398: FROM fnd_tables tab,
4399: fnd_product_installations prd,