[Home] [Help]
18: begin
19:
20: l_dtmode := PQH_GSP_POST_PROCESS.DT_Mode
21: (P_EFFECTIVE_DATE => p_session_date
22: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
23: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
24: ,P_BASE_KEY_VALUE => p_element_entry_id);
25:
26: return l_dtmode;
500: l_entry_value2 NUMBER;
501: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
502: l_payroll_value VARCHAR2(80);
503: l_next_change_date per_pay_proposals.change_date%TYPE;
504: l_Entry_End_Date pay_element_entries_f.effective_end_date%TYPE;
505: l_pay_basis per_pay_bases.pay_basis%TYPE;
506: --
507: --
508: cursor csr_get_element_detail is
529: AND asg.effective_end_date;
530: --
531: cursor get_first_date is
532: select min(effective_start_date)
533: from pay_element_entries_f
534: where element_entry_id=p_element_entry_id;
535:
536: Cursor get_last_date
537: is
535:
536: Cursor get_last_date
537: is
538: select max(effective_end_date)
539: from pay_element_entries_f
540: where element_entry_id=p_element_entry_id;
541: --
542: cursor get_existing_date is
543: select 1
540: where element_entry_id=p_element_entry_id;
541: --
542: cursor get_existing_date is
543: select 1
544: from pay_element_entries_f
545: where effective_start_date=p_change_date
546: and element_entry_id=p_element_entry_id;
547: --
548: cursor get_payroll_element(p_element_type_id NUMBER) is
561: and nvl(hrl.end_date_active,p_change_date);
562:
563: cursor Csr_Entry_End_Date is
564: select effective_end_date
565: from pay_element_entries_f
566: where effective_start_date=p_change_date
567: and element_entry_id=p_element_entry_id;
568: --
569: Cursor get_next_approved_change_date
575:
576: Cursor csr_element_entries
577: IS
578: select element_entry_id,effective_start_date,effective_end_date
579: from pay_element_entries_f
580: where effective_end_date between p_change_date and l_date_to-1
581: and element_entry_id = p_element_entry_id;
582:
583: --
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;
821: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
822: l_inv_next_sal_date_warning boolean;
823: l_proposed_salary_warning boolean;
824: l_approved_warning boolean;
825: l_payroll_warning boolean;
1279: l_proc varchar2(72) := g_package||'update_salary_proposal';
1280: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1281: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1282: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1304:
1305: cursor get_element IS
1306: select pee.element_entry_id
1307: , pyp.assignment_id
1308: from pay_element_entries_f pee
1309: , per_pay_proposals pyp
1310: where pyp.pay_proposal_id=p_pay_proposal_id
1311: and pee.assignment_id=pyp.assignment_id
1312: and NVL(l_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
1761: --
1762: l_proc varchar2(72) := g_package||'approve_salary_proposal';
1763: l_change_date per_pay_proposals.change_date%TYPE;
1764: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1765: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1766: l_inv_next_sal_date_warning boolean;
1767: l_proposed_salary_warning boolean;
1768: l_approved_warning boolean;
1769: l_payroll_warning boolean;
1776: --
1777: -- cursor get_element IS
1778: -- select pee.element_entry_id
1779: -- , pyp.assignment_id
1780: -- from pay_element_entries_f pee
1781: -- , per_pay_proposals pyp
1782: -- where pyp.pay_proposal_id=p_pay_proposal_id
1783: -- and pee.assignment_id=pyp.assignment_id
1784: -- and NVL(l_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
1788: -- Bug 1732348 Fix
1789:
1790: cursor get_element IS
1791: select pee.element_entry_id
1792: from pay_element_entries_f pee
1793: where pee.assignment_id=l_assignment_id
1794: and NVL(l_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
1795: pee.effective_start_date and pee.effective_end_date
1796: and pee.creator_type='SP';
2001: ,p_salary_warning out nocopy boolean) is
2002: --
2003: l_salary_warning boolean;
2004: l_proc varchar2(72) := g_package||'delete_salary_proposal';
2005: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2006: l_change_date date;
2007: v_zap_entry boolean;
2008: v_delete_next_change boolean;
2009: v_zap VARCHAR2(1):='N';
2022: cursor elements is
2023: select pee.element_entry_id
2024: , pro.change_date
2025: from per_pay_proposals_v2 pro
2026: , pay_element_entries_f pee
2027: where pro.pay_proposal_id=p_pay_proposal_id
2028: and pro.assignment_id=pee.assignment_id
2029: and pee.creator_type='SP'
2030: and pro.change_date between pee.effective_start_date
2032:
2033: Cursor csr_future_element_entries(p_change_date in date,p_element_entry_id in number,p_pay_proposal_id in number)
2034: IS
2035: select count(*)
2036: from pay_element_entries_f
2037: where element_entry_id = p_element_entry_id
2038: and effective_start_date > p_change_date
2039: and creator_id <> p_pay_proposal_id; --vkodedal 01-aug-2010 10062799
2040:
2109: (select 1
2110: from sys.dual
2111: where l_change_date =
2112: (select min(effective_start_date)
2113: from pay_element_entries_f
2114: where element_entry_id = l_element_entry_id));
2115: --
2116: exception
2117: when no_data_found