[Home] [Help]
16: g_element_entry_id number;
17: g_input_value_index number;
18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;
19: g_screen_entry_value_tbl screen_entry_value_tbl;
20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;
21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;
22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;
23: type display_sequence_tbl is table of pay_input_values_f.display_sequence%type index by binary_integer;
24: type lookup_type_tbl is table of pay_input_values_f.lookup_type%type index by binary_integer;
17: g_input_value_index number;
18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;
19: g_screen_entry_value_tbl screen_entry_value_tbl;
20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;
21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;
22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;
23: type display_sequence_tbl is table of pay_input_values_f.display_sequence%type index by binary_integer;
24: type lookup_type_tbl is table of pay_input_values_f.lookup_type%type index by binary_integer;
25: type mandatory_flag_tbl is table of pay_input_values_f.mandatory_flag%type index by binary_integer;
326: --
327: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
328: --
329: l_entry_type pay_element_entries_f.entry_type%TYPE;
330: l_processing_type pay_element_types_f.processing_type%TYPE;
331: --
332: cursor C_Sel1 is
333: select pee.entry_type,
334: pet.processing_type
331: --
332: cursor C_Sel1 is
333: select pee.entry_type,
334: pet.processing_type
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee
338: where pee.element_entry_id = p_base_key_value
339: and p_effective_date
402: --
403: l_parent_key_value1 number;
404: l_parent_key_value2 number;
405: l_entry_type pay_element_entries_f.entry_type%TYPE;
406: l_processing_type pay_element_types_f.processing_type%TYPE;
407: --
408: cursor C_Sel1 is
409: select pee.assignment_id,
410: pee.element_link_id,
409: select pee.assignment_id,
410: pee.element_link_id,
411: pee.entry_type,
412: pet.processing_type
413: from pay_element_types_f pet,
414: pay_element_links_f pel,
415: pay_element_entries_f pee
416: where pee.element_entry_id = p_base_key_value
417: and p_effective_date
1013: decode(piv.hot_default_flag,
1014: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
1015: pliv.warning_or_error) WARNING_OR_ERROR,
1016: pet.input_currency_code
1017: from pay_element_types_f pet,
1018: pay_input_values_f_tl pivtl,
1019: pay_input_values_f piv,
1020: pay_link_input_values_f pliv
1021: where pliv.element_link_id = p_element_link_id
1251: --
1252: cursor csr_element_type_id
1253: is
1254: select pet.element_type_id
1255: from pay_element_types_f pet
1256: where pet.element_name = p_element_name
1257: and l_effective_date
1258: between pet.effective_start_date and pet.effective_end_date
1259: and nvl(pet.legislation_code,g_legislation_code) = g_legislation_code
1853: null,
1854: decode(piv.hot_default_flag,
1855: 'Y',nvl(pliv.default_value,piv.default_value),
1856: pliv.default_value)) b_default_value
1857: from pay_element_types_f pet,
1858: pay_input_values_f piv,
1859: pay_link_input_values_f pliv
1860: where pliv.element_link_id = p_element_link_id
1861: and p_effective_date
2053: hr_general.decode_lookup(piv.lookup_type,
2054: nvl(l_screen_value,decode(piv.hot_default_flag,
2055: 'Y',nvl(pliv.default_value,piv.default_value),
2056: pliv.default_value)))),piv.uom,pet.output_currency_code),1,60) entry_value
2057: from pay_element_types_f pet,
2058: pay_input_values_f piv,
2059: pay_link_input_values_f pliv
2060: where pliv.element_link_id = p_el_element_link_id
2061: and pliv.input_value_id = l_input_value_id
2101: p_business_group_id hr_assignment_sets.business_group_id%type,
2102: p_session_date date)
2103: is
2104: i number;
2105: p_element_type_id pay_element_types.element_type_id%type;
2106: p_assignment_id pay_assignment_actions.assignment_id%type;
2107: l_element_entry_id number;
2108: l_effective_start_date date;
2109: l_effective_end_date date;
2110: l_object_version_number number;
2111: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,
2112: p_element_set_id pay_element_type_rules.element_set_id%type,
2113: p_run_type_id pay_run_types.run_type_id%type,
2114: p_business_group_id pay_element_types.business_group_id%type,
2115: p_session_date date)
2116: is
2117: select petr.element_type_id
2118: from pay_element_type_rules petr
2132: and nvl(hr_entry_api.get_link(p_assignment_id,petr.element_type_id,p_session_date),0) <> 0
2133: and petr.element_type_id not in(
2134: select distinct pet.element_type_id
2135: from pay_element_entries_f pee,
2136: pay_element_types_f pet,
2137: pay_element_links_f pel
2138: where assignment_id = p_assignment_id
2139: and pet.element_type_id = pel.element_type_id
2140: and pee.element_link_id = pel.element_link_id
2175: p_business_group_id hr_assignment_sets.business_group_id%type,
2176: p_payroll_id hr_assignment_sets.payroll_id%type,
2177: p_session_date date)
2178: is
2179: p_element_type_id pay_element_types.element_type_id%type;
2180: l_element_entry_id number;
2181: l_effective_start_date date;
2182: l_effective_end_date date;
2183: l_object_version_number number;
2194: and hasa.include_or_exclude = 'I';
2195: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,
2196: p_element_set_id pay_element_type_rules.element_set_id%type,
2197: p_run_type_id pay_run_types.run_type_id%type,
2198: p_business_group_id pay_element_types.business_group_id%type,
2199: p_session_date date)
2200: is
2201: select petr.element_type_id
2202: from pay_element_type_rules petr
2216: and nvl(hr_entry_api.get_link(p_assignment_id,petr.element_type_id,p_session_date),0) <> 0
2217: and petr.element_type_id not in(
2218: select distinct pet.element_type_id
2219: from pay_element_entries_f pee,
2220: pay_element_types_f pet,
2221: pay_element_links_f pel
2222: where assignment_id = p_assignment_id
2223: and pet.element_type_id = pel.element_type_id
2224: and pee.element_link_id = pel.element_link_id
2263: -- are passed from the Separation Pay form.
2264: --
2265: --------------------------------------------------------------------------------
2266: procedure create_entry_for_assignment(p_assignment_id in pay_assignment_actions.assignment_id%type,
2267: p_element_type_id in pay_element_types.element_type_id%type,
2268: p_business_group_id in pay_element_types.business_group_id%type,
2269: p_entry_type in pay_element_entries_f.entry_type%type,
2270: p_effective_date in date,
2271: p_effective_start_date in out NOCOPY date,
2264: --
2265: --------------------------------------------------------------------------------
2266: procedure create_entry_for_assignment(p_assignment_id in pay_assignment_actions.assignment_id%type,
2267: p_element_type_id in pay_element_types.element_type_id%type,
2268: p_business_group_id in pay_element_types.business_group_id%type,
2269: p_entry_type in pay_element_entries_f.entry_type%type,
2270: p_effective_date in date,
2271: p_effective_start_date in out NOCOPY date,
2272: p_effective_end_date in out NOCOPY date,