[Home] [Help]
5: -- Input Value Type Declaration
6: -- ********************************
7: TYPE input_vals_type IS RECORD
8: (
9: element_name pay_element_types_f.element_name%TYPE,
10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,
19: legislation_code pay_element_types_f.legislation_code%TYPE,
20: formula_id ff_formulas_f.formula_id%TYPE,
21: business_group_name per_business_groups.name%TYPE
22: );
23:
46: ele_eff_start_date pay_all_earnings_types_v.effective_start_date%TYPE,
47: ele_eff_end_date pay_all_earnings_types_v.effective_end_date%TYPE,
48: alien_supp_category VARCHAR2(4000),
49: bg_id pay_all_earnings_types_v.business_group_id%TYPE,
50: termination_rule pay_element_types_f.post_termination_rule%TYPE,
51: org_ele_name Pay_all_earnings_types_v.element_name%TYPE,
52: inp_val_low_range NUMBER,
53: inp_val_high_range NUMBER
54: );
81: pay_all_deduction_types_v.aftertax_component_flag%TYPE,
82: ele_eff_start_date pay_all_earnings_types_v.effective_start_date%TYPE,
83: ele_eff_end_date pay_all_earnings_types_v.effective_end_date%TYPE,
84: catchup_processing VARCHAR2(150),
85: termination_rule pay_element_types_f.post_termination_rule%TYPE,
86: srs_plan_type VARCHAR2(150),
87: srs_buy_back VARCHAR2(150),
88: bg_id pay_all_earnings_types_v.business_group_id%TYPE,
89: org_ele_name Pay_all_earnings_types_v.element_name%TYPE,
1116: CURSOR c_ele_exists(p_ele_name IN VARCHAR2,
1117: p_bg_id NUMBER)
1118: IS
1119: SELECT element_name ele_name
1120: FROM pay_element_types_f
1121: WHERE element_name=p_ele_name
1122: AND business_group_id=p_bg_id;
1123:
1124: l_new_name VARCHAR2(80);
1878: and business_group_id = p_business_group_id
1879: and NVL(pcv_information3,'NULL') = NVL(p_pay_basis,'NULL');
1880:
1881: ----**********************************************************************
1882: -- Check if new name already exists under PAY_ELEMENT_TYPES_F
1883: ----**********************************************************************
1884: CURSOR c_ele_exists_pet
1885: (
1886: p_business_group_id NUMBER,
1888: )
1889: IS
1890: SELECT element_type_id ele_type_id,
1891: effective_start_date eff_date
1892: FROM pay_element_types_f
1893: WHERE business_group_id = p_business_group_id
1894: AND element_name = p_new_ele_name;
1895:
1896: l_old_ele_type_id NUMBER;
1931: CURSOR c_new_ele_name_mapped(p_bg_id IN NUMBER,
1932: p_ele_type_id IN NUMBER)
1933: IS
1934: SELECT element_name ele_name
1935: FROM pay_element_types_f
1936: WHERE element_type_id = p_ele_type_id
1937: AND business_group_id = p_bg_id;
1938:
1939: l_map_old_ele VARCHAR2(80);
2295: END IF; */
2296:
2297: hr_utility.trace('Inside Agency Element type id exists');
2298: --******************************************************************
2299: -- If the new Element picked already exists under pay_element_types_f
2300: -- under current Biz Grp and as on the passed effective date
2301: --******************************************************************
2302: l_DML := 'Updated';
2303: hr_utility.set_location('Element being updated',40);
2359: THEN
2360: --
2361: -- *****************************************************************
2362: -- If old element does not exist in PCV then insert a new row in PCV
2363: -- Pick the ele_type_id,effective_start_date from pay_element_types_f
2364: -- *****************************************************************
2365: l_DML := 'Inserted';
2366: hr_utility.set_location('Inside Federal Element type id NULL',20);
2367: hr_utility.set_location('Element being Inserted',30);