eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_INPUT_VALUES_PKG dependencies on PAY_INPUT_VALUES_F

Line 43: FROM pay_input_values_f_tl inptl,

39: cursor c_translation(p_language IN VARCHAR2,
40: p_input_name IN VARCHAR2,
41: p_input_value_id IN NUMBER) IS
42: SELECT 1
43: FROM pay_input_values_f_tl inptl,
44: pay_input_values_f inp
45: WHERE upper(inptl.name) = upper(p_input_name)
46: AND inptl.input_value_id = inp.input_value_id
47: AND inptl.language = p_language

Line 44: pay_input_values_f inp

40: p_input_name IN VARCHAR2,
41: p_input_value_id IN NUMBER) IS
42: SELECT 1
43: FROM pay_input_values_f_tl inptl,
44: pay_input_values_f inp
45: WHERE upper(inptl.name) = upper(p_input_name)
46: AND inptl.input_value_id = inp.input_value_id
47: AND inptl.language = p_language
48: AND (inp.input_value_id <> p_input_value_id OR p_input_value_id IS NULL)

Line 196: from pay_input_values_f

192: ) return boolean is
193: --
194: cursor csr_input_values is
195: select *
196: from pay_input_values_f
197: where element_type_id = p_element_type_id
198: and effective_start_date <= p_validation_end_date
199: and effective_end_date >= p_validation_start_date;
200: --

Line 495: pay_input_values_f INPUT

491: --
492: cursor csr_links is
493: select 1
494: from pay_element_links_f LINK,
495: pay_input_values_f INPUT
496: where input.input_value_id = p_input_value_id
497: and input.name = 'Pay Value'
498: and link.element_type_id = input.element_type_id
499: and link.costable_type = 'D';

Line 656: select rowid,pay_input_values_f.*

652: --
653: ) is
654: --
655: cursor csr_all_inputs_for_element is
656: select rowid,pay_input_values_f.*
657: from pay_input_values_f
658: where element_type_id = p_element_type_id
659: for update;
660: --

Line 657: from pay_input_values_f

653: ) is
654: --
655: cursor csr_all_inputs_for_element is
656: select rowid,pay_input_values_f.*
657: from pay_input_values_f
658: where element_type_id = p_element_type_id
659: for update;
660: --
661: begin

Line 697: update pay_input_values_f

693: elsif p_delete_mode = 'DELETE'
694: and p_session_date between fetched_input_value.effective_start_date
695: and fetched_input_value.effective_end_date then
696: --
697: update pay_input_values_f
698: set effective_end_date = p_session_date
699: where current of csr_all_inputs_for_element;
700: --
701: -- For delete next changes when there are no future rows for the element,

Line 725: update pay_input_values_f

721: fetched_input_value.effective_start_date || '<');
722: hr_utility.trace ('***** EED>' ||
723: fetched_input_value.effective_end_date || '<');
724: --
725: update pay_input_values_f
726: set effective_end_date = c_end_of_time
727: where --current of csr_all_inputs_for_element
728: rowid = fetched_input_value.rowid
729: and not exists

Line 731: from pay_input_values_f pipv

727: where --current of csr_all_inputs_for_element
728: rowid = fetched_input_value.rowid
729: and not exists
730: (select null
731: from pay_input_values_f pipv
732: where pipv.element_type_id = fetched_input_value.element_type_id
733: and pipv.input_value_id = fetched_input_value.input_value_id
734: and pipv.effective_start_date > fetched_input_value.effective_start_date);
735: -- end if;

Line 756: from pay_input_values_f

752: p_element_type_id number) is
753: --
754: cursor csr_input_values is
755: select *
756: from pay_input_values_f
757: where element_type_id = p_element_type_id
758: and generate_db_items_flag = 'Y'; -- Bug 6432304
759: --
760: begin

Line 877: from pay_input_values_f

873: v_no_of_input_values number(30);
874: --
875: cursor csr_count_input_values is
876: select count(distinct input_value_id)
877: from pay_input_values_f
878: where element_type_id = p_element_type_id;
879: --
880: begin
881: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NO_OF_INPUT_VALUES',1);

Line 906: from pay_input_values_f

902: p_rowid varchar2) return boolean is
903: --
904: cursor csr_dated_updates is
905: select 1
906: from pay_input_values_f
907: where input_value_id = p_input_value_id
908: and rowid <> p_rowid;
909: --
910: v_date_effectively_updated boolean := FALSE;

Line 937: l_ivid pay_input_values_f.input_value_id%type;

933: p_rowid varchar2 default null,
934: p_name varchar2,
935: p_error_if_true boolean default FALSE) return boolean is
936: --
937: l_ivid pay_input_values_f.input_value_id%type;
938: v_duplicate boolean := FALSE;
939: --
940: cursor csr_duplicate_name (p_ivid number) is
941: select 1

Line 942: from pay_input_values_f_tl iv_tl,

938: v_duplicate boolean := FALSE;
939: --
940: cursor csr_duplicate_name (p_ivid number) is
941: select 1
942: from pay_input_values_f_tl iv_tl,
943: pay_input_values_f iv
944: where iv.element_type_id = p_element_type_id
945: and (iv.rowid <> p_rowid or p_rowid is null)
946: and iv_tl.input_value_id = iv.input_value_id

Line 943: pay_input_values_f iv

939: --
940: cursor csr_duplicate_name (p_ivid number) is
941: select 1
942: from pay_input_values_f_tl iv_tl,
943: pay_input_values_f iv
944: where iv.element_type_id = p_element_type_id
945: and (iv.rowid <> p_rowid or p_rowid is null)
946: and iv_tl.input_value_id = iv.input_value_id
947: and iv_tl.language = userenv('LANG')

Line 956: from pay_input_values_f

952: --
953: if p_rowid is not null then
954: select input_value_id
955: into l_ivid
956: from pay_input_values_f
957: where rowid = p_rowid;
958: else
959: l_ivid := null;
960: end if;

Line 995: from pay_input_values_f

991: v_mandatory_in_future boolean;
992: --
993: cursor csr_mandatory_flag is
994: select 1
995: from pay_input_values_f
996: where input_value_id = p_input_value_id
997: and mandatory_flag = 'Y'
998: and effective_start_date > p_session_date;
999: --

Line 1076: from pay_input_values_f

1072: /* We need to know the value of the newly created
1073: rowid so that forms does not have to re-query */
1074: --
1075: select rowid
1076: from pay_input_values_f
1077: where input_value_id = p_input_value_id
1078: and effective_start_date = p_effective_start_date
1079: and effective_end_date = p_effective_end_date;
1080: --

Line 1087: from PAY_INPUT_VALUES_F_TL T

1083: from FND_LANGUAGES L
1084: where L.INSTALLED_FLAG in ('I', 'B')
1085: and not exists
1086: (select NULL
1087: from PAY_INPUT_VALUES_F_TL T
1088: where T.INPUT_VALUE_ID = c_input_value_id
1089: and T.LANGUAGE = L.LANGUAGE_CODE);
1090:
1091: --

Line 1127: insert into pay_input_values_f (

1123: hr_utility.raise_error;
1124:
1125: end if;
1126:
1127: insert into pay_input_values_f (
1128: --
1129: INPUT_VALUE_ID,
1130: EFFECTIVE_START_DATE,
1131: EFFECTIVE_END_DATE,

Line 1215: insert into PAY_INPUT_VALUES_F_TL (

1211: when no_data_found then
1212: l_tl_name := l_name;
1213: end;
1214:
1215: insert into PAY_INPUT_VALUES_F_TL (
1216: INPUT_VALUE_ID,
1217: NAME,
1218: LAST_UPDATE_DATE,
1219: LAST_UPDATED_BY,

Line 1240: insert into PAY_INPUT_VALUES_F_TL (

1236:
1237: end loop;
1238: else
1239:
1240: insert into PAY_INPUT_VALUES_F_TL (
1241: INPUT_VALUE_ID,
1242: NAME,
1243: LAST_UPDATE_DATE,
1244: LAST_UPDATED_BY,

Line 1264: from PAY_INPUT_VALUES_F_TL T

1260: from FND_LANGUAGES L
1261: where L.INSTALLED_FLAG in ('I', 'B')
1262: and not exists
1263: (select NULL
1264: from PAY_INPUT_VALUES_F_TL T
1265: where T.INPUT_VALUE_ID = P_INPUT_VALUE_ID
1266: and T.LANGUAGE = L.LANGUAGE_CODE);
1267:
1268: end if;

Line 1391: update pay_input_values_f

1387: --
1388: begin
1389: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.update_row',1);
1390: --
1391: update pay_input_values_f
1392: set INPUT_VALUE_ID = p_INPUT_VALUE_ID,
1393: EFFECTIVE_START_DATE = p_EFFECTIVE_START_DATE,
1394: EFFECTIVE_END_DATE = p_EFFECTIVE_END_DATE,
1395: ELEMENT_TYPE_ID = p_ELEMENT_TYPE_ID,

Line 1429: update PAY_INPUT_VALUES_F_TL

1425: --
1426: -- ************************************************************************
1427: -- update MLS table (TL)
1428: --
1429: update PAY_INPUT_VALUES_F_TL
1430: set
1431: NAME = P_NAME,
1432: last_update_date = sysdate,
1433: last_updated_by = c_user_id,

Line 1499: 'PAY_INPUT_VALUES_F' );

1495: p_session_date,
1496: p_validation_start_date,
1497: p_validation_end_date,
1498: p_delete_mode,
1499: 'PAY_INPUT_VALUES_F' );
1500: --
1501: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',2);
1502: --
1503: -- delete DB items

Line 1506: delete from pay_input_values_f

1502: --
1503: -- delete DB items
1504: hrdyndbi.delete_input_value_dict (p_input_value_id);
1505: --
1506: delete from pay_input_values_f
1507: where rowid = p_rowid;
1508: --
1509: if sql%notfound then
1510: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1527: delete from PAY_INPUT_VALUES_F_TL

1523: -- for all other date track modes the data should remain untouched
1524: --
1525: if p_delete_mode = 'ZAP' then
1526:
1527: delete from PAY_INPUT_VALUES_F_TL
1528: where INPUT_VALUE_ID = P_INPUT_VALUE_ID;
1529: --
1530: if sql%notfound then -- trap system errors during deletion
1531: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1575: from pay_input_values_f

1571: ) is
1572: --
1573: cursor csr_lock_input_value is
1574: select *
1575: from pay_input_values_f
1576: where rowid = p_rowid
1577: for update of input_value_id nowait;
1578: --
1579: v_locked_row csr_lock_input_value%rowtype;

Line 1590: from PAY_INPUT_VALUES_F_TL

1586: cursor csr_lock_input_value_tl is
1587: select
1588: NAME,
1589: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1590: from PAY_INPUT_VALUES_F_TL
1591: where INPUT_VALUE_ID = P_INPUT_VALUE_ID
1592: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1593: for update of INPUT_VALUE_ID nowait;
1594: --

Line 1672: delete from PAY_INPUT_VALUES_F_TL T

1668: ---------------------------------------------------------------------------
1669: procedure ADD_LANGUAGE
1670: is
1671: begin
1672: delete from PAY_INPUT_VALUES_F_TL T
1673: where not exists
1674: (select NULL
1675: from PAY_INPUT_VALUES_F B
1676: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID

Line 1675: from PAY_INPUT_VALUES_F B

1671: begin
1672: delete from PAY_INPUT_VALUES_F_TL T
1673: where not exists
1674: (select NULL
1675: from PAY_INPUT_VALUES_F B
1676: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1677: );
1678:
1679: update PAY_INPUT_VALUES_F_TL T set (

Line 1679: update PAY_INPUT_VALUES_F_TL T set (

1675: from PAY_INPUT_VALUES_F B
1676: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1677: );
1678:
1679: update PAY_INPUT_VALUES_F_TL T set (
1680: NAME
1681: ) = (select
1682: B.NAME
1683: from PAY_INPUT_VALUES_F_TL B

Line 1683: from PAY_INPUT_VALUES_F_TL B

1679: update PAY_INPUT_VALUES_F_TL T set (
1680: NAME
1681: ) = (select
1682: B.NAME
1683: from PAY_INPUT_VALUES_F_TL B
1684: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1685: and B.LANGUAGE = T.SOURCE_LANG)
1686: where (
1687: T.INPUT_VALUE_ID,

Line 1692: from PAY_INPUT_VALUES_F_TL SUBB, PAY_INPUT_VALUES_F_TL SUBT

1688: T.LANGUAGE
1689: ) in (select
1690: SUBT.INPUT_VALUE_ID,
1691: SUBT.LANGUAGE
1692: from PAY_INPUT_VALUES_F_TL SUBB, PAY_INPUT_VALUES_F_TL SUBT
1693: where SUBB.INPUT_VALUE_ID = SUBT.INPUT_VALUE_ID
1694: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1695: and (SUBB.NAME <> SUBT.NAME
1696: ));

Line 1698: insert into PAY_INPUT_VALUES_F_TL (

1694: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1695: and (SUBB.NAME <> SUBT.NAME
1696: ));
1697:
1698: insert into PAY_INPUT_VALUES_F_TL (
1699: INPUT_VALUE_ID,
1700: NAME,
1701: LAST_UPDATE_DATE,
1702: LAST_UPDATED_BY,

Line 1718: from PAY_INPUT_VALUES_F_TL B, FND_LANGUAGES L

1714: B.CREATED_BY,
1715: B.CREATION_DATE,
1716: L.LANGUAGE_CODE,
1717: B.SOURCE_LANG
1718: from PAY_INPUT_VALUES_F_TL B, FND_LANGUAGES L
1719: where L.INSTALLED_FLAG in ('I', 'B')
1720: and B.LANGUAGE = userenv('LANG')
1721: and not exists
1722: (select NULL

Line 1723: from PAY_INPUT_VALUES_F_TL T

1719: where L.INSTALLED_FLAG in ('I', 'B')
1720: and B.LANGUAGE = userenv('LANG')
1721: and not exists
1722: (select NULL
1723: from PAY_INPUT_VALUES_F_TL T
1724: where T.INPUT_VALUE_ID = B.INPUT_VALUE_ID
1725: and T.LANGUAGE = L.LANGUAGE_CODE);
1726: end ADD_LANGUAGE;
1727: -----------------------------------------------------------

Line 1741: FROM pay_element_types_f E, pay_input_values_F I

1737: is
1738: result varchar2(255);
1739: Begin
1740: SELECT count(*) INTO result
1741: FROM pay_element_types_f E, pay_input_values_F I
1742: WHERE I.ELEMENT_TYPE_ID = E.ELEMENT_TYPE_ID
1743: and nvl(E.ELEMENT_NAME,'~null~') = nvl(X_I_E_ELEMENT_NAME,'~null~')
1744: and nvl(E.LEGISLATION_CODE,'~null~') = nvl(X_I_E_LEGISLATION_CODE,'~null~')
1745: and E.EFFECTIVE_START_DATE = X_I_E_EFFECTIVE_START_DATE

Line 1790: , pay_input_values_f i

1786: --
1787: cursor csr_ipv_id is
1788: select i.input_value_id
1789: from pay_element_types_f e
1790: , pay_input_values_f i
1791: WHERE i.element_type_id = e.element_type_id
1792: and nvl(e.element_name,'~null~') = nvl(x_i_e_element_name,'~null~')
1793: and nvl(e.legislation_code,'~null~') = nvl(x_i_e_legislation_code,'~null~')
1794: and e.effective_start_date = x_i_e_effective_start_date

Line 1816: from pay_input_values_f_tl

1812: ,p_language in varchar2
1813: ) is
1814: select name
1815: , language
1816: from pay_input_values_f_tl
1817: where input_value_id = p_input_value_id
1818: and p_language in (language, source_lang)
1819: ;
1820: --

Line 1858: UPDATE pay_input_values_f_tl

1854: end if;
1855: end loop;
1856: end if;
1857:
1858: UPDATE pay_input_values_f_tl
1859: SET name = nvl(x_name,name),
1860: last_update_date = sysdate,
1861: last_updated_by = decode(x_owner,'SEED',1,0),
1862: last_update_login = 0,