APPS.PAY_DYN_TRIGGERS dependencies on PAYWSDYG_PKG

Line 175: paywsdyg_pkg.gen_dyt_pkg_full_code(l_tab_id,l_ok);

171: IF (l_dyt_type = 'P' or l_dyt_type = 'B') THEN
172: -- dyn trigger code should be handled as package
173: -- >> GENERATE PACKAGE
174: -- generate code FOR ALL TABLE eg many dyn_triggers
175: paywsdyg_pkg.gen_dyt_pkg_full_code(l_tab_id,l_ok);
176: ELSE
177:
178: if (l_generated_flag = 'Y') then
179: -- Need to generate trigger

Line 180: l_trigger_name := paywsdyg_pkg.get_trigger_name

176: ELSE
177:
178: if (l_generated_flag = 'Y') then
179: -- Need to generate trigger
180: l_trigger_name := paywsdyg_pkg.get_trigger_name
181: (l_event_id,
182: l_table_name,
183: l_triggering_action);
184: paywsdyg_pkg.generate_code(l_event_id, l_sql);

Line 184: paywsdyg_pkg.generate_code(l_event_id, l_sql);

180: l_trigger_name := paywsdyg_pkg.get_trigger_name
181: (l_event_id,
182: l_table_name,
183: l_triggering_action);
184: paywsdyg_pkg.generate_code(l_event_id, l_sql);
185: paywsdyg_pkg.create_trigger(l_trigger_name,
186: l_table_name,
187: l_triggering_action,
188: l_sql);

Line 185: paywsdyg_pkg.create_trigger(l_trigger_name,

181: (l_event_id,
182: l_table_name,
183: l_triggering_action);
184: paywsdyg_pkg.generate_code(l_event_id, l_sql);
185: paywsdyg_pkg.create_trigger(l_trigger_name,
186: l_table_name,
187: l_triggering_action,
188: l_sql);
189: --

Line 191: paywsdyg_pkg.enable_trigger(l_trigger_name,

187: l_triggering_action,
188: l_sql);
189: --
190: if (l_enabled_flag = 'Y') then
191: paywsdyg_pkg.enable_trigger(l_trigger_name,
192: TRUE);
193: else
194: paywsdyg_pkg.enable_trigger(l_trigger_name,
195: FALSE);

Line 194: paywsdyg_pkg.enable_trigger(l_trigger_name,

190: if (l_enabled_flag = 'Y') then
191: paywsdyg_pkg.enable_trigger(l_trigger_name,
192: TRUE);
193: else
194: paywsdyg_pkg.enable_trigger(l_trigger_name,
195: FALSE);
196: end if;
197: end if;
198: END IF;

Line 239: l_trigger_name := paywsdyg_pkg.get_trigger_name

235: where short_name = p_short_name;
236: --
237: if (l_generated_flag = 'Y') then
238: -- Need to drop trigger
239: l_trigger_name := paywsdyg_pkg.get_trigger_name
240: (l_event_id,
241: p_table_name,
242: p_triggering_action);
243: paywsdyg_pkg.drop_trigger(l_trigger_name);

Line 243: paywsdyg_pkg.drop_trigger(l_trigger_name);

239: l_trigger_name := paywsdyg_pkg.get_trigger_name
240: (l_event_id,
241: p_table_name,
242: p_triggering_action);
243: paywsdyg_pkg.drop_trigger(l_trigger_name);
244: end if;
245: --
246: update pay_trigger_events
247: set