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 1231: insert into PAY_INPUT_VALUES_F_TL (

1227: l_tl_name := l_name;
1228: end;
1229: end if;
1230:
1231: insert into PAY_INPUT_VALUES_F_TL (
1232: INPUT_VALUE_ID,
1233: NAME,
1234: LAST_UPDATE_DATE,
1235: LAST_UPDATED_BY,

Line 1377: update pay_input_values_f

1373: --
1374: begin
1375: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.update_row',1);
1376: --
1377: update pay_input_values_f
1378: set INPUT_VALUE_ID = p_INPUT_VALUE_ID,
1379: EFFECTIVE_START_DATE = p_EFFECTIVE_START_DATE,
1380: EFFECTIVE_END_DATE = p_EFFECTIVE_END_DATE,
1381: ELEMENT_TYPE_ID = p_ELEMENT_TYPE_ID,

Line 1430: update PAY_INPUT_VALUES_F_TL

1426: l_tl_name := P_NAME;
1427: end;
1428: end if;
1429:
1430: update PAY_INPUT_VALUES_F_TL
1431: set
1432: NAME = l_tl_name,
1433: last_update_date = sysdate,
1434: last_updated_by = c_user_id,

Line 1500: delete from pay_input_values_f

1496: --
1497: -- delete DB items
1498: hrdyndbi.delete_input_value_dict (p_input_value_id);
1499: --
1500: delete from pay_input_values_f
1501: where rowid = p_rowid;
1502: --
1503: if sql%notfound then
1504: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1521: delete from PAY_INPUT_VALUES_F_TL

1517: -- for all other date track modes the data should remain untouched
1518: --
1519: if p_delete_mode = 'ZAP' then
1520:
1521: delete from PAY_INPUT_VALUES_F_TL
1522: where INPUT_VALUE_ID = P_INPUT_VALUE_ID;
1523: --
1524: if sql%notfound then -- trap system errors during deletion
1525: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1569: from pay_input_values_f

1565: ) is
1566: --
1567: cursor csr_lock_input_value is
1568: select *
1569: from pay_input_values_f
1570: where rowid = p_rowid
1571: for update of input_value_id nowait;
1572: --
1573: v_locked_row csr_lock_input_value%rowtype;

Line 1584: from PAY_INPUT_VALUES_F_TL

1580: cursor csr_lock_input_value_tl is
1581: select
1582: NAME,
1583: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1584: from PAY_INPUT_VALUES_F_TL
1585: where INPUT_VALUE_ID = P_INPUT_VALUE_ID
1586: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1587: for update of INPUT_VALUE_ID nowait;
1588: --

Line 1666: delete from PAY_INPUT_VALUES_F_TL T

1662: ---------------------------------------------------------------------------
1663: procedure ADD_LANGUAGE
1664: is
1665: begin
1666: delete from PAY_INPUT_VALUES_F_TL T
1667: where not exists
1668: (select NULL
1669: from PAY_INPUT_VALUES_F B
1670: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID

Line 1669: from PAY_INPUT_VALUES_F B

1665: begin
1666: delete from PAY_INPUT_VALUES_F_TL T
1667: where not exists
1668: (select NULL
1669: from PAY_INPUT_VALUES_F B
1670: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1671: );
1672:
1673: update PAY_INPUT_VALUES_F_TL T set (

Line 1673: update PAY_INPUT_VALUES_F_TL T set (

1669: from PAY_INPUT_VALUES_F B
1670: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1671: );
1672:
1673: update PAY_INPUT_VALUES_F_TL T set (
1674: NAME
1675: ) = (select
1676: B.NAME
1677: from PAY_INPUT_VALUES_F_TL B

Line 1677: from PAY_INPUT_VALUES_F_TL B

1673: update PAY_INPUT_VALUES_F_TL T set (
1674: NAME
1675: ) = (select
1676: B.NAME
1677: from PAY_INPUT_VALUES_F_TL B
1678: where B.INPUT_VALUE_ID = T.INPUT_VALUE_ID
1679: and B.LANGUAGE = T.SOURCE_LANG)
1680: where (
1681: T.INPUT_VALUE_ID,

Line 1686: from PAY_INPUT_VALUES_F_TL SUBB, PAY_INPUT_VALUES_F_TL SUBT

1682: T.LANGUAGE
1683: ) in (select
1684: SUBT.INPUT_VALUE_ID,
1685: SUBT.LANGUAGE
1686: from PAY_INPUT_VALUES_F_TL SUBB, PAY_INPUT_VALUES_F_TL SUBT
1687: where SUBB.INPUT_VALUE_ID = SUBT.INPUT_VALUE_ID
1688: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1689: and (SUBB.NAME <> SUBT.NAME
1690: ));

Line 1692: insert into PAY_INPUT_VALUES_F_TL (

1688: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1689: and (SUBB.NAME <> SUBT.NAME
1690: ));
1691:
1692: insert into PAY_INPUT_VALUES_F_TL (
1693: INPUT_VALUE_ID,
1694: NAME,
1695: LAST_UPDATE_DATE,
1696: LAST_UPDATED_BY,

Line 1712: from PAY_INPUT_VALUES_F_TL B, FND_LANGUAGES L

1708: B.CREATED_BY,
1709: B.CREATION_DATE,
1710: L.LANGUAGE_CODE,
1711: B.SOURCE_LANG
1712: from PAY_INPUT_VALUES_F_TL B, FND_LANGUAGES L
1713: where L.INSTALLED_FLAG in ('I', 'B')
1714: and B.LANGUAGE = userenv('LANG')
1715: and not exists
1716: (select NULL

Line 1717: from PAY_INPUT_VALUES_F_TL T

1713: where L.INSTALLED_FLAG in ('I', 'B')
1714: and B.LANGUAGE = userenv('LANG')
1715: and not exists
1716: (select NULL
1717: from PAY_INPUT_VALUES_F_TL T
1718: where T.INPUT_VALUE_ID = B.INPUT_VALUE_ID
1719: and T.LANGUAGE = L.LANGUAGE_CODE);
1720: end ADD_LANGUAGE;
1721: -----------------------------------------------------------

Line 1735: FROM pay_element_types_f E, pay_input_values_F I

1731: is
1732: result varchar2(255);
1733: Begin
1734: SELECT count(*) INTO result
1735: FROM pay_element_types_f E, pay_input_values_F I
1736: WHERE I.ELEMENT_TYPE_ID = E.ELEMENT_TYPE_ID
1737: and nvl(E.ELEMENT_NAME,'~null~') = nvl(X_I_E_ELEMENT_NAME,'~null~')
1738: and nvl(E.LEGISLATION_CODE,'~null~') = nvl(X_I_E_LEGISLATION_CODE,'~null~')
1739: and E.EFFECTIVE_START_DATE = X_I_E_EFFECTIVE_START_DATE

Line 1784: , pay_input_values_f i

1780: --
1781: cursor csr_ipv_id is
1782: select i.input_value_id
1783: from pay_element_types_f e
1784: , pay_input_values_f i
1785: WHERE i.element_type_id = e.element_type_id
1786: and nvl(e.element_name,'~null~') = nvl(x_i_e_element_name,'~null~')
1787: and nvl(e.legislation_code,'~null~') = nvl(x_i_e_legislation_code,'~null~')
1788: and e.effective_start_date = x_i_e_effective_start_date

Line 1810: from pay_input_values_f_tl

1806: ,p_language in varchar2
1807: ) is
1808: select name
1809: , language
1810: from pay_input_values_f_tl
1811: where input_value_id = p_input_value_id
1812: and p_language in (language, source_lang)
1813: ;
1814: --

Line 1852: UPDATE pay_input_values_f_tl

1848: end if;
1849: end loop;
1850: end if;
1851:
1852: UPDATE pay_input_values_f_tl
1853: SET name = nvl(x_name,name),
1854: last_update_date = sysdate,
1855: last_updated_by = decode(x_owner,'SEED',1,0),
1856: last_update_login = 0,