API-Element Entry Creation
pay_element_entry_api.create_element_entry
(p_validate => l_validate_only,
p_business_group_id => l_bus_group_id,
p_entry_type => l_entry_type,
p_assignment_id => l_assignment_id,
p_input_value_id1 => l_input_value_id1,
p_input_value_id2 => l_input_value_id2,
p_input_value_id3 => l_input_value_id3,
p_input_value_id4 => l_input_value_id4,
p_input_value_id5 => l_input_value_id5,
p_input_value_id6 => l_input_value_id6,
-- p_entry_value1 => rec_elemnt.input_value1,
-- p_entry_value2 => to_char(to_date(rec_elemnt.input_value2,'MM/DD/YYYY'),'DD-Mon-YYYY'),
--rec_elemnt.input_value2,
p_entry_value3 => to_char(to_date(rec_elemnt.input_value3,'MM/DD/YYYY'),'DD-Mon-YYYY'),
p_entry_value4 => rec_elemnt.input_value4,
p_entry_value5 => rec_elemnt.input_value5,
p_entry_value6 => rec_elemnt.input_value6,
p_element_link_id => l_element_link_id,
-- p_personal_payment_method_id => r1.pay_method_id,
p_effective_date => TRUNC
(rec_elemnt.date_from
),
--TRUNC(l_a_effective_start_date),--to_date('04/01/2013','MM/DD/YYYY'),
p_element_entry_id => l_element_entry_id,
p_object_version_number => l_object_version_number,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_create_warning => l_create_warning
);
Create The adjustment API-
pay_balance_adjustment_api.create_adjustment
(p_validate => FALSE,
p_effective_date => to_date('04/01/2013','MM/DD/YYYY'), -- change as per requirement earlier it was sysdate
--TRUNC (rec_elemnt.date_from),
p_assignment_id => l_assignment_id,
p_consolidation_set_id => l_consolidation_set_id,
p_element_link_id => l_element_link_id,
p_input_value_id1 => l_input_value_id1,
p_input_value_id2 => l_input_value_id2,
p_input_value_id3 => l_input_value_id3,
p_input_value_id4 => l_input_value_id11,
p_input_value_id5 => l_input_value_id22,
p_entry_value1 => 0,--nvl(rec_elemnt.bal_input_value1,0),--input_value1
p_entry_value2 => 0,--nvl(rec_elemnt.bal_input_value2,0),--input_value2
--p_entry_value3 => 0,--nvl(rec_elemnt.bal_input_value3,0),--input_value3
p_entry_value4 => rec_elemnt.bal_input_value1,
p_entry_value5 => rec_elemnt.bal_input_value2,--nvl(rec_elemnt.bal_input_value4,0),--input_value4
p_element_entry_id => l_element_entry_id1,
p_effective_start_date => l_effective_start_date1,
p_effective_end_date => l_effective_end_date1,
p_object_version_number => l_object_version_number1,
p_create_warning => l_create_warning1
);
Titanium Wedding Band for Men - Tombola & Spade | Tiaraculous
ReplyDeleteThe where to buy titanium trim band has an intricate design designed titanium wood stoves with microtouch titanium trim as seen on tv a stunning can titanium rings be resized design, which can be a dream for many men. thinkpad x1 titanium The entire band has a unique