APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_MONETARY_UNITS

Line 3854: type t_monetary_name_tab is table of pay_monetary_units.monetary_unit_name%TYPE index by binary_integer;

3850: procedure migrate_monetary_units is
3851: --
3852: type t_jp_monetary_name_tab is table of VARCHAR2(50) index by binary_integer;
3853:
3854: type t_monetary_name_tab is table of pay_monetary_units.monetary_unit_name%TYPE index by binary_integer;
3855:
3856: l_jp_monetary_name_tab t_jp_monetary_name_tab;
3857: l_monetary_name_tab t_monetary_name_tab;
3858:

Line 3889: UPDATE pay_monetary_units

3885: --
3886:
3887: FORALL l_tab_cnt IN 1..l_jp_monetary_name_tab.COUNT
3888:
3889: UPDATE pay_monetary_units
3890: SET monetary_unit_name = l_monetary_name_tab(l_tab_cnt)
3891: WHERE monetary_unit_name LIKE hr_jp_standard_pkg.hextochar(l_jp_monetary_name_tab(l_tab_cnt),'AL32UTF8')
3892: AND legislation_code = 'JP';
3893:

Line 5273: from pay_monetary_units pmu

5269: --
5270: cursor csr_mon_cnt
5271: is
5272: select count(pmu.monetary_unit_id)
5273: from pay_monetary_units pmu
5274: where pmu.legislation_code = 'JP'
5275: and ascii(substr(pmu.monetary_unit_name,length(pmu.monetary_unit_name),1)) <= 127
5276: and exists(
5277: select null

Line 5278: from pay_monetary_units pmu2

5274: where pmu.legislation_code = 'JP'
5275: and ascii(substr(pmu.monetary_unit_name,length(pmu.monetary_unit_name),1)) <= 127
5276: and exists(
5277: select null
5278: from pay_monetary_units pmu2
5279: where pmu2.legislation_code = 'JP'
5280: and ascii(substr(pmu2.monetary_unit_name,length(pmu2.monetary_unit_name),1)) > 127);
5281: --
5282: cursor csr_udt_cnt

Line 6471: -- from pay_monetary_units pmu

6467: -- l_dummy := null;
6468: -- --
6469: -- select pmu.monetary_unit_name
6470: -- into l_dummy
6471: -- from pay_monetary_units pmu
6472: -- where pmu.monetary_unit_name = l_mon_tbl(l_mon_ind)
6473: -- and pmu.legislation_code = 'JP';
6474: -- --
6475: -- if (g_dbg) then

Line 6508: update pay_monetary_units

6504: -- end if;
6505: --
6506: -- use bulk collect
6507: forall l_mon_ind in 1..l_mon_tbl.count
6508: update pay_monetary_units
6509: set monetary_unit_name = substrb(monetary_unit_name,1,80-4)||'_OBS'
6510: where monetary_unit_name = l_mon_tbl(l_mon_ind)
6511: and legislation_code = 'JP';
6512: --

Line 6979: FROM pay_monetary_units

6975: hr_utility.set_location(l_proc, 90);
6976:
6977: SELECT COUNT(1)
6978: INTO l_count
6979: FROM pay_monetary_units
6980: WHERE legislation_code = 'JP'
6981: AND ASCII(SUBSTR(monetary_unit_name,LENGTH(monetary_unit_name),1)) > 127;
6982:
6983: IF (l_count > 0) THEN