1082: hr_utility.set_location(l_proc, 900);
1083: end element_entries_ard;
1084:
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1084:
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */
1093: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */
1093: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(
1094: p_business_group_id in number,
1095: p_legislation_code in varchar2,
1096: p_effective_date in date,
1097: p_old_ELEMENT_ENTRY_ID in NUMBER,
1109: and p_effective_date between ee.effective_start_date
1110: and ee.effective_end_date;
1111: --
1112: begin
1113: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);
1114: /* If the continuous calc is overriden then do nothing */
1115: if (g_override_cc = TRUE) then
1116: return;
1117: end if;
1117: end if;
1118: --
1119: pay_continuous_calc.event_update(p_business_group_id,
1120: p_legislation_code,
1121: 'PAY_ELEMENT_ENTRY_VALUES_F',
1122: 'SCREEN_ENTRY_VALUE',
1123: p_old_SCREEN_ENTRY_VALUE,
1124: p_new_SCREEN_ENTRY_VALUE,
1125: p_effective_date,
1152: end loop;
1153: end if;
1154: pay_continuous_calc.g_event_list.sz := 0;
1155: end;
1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1157: --
1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1159: --
1160:
1154: pay_continuous_calc.g_event_list.sz := 0;
1155: end;
1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1157: --
1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1159: --
1160:
1161: --------------------------------------------
1162: -- PER_CONTRACTS_F
11188: p_output_result out nocopy varchar2,
11189: p_date in date default null
11190: )
11191: is
11192: screen_val pay_element_entry_values_f.screen_entry_value%type;
11193: input_val pay_element_entry_values_f.input_value_id%type;
11194: --
11195: cursor do_start_chk (sk in number,
11196: ed in varchar2)
11189: p_date in date default null
11190: )
11191: is
11192: screen_val pay_element_entry_values_f.screen_entry_value%type;
11193: input_val pay_element_entry_values_f.input_value_id%type;
11194: --
11195: cursor do_start_chk (sk in number,
11196: ed in varchar2)
11197: is
11196: ed in varchar2)
11197: is
11198: select screen_entry_value,
11199: element_entry_value_id
11200: from pay_element_entry_values_f
11201: where element_entry_id = sk
11202: and ed = effective_start_date
11203: minus
11204: select screen_entry_value,
11202: and ed = effective_start_date
11203: minus
11204: select screen_entry_value,
11205: element_entry_value_id
11206: from pay_element_entry_values_f
11207: where element_entry_id = sk
11208: and ed = to_char(effective_end_date - 1);
11209: --
11210: cursor do_end_chk (sk in number,
11211: ed in varchar2)
11212: is
11213: select screen_entry_value,
11214: element_entry_value_id
11215: from pay_element_entry_values_f
11216: where element_entry_id = sk
11217: and ed = effective_end_date
11218: minus
11219: select screen_entry_value,
11217: and ed = effective_end_date
11218: minus
11219: select screen_entry_value,
11220: element_entry_value_id
11221: from pay_element_entry_values_f
11222: where element_entry_id = sk
11223: and ed = effective_start_date + 1;
11224: --
11225: begin
11319: piv.default_value iv_default_value,
11320: pliv.default_value liv_default_value,
11321: peev.screen_entry_value
11322: from pay_element_entries_f pee,
11323: pay_element_entry_values_f peev,
11324: pay_element_links_f pel,
11325: pay_link_input_values_f pliv,
11326: pay_element_types_f pet,
11327: pay_input_values_f piv
11389: piv.default_value iv_default_value,
11390: pliv.default_value liv_default_value,
11391: peev.screen_entry_value
11392: from pay_element_entries_f pee,
11393: pay_element_entry_values_f peev,
11394: pay_element_links_f pel,
11395: pay_link_input_values_f pliv,
11396: pay_element_types_f pet,
11397: pay_input_values_f piv