DBA Data[Home] [Help]

APPS.PAYWSDYG_PKG dependencies on PAYWSDYG_PKG

Line 1: PACKAGE BODY paywsdyg_pkg AS

1: PACKAGE BODY paywsdyg_pkg AS
2: -- $Header: pydygpkg.pkb 120.7.12020000.4 2012/12/14 05:27:02 nvankadh ship $
3: --
4: -- +---------------------------------------------------------------------------+
5: -- | Global Constants |

Line 7: g_package varchar2(80) := 'paywsdyg_pkg';

3: --
4: -- +---------------------------------------------------------------------------+
5: -- | Global Constants |
6: -- +---------------------------------------------------------------------------+
7: g_package varchar2(80) := 'paywsdyg_pkg';
8: --
9: -- The end-of-line character to use in generated PL/SQL
10: --
11: g_eol CONSTANT VARCHAR2(10) := fnd_global.newline;

Line 3660: p_bs := ' if (paywsdyg_pkg.trigger_enabled('''

3656: -- Save the body details
3657: p_dyt_pkg_body_tbl(p_dyt_pkg_body_tbl.last + 1) := p_bs;
3658: p_bs := '';
3659: --
3660: p_bs := ' if (paywsdyg_pkg.trigger_enabled('''
3661: ||dyt_rec.short_name||''')) then'||g_eol;
3662: p_bs := p_bs||' '||get_dyt_proc_name(dyt_rec.short_name)||'('||g_eol;
3663:
3664: -- build up params for call to newly created procedure

Line 3878: paywsdyg_pkg.generate_trigger(

3874:
3875: hr_utility.trace(' creating dyt triggers...');
3876: --
3877: for dyt_record in csr_dyt_ids(p_table_name) loop
3878: paywsdyg_pkg.generate_trigger(
3879: dyt_record.event_id,
3880: l_name,
3881: l_ok);
3882: hr_utility.trace(' just created a dynamic trigger for id: '||dyt_record.event_id||', dyt_name: '||dyt_record.short_name||', into: '||l_name);

Line 4065: paywsdyg_pkg.convert_tab_style(

4061: end if;
4062: end if;
4063:
4064: if (l_need_rebuild_flag = 'Y') then
4065: paywsdyg_pkg.convert_tab_style(
4066: p_table_name => p_table_name,
4067: p_dyt_type => l_reqd_format);
4068: end if;
4069:

Line 4075: paywsdyg_pkg.convert_tab_style(

4071: -- which does not have hooks and thus this procedure should never be called for
4072: -- this table. If this is called for pay_element_entries_f then make the
4073: -- vals table have the same behaviour.
4074: if (p_table_name = 'PAY_ELEMENT_ENTRIES_F') then
4075: paywsdyg_pkg.convert_tab_style(
4076: p_table_name => 'PAY_ELEMENT_ENTRY_VALUES_F',
4077: p_dyt_type => l_reqd_format);
4078: end if;
4079:

Line 4504: end paywsdyg_pkg;

4500: --
4501: RETURN l_schema;
4502: END get_table_owner;
4503: --
4504: end paywsdyg_pkg;