1 PACKAGE PAY_USER_TABLES_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyust01t.pkh 120.1 2005/07/29 05:06:06 shisriva noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Package Header Variable |
6 -- ----------------------------------------------------------------------------
7 --
8 g_dml_status boolean := FALSE; -- Global package variable
9 --
10 procedure insert_row(p_rowid in out NOCOPY varchar2,
11 p_user_table_id in out NOCOPY number,
12 p_business_group_id in number,
13 p_legislation_code in varchar2,
14 p_legislation_subgroup in varchar2,
15 p_range_or_match in varchar2,
16 p_user_key_units in varchar2,
17 p_user_table_name in varchar2,
18 p_user_row_title in varchar2 ) ;
19 --
20 procedure update_row(p_rowid in varchar2,
21 p_user_table_id in number,
22 p_business_group_id in number,
23 p_legislation_code in varchar2,
24 p_legislation_subgroup in varchar2,
25 p_range_or_match in varchar2,
26 p_user_key_units in varchar2,
27 p_user_table_name in varchar2,
28 p_user_row_title in varchar2,
29 p_base_user_table_name in varchar2 default hr_api.g_varchar2,
30 p_base_user_row_title in varchar2 default hr_api.g_varchar2) ;
31 --
32 procedure delete_row(p_rowid in varchar2,
33 p_user_table_id in number ) ;
34 --
35 procedure lock_row (p_rowid in varchar2,
36 p_user_table_id in number,
37 p_business_group_id in number,
38 p_legislation_code in varchar2,
39 p_legislation_subgroup in varchar2,
40 p_range_or_match in varchar2,
41 p_user_key_units in varchar2,
42 p_user_table_name in varchar2,
43 p_user_row_title in varchar2,
44 p_base_user_table_name in varchar2 default hr_api.g_varchar2,
45 p_base_user_row_title in varchar2 default hr_api.g_varchar2) ;
46
47 --
48 -- This procedure checks whether the user_table_name is unique within business
49 -- group and legislation_code. If the table name is ok then it succeeds silently
50 -- otherwise it raises an error.
51 --
52 procedure check_unique ( p_rowid in varchar2,
53 p_user_table_name in varchar2,
54 p_business_group_id in number,
55 p_legislation_code in varchar2,
56 p_base_user_table_name in varchar2 default hr_api.g_varchar2 ) ;
57 --
58 -- Following procedure checks whether the given user table can be
59 -- deleted. Checks PAY_USER_TABLES and PAY_USER_COLUMNS
60 --
61 procedure check_references ( p_user_table_id in number ) ;
62 --
63 -- Name
64 -- get_db_defaults
65 -- Purpose
66 -- Retrieves the db constants used as defaults by the form PAYWSDUT
67 -- The following are retrieved
68 -- The field prompts used for the rows zone
69 -- The text for the datatype of 'N' ( Number )
70 -- Arguments
71 -- See below
72 procedure get_db_defaults ( p_lower_bound in out NOCOPY varchar2,
73 p_upper_bound in out NOCOPY varchar2,
74 p_match_prompt in out NOCOPY varchar2,
75 p_number_text in out NOCOPY varchar2 ) ;
76 --
77 -- function to handle the conversion of 'Exact' values in the user tables
78 -- LOV's
79 --
80 function ut_lov_conversion ( p_value in varchar2,
81 p_uom in varchar2 ) return varchar2;
82
83 --
84 --For MLS-----------------------------------------------------------------------
85 procedure ADD_LANGUAGE;
86
87 procedure TRANSLATE_ROW (
88 X_B_USER_TABLE_NAME in VARCHAR2,
89 X_B_LEGISLATION_CODE in VARCHAR2,
90 X_USER_TABLE_NAME in VARCHAR2,
91 X_USER_ROW_TITLE in VARCHAR2,
92 X_OWNER in VARCHAR2);
93
94 procedure validate_translation(user_table_id NUMBER,
95 language VARCHAR2,
96 user_table_name VARCHAR2,
97 user_row_title VARCHAR2,
98 p_business_group_id IN NUMBER DEFAULT NULL,
99 p_legislation_code IN VARCHAR2 DEFAULT NULL);
100
101 procedure check_base_update(p_base_user_table_name in varchar2,
102 p_rowid in varchar2);
103
104 function return_dml_status return boolean;
105 --------------------------------------------------------------------------------
106 END PAY_USER_TABLES_PKG;