APPS.PAYWSDYG_PKG dependencies on STANDARD

Line 1451: -- Get the name of the package according to the standard

1447: ) IS
1448: l_sql VARCHAR2(32767);
1449: BEGIN
1450: --
1451: -- Get the name of the package according to the standard
1452: p_name := get_package_name(p_event,p_table);
1453: --
1454: -- Make up the full CREATE statement then execute using the AOL routines
1455: l_sql := 'CREATE OR REPLACE PACKAGE '||

Line 1775: -- Get the trigger name in the standard format

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);
1779: update pay_dated_tables set dyn_trigger_package_name = null

Line 2502: -- trigger name and error text to the standard Oracle Apps error logging

2498:
2499:
2500: --
2501: -- Add a default exception block to catch all errors and write the
2502: -- trigger name and error text to the standard Oracle Apps error logging
2503: -- mechanism
2504: p_sql := p_sql||'EXCEPTION'||g_eol;
2505: p_sql := p_sql||' WHEN OTHERS THEN'||g_eol;
2506: p_sql := p_sql||' hr_utility.set_location('''||

Line 2552: -- Work out the trigger name according to the standard format

2548: OPEN get_trigger(p_id);
2549: FETCH get_trigger INTO l_tname,l_action;
2550: CLOSE get_trigger;
2551: --
2552: -- Work out the trigger name according to the standard format
2553: l_name := get_trigger_name(p_id,l_tname,l_action);
2554: --
2555: -- Drop the trigger (uses AOL routines)
2556: drop_trigger(l_name);

Line 3204: -- b. The after_update, after_insert, after_delete standard called by rhi,

3200: BEGIN
3201: hr_utility.set_location(' Entering: '||l_proc,10);
3202: -- The package to hold the code is created with two sections.
3203: -- a. The main trigger code, built using info from the dynamic triggers screen
3204: -- b. The after_update, after_insert, after_delete standard called by rhi,
3205: -- these act as wrappers calling (a)'s.
3206: --
3207: -- These parts are all built dynamically
3208: -- At this time, this code may have been called for the generation of a

Line 3529: -- trigger name and error text to the standard Oracle Apps error logging

3525: END IF;
3526: --
3527:
3528: -- Add a default exception block to catch all errors and write the
3529: -- trigger name and error text to the standard Oracle Apps error logging
3530: -- mechanism
3531: p_bs := p_bs||'EXCEPTION'||g_eol;
3532: p_bs := p_bs||' WHEN OTHERS THEN'||g_eol;
3533: p_bs := p_bs||' hr_utility.set_location('''||

Line 3692: -- trigger name and error text to the standard Oracle Apps error log

3688: --Reset the flag
3689: p_bs := p_bs||' pay_dyn_triggers.g_dyt_mode := l_mode;'||g_eos;
3690:
3691: -- Add a default exception block to catch all errors and write the
3692: -- trigger name and error text to the standard Oracle Apps error log
3693: p_bs := p_bs||'EXCEPTION'||g_eol;
3694: p_bs := p_bs||' WHEN OTHERS THEN'||g_eol;
3695: p_bs := p_bs||' hr_utility.set_location('''||
3696: 'AFTER_'||upper(p_dyt_info)||''',ABS(SQLCODE));'||g_eol;

Line 3798: -- trigger name and error text to the standard Oracle Apps error log

3794: l_sql := l_sql||'); -- End of call to dynamic trigger code stored in package '||g_eos;
3795: l_sql := l_sql||' pay_dyn_triggers.g_dyt_mode := l_mode;'||g_eol;
3796:
3797: -- Add a default exception block to catch all errors and write the
3798: -- trigger name and error text to the standard Oracle Apps error log
3799: l_sql := l_sql||'EXCEPTION'||g_eol;
3800: l_sql := l_sql||' WHEN OTHERS THEN'||g_eol;
3801: l_sql := l_sql||' hr_utility.set_location('''||
3802: l_dbt_name||''',ABS(SQLCODE));'||g_eol;