APPS.PAY_CC_PROCESS_UTILS dependencies on PAY_DATED_TABLES

Line 924: from pay_dated_tables pdt

920: is
921: --
922: cursor dtexists is
923: select dated_table_id, object_version_number
924: from pay_dated_tables pdt
925: where table_name = p_table_name;
926: --
927: found boolean;
928: l_dated_tables_id number;

Line 971: pay_dated_tables_api.CREATE_DATED_TABLE(

967: found := TRUE;
968: end loop;
969: --
970: if (found = FALSE) then
971: pay_dated_tables_api.CREATE_DATED_TABLE(
972: p_table_name => p_table_name
973: , p_application_id => null
974: , p_surrogate_key_name => p_surr_key_name
975: , p_start_date_name => p_eff_str_name

Line 1780: from pay_dated_tables pdt

1776: l_pkg_name := p_table_name;
1777:
1778: select pdt.dated_table_id
1779: into l_dated_table_id
1780: from pay_dated_tables pdt
1781: where pdt.table_name = p_table_name;
1782:
1783: -- >>> PHASE 1: Create the dyt_pkg name based on table_name
1784: --

Line 1809: update pay_dated_tables pdt

1805:
1806: -- >>> PHASE 2: Set the dated table to have dyt in package
1807: --
1808:
1809: update pay_dated_tables pdt
1810: set application_id = l_app_id,
1811: dyn_trigger_type = 'P',
1812: dyn_trigger_package_name = l_pkg_name,
1813: dyn_trig_pkg_generated = 'N'

Line 1874: update pay_dated_tables pdt

1870:
1871: BEGIN
1872: -- >>> PHASE 1: Set the dated table to have old-skool dyt
1873: --
1874: update pay_dated_tables pdt
1875: set dyn_trigger_type = 'T',
1876: dyn_trigger_package_name = null,
1877: dyn_trig_pkg_generated = null
1878: where pdt.table_name = p_table_name;

Line 1885: from pay_dated_tables pdt

1881: --
1882: DELETE
1883: FROM pay_trigger_parameters ptp
1884: WHERE ptp.usage_id = (select dated_table_id
1885: from pay_dated_tables pdt
1886: where pdt.table_name = p_table_name)
1887: AND ptp.usage_type in ('PI','PU','PD');
1888:
1889: END DROP_DYT_PKG_BEHAVIOUR;

Line 1912: pay_dated_tables pdt

1908: cursor get_group_events(p_cca_date date, p_sysdate date) is
1909: select pdt.table_name,ppe.surrogate_key
1910: from pay_process_events ppe,
1911: pay_event_updates peu,
1912: pay_dated_tables pdt
1913: where ppe.assignment_id is null
1914: and ppe.creation_date between p_cca_date
1915: and p_sysdate
1916: AND ppe.change_type in ('DATE_PROCESSED', 'DATE_EARNED')

Line 1927: l_table_name pay_dated_tables.table_name%type;

1923: run_counts number;
1924: l_update_cc_date boolean;
1925: new_cc_date date;
1926: old_cc_date date;
1927: l_table_name pay_dated_tables.table_name%type;
1928: l_surrogate_key pay_process_events.surrogate_key%type;
1929: l_grp_event_valid varchar2(5);
1930:
1931: begin