[Home] [Help]
PACKAGE: APPS.HR_PAY_BASIS
Source
1 package hr_pay_basis AUTHID CURRENT_USER as
2 /* $Header: pepbasis.pkh 115.2 2002/12/09 10:23:29 pkakar ship $ */
3 /*
4 ************************************************************************
5 * *
6 *Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved*
7 ************************************************************************ */
8 /*
9 Name : hr_pay_basis (HEADER)
10
11 Description : This package declares procedures required to
12 INSERT, UPDATE and DELETE pay bases:
13
14 PER_PAY_BASES
15 Change List
16 -----------
17
18 Version Date Author ER/CR No. Description of Change
19 ------------------------------------------------------------
20 80.0 11-NOV-1993 msingh Date Created
21 80.1 20-DEC-1993 msingh G311 chk_duplicate_element and
22 chk_input_val_rate_uk take into
23 account template elements
24 spanning business groups
25 80.0 19-MAY-1994 rneale G699 Added exit
26 115.1 16-Sep-2000 mmillmor Added element_type_id output
27 115.2 09-Dec-2002 pkakar Added nocopy to parameters
28 --------------------------------------------------------------- */
29
30 --
31 --
32 --
33 FUNCTION generate_unique_id RETURN number;
34 --
35 PROCEDURE insert_row (p_pay_basis_id IN OUT NOCOPY NUMBER,
36 p_business_group_id NUMBER,
37 p_name VARCHAR2,
38 p_pay_basis VARCHAR2,
39 p_input_value_id NUMBER,
40 p_rate_id NUMBER,
41 p_rate_basis VARCHAR2);
42 --
43 PROCEDURE chk_name_uniqueness
44 (p_business_group_id IN NUMBER
45 ,p_name IN VARCHAR2
46 ,p_row_id IN VARCHAR2 DEFAULT NULL
47 );
48 --
49 --
50 PROCEDURE chk_input_val_rate_uk
51 --
52 (
53 p_input_value_id IN NUMBER
54 ,p_rate_id IN NUMBER DEFAULT NULL
55 ,p_row_id IN VARCHAR2 DEFAULT NULL
56 ,p_business_group_id IN NUMBER
57 );
58 --
59 --
60 FUNCTION chk_duplicate_element
61 (
62 p_element_type_id IN NUMBER
63 ,p_row_id IN VARCHAR2
64 ,p_business_group_id IN NUMBER
65 ) RETURN BOOLEAN ;
66 --
67 --
68 PROCEDURE chk_element_entry(
69 p_input_value_id IN NUMBER
70 );
71 --
72 --
73 Procedure chk_basis_assignment
74 ( p_pay_basis_id IN NUMBER);
75 --
76 --
77 Procedure retreive_fields ( p_session_date IN DATE,
78 p_basis_code IN VARCHAR2,
79 p_basis OUT NOCOPY VARCHAR2,
80 p_element_type_id OUT NOCOPY NUMBER,
81 p_element_name OUT NOCOPY VARCHAR2,
82 p_input_value_id IN NUMBER,
83 p_iv_name OUT NOCOPY VARCHAR2,
84 p_rate_id IN NUMBER,
85 p_rate_name OUT NOCOPY VARCHAR2,
86 p_rate_basis_code IN VARCHAR2,
87 p_rate_basis OUT NOCOPY VARCHAR2,
88 p_start_date OUT NOCOPY DATE,
89 p_end_date OUT NOCOPY DATE);
90 --
91 Procedure validate_insert (p_business_group_id NUMBER,
92 p_row_id VARCHAR2,
93 p_name VARCHAR2,
94 p_input_value_id NUMBER,
95 p_rate_id NUMBER,
96 p_pay_basis_id IN OUT NOCOPY NUMBER);
97 --
98 Procedure validate_update (p_row_id VARCHAR2,
99 p_input_value_id NUMBER,
100 p_pay_basis VARCHAR2);
101 --
102 end hr_pay_basis;