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_PAYWSMEE_PKG dependencies on PAY_INPUT_VALUES_F

Line 7: g_coverage constant pay_input_values_f.name%type := 'Coverage';

3: --
4: -- NOTE *** If these constants are ever updated, the changed must also
5: -- *** be applied to those constants defined in PAY_PAYWSMEE2_PKG
6: -- *** This can be done by updating the file pywsmee2.pkb
7: g_coverage constant pay_input_values_f.name%type := 'Coverage';
8: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
9: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
10:
11: lv_release_name constant varchar2(10) := fnd_release.release_name;

Line 8: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';

4: -- NOTE *** If these constants are ever updated, the changed must also
5: -- *** be applied to those constants defined in PAY_PAYWSMEE2_PKG
6: -- *** This can be done by updating the file pywsmee2.pkb
7: g_coverage constant pay_input_values_f.name%type := 'Coverage';
8: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
9: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
10:
11: lv_release_name constant varchar2(10) := fnd_release.release_name;
12:

Line 9: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';

5: -- *** be applied to those constants defined in PAY_PAYWSMEE2_PKG
6: -- *** This can be done by updating the file pywsmee2.pkb
7: g_coverage constant pay_input_values_f.name%type := 'Coverage';
8: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
9: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
10:
11: lv_release_name constant varchar2(10) := fnd_release.release_name;
12:
13: -- private package global vars for element entry type cache

Line 1178: ,name pay_input_values_f_tl.name%TYPE

1174: (
1175: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1176: ,screen_entry_value VARCHAR2(240) -- to avoid truncation of lookup meaning
1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE

Line 1179: ,uom pay_input_values_f.uom%TYPE

1175: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1176: ,screen_entry_value VARCHAR2(240) -- to avoid truncation of lookup meaning
1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE

Line 1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE

1176: ,screen_entry_value VARCHAR2(240) -- to avoid truncation of lookup meaning
1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE

Line 1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE

1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE

Line 1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE

1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE

Line 1183: ,lookup_type pay_input_values_f.lookup_type%TYPE

1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE
1187: ,max_value pay_input_values_f.max_value%TYPE

Line 1184: ,value_set_id pay_input_values_f.value_set_id%TYPE

1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE
1187: ,max_value pay_input_values_f.max_value%TYPE
1188: ,default_value VARCHAR2(242) -- to avoid truncation of lookup meaning + hot default quotes

Line 1185: ,formula_id pay_input_values_f.formula_id%TYPE

1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE
1187: ,max_value pay_input_values_f.max_value%TYPE
1188: ,default_value VARCHAR2(242) -- to avoid truncation of lookup meaning + hot default quotes
1189: );

Line 1186: ,min_value pay_input_values_f.min_value%TYPE

1182: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE
1187: ,max_value pay_input_values_f.max_value%TYPE
1188: ,default_value VARCHAR2(242) -- to avoid truncation of lookup meaning + hot default quotes
1189: );
1190: --

Line 1187: ,max_value pay_input_values_f.max_value%TYPE

1183: ,lookup_type pay_input_values_f.lookup_type%TYPE
1184: ,value_set_id pay_input_values_f.value_set_id%TYPE
1185: ,formula_id pay_input_values_f.formula_id%TYPE
1186: ,min_value pay_input_values_f.min_value%TYPE
1187: ,max_value pay_input_values_f.max_value%TYPE
1188: ,default_value VARCHAR2(242) -- to avoid truncation of lookup meaning + hot default quotes
1189: );
1190: --
1191: fetched_entry_value fetched_entry_value_rec;

Line 1236: pay_input_values_f_tl TYPE_TL,

1232: nvl (link.default_value,
1233: type.default_value)) DEFAULT_VALUE
1234: from pay_element_entry_values_f ENTRY,
1235: pay_link_input_values_f LINK,
1236: pay_input_values_f_tl TYPE_TL,
1237: pay_input_values_f TYPE
1238: where entry.element_entry_id = p_element_entry_id
1239: and link.element_link_id = p_element_link_id
1240: and link.input_value_id = entry.input_value_id

Line 1237: pay_input_values_f TYPE

1233: type.default_value)) DEFAULT_VALUE
1234: from pay_element_entry_values_f ENTRY,
1235: pay_link_input_values_f LINK,
1236: pay_input_values_f_tl TYPE_TL,
1237: pay_input_values_f TYPE
1238: where entry.element_entry_id = p_element_entry_id
1239: and link.element_link_id = p_element_link_id
1240: and link.input_value_id = entry.input_value_id
1241: and type.input_value_id = entry.input_value_id