PACKAGE: APPS.HR_PAY_RATE_GSP_SS

Source

1 PACKAGE HR_PAY_RATE_GSP_SS AUTHID CURRENT_USER as
2 /* $Header: hrpaygsp.pkh 120.2 2008/02/21 12:28:59 gpurohit ship $ */
3 --
4 Procedure get_employee_salary
5 (P_Assignment_id   In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
6  P_Effective_Date  In Date,
7  p_ltt_salary_data    IN OUT NOCOPY  sshr_sal_prop_tab_typ
8 );
9 
10 -- get the current salary , called before updating the assignment
11 Procedure get_employee_current_salary
12 (P_Assignment_id   IN Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
13  P_Effective_Date  IN DATE,
14  p_ltt_salary_data    IN OUT NOCOPY  sshr_sal_prop_tab_typ
15 );
16 
17 procedure save_gsp_txn
18 (
19     p_item_type                   IN wf_items.item_type%type,
20     p_item_key                    IN wf_items.item_key%TYPE,
21     p_Act_id                      IN NUMBER,
22     p_ltt_salary_data             IN sshr_sal_prop_tab_typ,
23     p_review_proc_call            IN     VARCHAR2,
24     p_flow_mode                   IN OUT NOCOPY varchar2,  -- 2355929
25     p_step_id                     OUT NOCOPY NUMBER,
26     p_rptg_grp_id                 IN VARCHAR2 DEFAULT NULL,
27     p_plan_id                     IN VARCHAR2 DEFAULT NULL,
28     p_effective_date_option       IN VARCHAR2  DEFAULT NULL
29 );
30 
31 -- This method saves data in per_pay_transactions table
32 procedure create_pay_txn
33 (
34    p_item_type                   IN wf_items.item_type%type,
35    p_item_key                    IN wf_items.item_key%TYPE,
36    p_ltt_salary_data           IN sshr_sal_prop_tab_typ,
37    P_Assignment_id          In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
38    P_Effective_Date           In Date,
39    p_transaction_id            in number,
40    p_transaction_step_id   in number,
41    p_pay_basis_id             in  Per_All_Assignments_F.pay_basis_id%TYPE,
42    p_old_pay_basis_id       in  Per_All_Assignments_F.pay_basis_id%TYPE,
43    p_business_group_id    in  Per_All_Assignments_F.business_group_id%TYPE
44 );
45 
46 Procedure check_grade_ladder_exists(p_business_group_id IN NUMBER,
47                                     p_effective_date    IN DATE ,
48                                     p_grd_ldr_exists_flag out nocopy boolean);
49 
50 -- newly added grade_ladder_id attribute decode function
51 -----------------------------------------------------------------------
52 function getGradeLadderName ( p_grade_ladder_id  IN  NUMBER) return varchar2 ;
53 
54 
55     -- declare a table for storing txn steps
56     gtt_transaction_steps  hr_transaction_ss.transaction_table ;
57 
58     gtt_trans_steps  hr_transaction_ss.transaction_table ;
59 
60     gv_package_name          VARCHAR2(30) := 'HR_PAY_RATE_SS' ;
61 
62     gv_activity_name         wf_item_activity_statuses_v.activity_name%TYPE
63                             :='HR_MAINTAIN_SALARY' ;
64     gv_process_name          wf_process_activities.process_name%TYPE
65                              := 'HR_SALARY_PRC' ;
66 
67 end hr_pay_rate_gsp_ss;