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 1746: -- Get the trigger name in the standard format

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

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

2468:
2469:
2470: --
2471: -- Add a default exception block to catch all errors and write the
2472: -- trigger name and error text to the standard Oracle Apps error logging
2473: -- mechanism
2474: p_sql := p_sql||'EXCEPTION'||g_eol;
2475: p_sql := p_sql||' WHEN OTHERS THEN'||g_eol;
2476: p_sql := p_sql||' hr_utility.set_location('''||

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

2518: OPEN get_trigger(p_id);
2519: FETCH get_trigger INTO l_tname,l_action;
2520: CLOSE get_trigger;
2521: --
2522: -- Work out the trigger name according to the standard format
2523: l_name := get_trigger_name(p_id,l_tname,l_action);
2524: --
2525: -- Drop the trigger (uses AOL routines)
2526: drop_trigger(l_name);

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

3163: BEGIN
3164: hr_utility.set_location(' Entering: '||l_proc,10);
3165: -- The package to hold the code is created with two sections.
3166: -- a. The main trigger code, built using info from the dynamic triggers screen
3167: -- b. The after_update, after_insert, after_delete standard called by rhi,
3168: -- these act as wrappers calling (a)'s.
3169: --
3170: -- These parts are all built dynamically
3171: -- At this time, this code may have been called for the generation of a

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

3487: END IF;
3488: --
3489:
3490: -- Add a default exception block to catch all errors and write the
3491: -- trigger name and error text to the standard Oracle Apps error logging
3492: -- mechanism
3493: p_bs := p_bs||'EXCEPTION'||g_eol;
3494: p_bs := p_bs||' WHEN OTHERS THEN'||g_eol;
3495: p_bs := p_bs||' hr_utility.set_location('''||

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

3650: --Reset the flag
3651: p_bs := p_bs||' pay_dyn_triggers.g_dyt_mode := l_mode;'||g_eos;
3652:
3653: -- Add a default exception block to catch all errors and write the
3654: -- trigger name and error text to the standard Oracle Apps error log
3655: p_bs := p_bs||'EXCEPTION'||g_eol;
3656: p_bs := p_bs||' WHEN OTHERS THEN'||g_eol;
3657: p_bs := p_bs||' hr_utility.set_location('''||
3658: 'AFTER_'||upper(p_dyt_info)||''',ABS(SQLCODE));'||g_eol;

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

3756: l_sql := l_sql||'); -- End of call to dynamic trigger code stored in package '||g_eos;
3757: l_sql := l_sql||' pay_dyn_triggers.g_dyt_mode := l_mode;'||g_eol;
3758:
3759: -- Add a default exception block to catch all errors and write the
3760: -- trigger name and error text to the standard Oracle Apps error log
3761: l_sql := l_sql||'EXCEPTION'||g_eol;
3762: l_sql := l_sql||' WHEN OTHERS THEN'||g_eol;
3763: l_sql := l_sql||' hr_utility.set_location('''||
3764: l_dbt_name||''',ABS(SQLCODE));'||g_eol;