[Home] [Help]
PACKAGE: APPS.PAY_USER_COLUMNS_PKG
Source
1 PACKAGE PAY_USER_COLUMNS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyusc01t.pkh 120.1 2005/07/29 05:07:48 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_column_id in out nocopy number,
12 p_user_table_id in number,
13 p_business_group_id in number,
14 p_legislation_code in varchar2,
15 p_legislation_subgroup in varchar2,
16 p_user_column_name in varchar2,
17 p_formula_id in number ) ;
18 --
19 procedure update_row(p_rowid in varchar2,
20 p_user_column_id in number,
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_user_column_name in varchar2,
26 p_formula_id in number,
30 --
27 p_base_user_column_name in varchar2 default hr_api.g_varchar2) ;
28 --
29 procedure delete_row(p_rowid in varchar2) ;
31 procedure lock_row (p_rowid in varchar2,
32 p_user_column_id in number,
33 p_user_table_id in number,
34 p_business_group_id in number,
35 p_legislation_code in varchar2,
36 p_legislation_subgroup in varchar2,
37 p_user_column_name in varchar2,
38 p_formula_id in number,
39 p_base_user_column_name in varchar2 default hr_api.g_varchar2) ;
40 --
41 procedure check_unique ( p_rowid in varchar2,
42 p_user_column_name in varchar2,
43 p_user_table_id in number,
44 p_business_group_id in number,
45 p_base_user_column_name in varchar2 default hr_api.g_varchar2) ;
46 --
47 procedure check_unique_f ( p_rowid in varchar2,
48 p_user_column_name in varchar2,
49 p_user_table_id in number,
50 p_business_group_id in number,
51 p_legislation_code in varchar2,
52 p_base_user_column_name in varchar2 default hr_api.g_varchar2) ;
53 --
54 procedure check_delete ( p_user_column_id in number ) ;
55 --
56 ----For MLS---------------------------------------------------------------------
57 procedure ADD_LANGUAGE;
58 procedure TRANSLATE_ROW (X_B_USER_COLUMN_NAME in VARCHAR2,
59 X_B_LEGISLATION_CODE in VARCHAR2,
60 X_USER_COLUMN_NAME in VARCHAR2,
61 X_OWNER in VARCHAR2);
62 procedure check_base_update(p_base_user_column_name in varchar2,
63 p_rowid in varchar2);
64
65 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
66 p_legislation_code IN VARCHAR2,
67 p_user_table_id IN NUMBER);
68
69 procedure validate_translation(user_column_id NUMBER,
70 language VARCHAR2,
71 user_column_name VARCHAR2,
72 p_business_group_id IN NUMBER DEFAULT NULL,
73 p_legislation_code IN VARCHAR2 DEFAULT NULL);
74
75 function return_dml_status return boolean;
76
77 --------------------------------------------------------------------------------
78 END PAY_USER_COLUMNS_PKG;