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: -- private package global vars for element entry type cache

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: -- private package global vars for element entry type cache
12: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE

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: -- private package global vars for element entry type cache
12: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE
13: INDEX BY BINARY_INTEGER;

Line 1154: ,name pay_input_values_f_tl.name%TYPE

1150: (
1151: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1152: ,screen_entry_value VARCHAR2(80) -- to avoid truncation of lookup meaning
1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE

Line 1155: ,uom pay_input_values_f.uom%TYPE

1151: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1152: ,screen_entry_value VARCHAR2(80) -- to avoid truncation of lookup meaning
1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE

Line 1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE

1152: ,screen_entry_value VARCHAR2(80) -- to avoid truncation of lookup meaning
1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE

Line 1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE

1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE

Line 1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE

1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE

Line 1159: ,lookup_type pay_input_values_f.lookup_type%TYPE

1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE
1163: ,max_value pay_input_values_f.max_value%TYPE

Line 1160: ,value_set_id pay_input_values_f.value_set_id%TYPE

1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE
1163: ,max_value pay_input_values_f.max_value%TYPE
1164: ,default_value VARCHAR2(82) -- to avoid truncation of lookup meaning + hot default quotes

Line 1161: ,formula_id pay_input_values_f.formula_id%TYPE

1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE
1163: ,max_value pay_input_values_f.max_value%TYPE
1164: ,default_value VARCHAR2(82) -- to avoid truncation of lookup meaning + hot default quotes
1165: );

Line 1162: ,min_value pay_input_values_f.min_value%TYPE

1158: ,warning_or_error pay_input_values_f.warning_or_error%TYPE
1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE
1163: ,max_value pay_input_values_f.max_value%TYPE
1164: ,default_value VARCHAR2(82) -- to avoid truncation of lookup meaning + hot default quotes
1165: );
1166: --

Line 1163: ,max_value pay_input_values_f.max_value%TYPE

1159: ,lookup_type pay_input_values_f.lookup_type%TYPE
1160: ,value_set_id pay_input_values_f.value_set_id%TYPE
1161: ,formula_id pay_input_values_f.formula_id%TYPE
1162: ,min_value pay_input_values_f.min_value%TYPE
1163: ,max_value pay_input_values_f.max_value%TYPE
1164: ,default_value VARCHAR2(82) -- to avoid truncation of lookup meaning + hot default quotes
1165: );
1166: --
1167: fetched_entry_value fetched_entry_value_rec;

Line 1212: pay_input_values_f_tl TYPE_TL,

1208: nvl (link.default_value,
1209: type.default_value)) DEFAULT_VALUE
1210: from pay_element_entry_values_f ENTRY,
1211: pay_link_input_values_f LINK,
1212: pay_input_values_f_tl TYPE_TL,
1213: pay_input_values_f TYPE
1214: where entry.element_entry_id = p_element_entry_id
1215: and link.element_link_id = p_element_link_id
1216: and link.input_value_id = entry.input_value_id

Line 1213: pay_input_values_f TYPE

1209: type.default_value)) DEFAULT_VALUE
1210: from pay_element_entry_values_f ENTRY,
1211: pay_link_input_values_f LINK,
1212: pay_input_values_f_tl TYPE_TL,
1213: pay_input_values_f TYPE
1214: where entry.element_entry_id = p_element_entry_id
1215: and link.element_link_id = p_element_link_id
1216: and link.input_value_id = entry.input_value_id
1217: and type.input_value_id = entry.input_value_id