1 PACKAGE PAY_USER_ROWS_PKG AS
2 /* $Header: pyusr01t.pkh 120.1 2005/07/29 05:08:44 shisriva noship $ */
3 --
4 -- Checks that the row low range is unique within the given user table
5 --
6 procedure check_unique ( p_rowid in varchar2,
7 p_user_table_id in number,
8 p_user_row_id in number,
9 p_row_low_range_or_name in varchar2,
10 p_business_group_id in number ) ;
11
12 --
13 -- Overloaded check_unique procedure to accept p_validation_start_date and
14 -- p_validation_end_date to check the uniquness of row_low_range_or_name
15 -- only in validation range.Bug No 3734910.
16 --
17 procedure check_unique ( p_rowid in varchar2,
18 p_user_table_id in number,
19 p_user_row_id in number,
20 p_row_low_range_or_name in varchar2,
21 p_business_group_id in number ,
22 p_validation_start_date in date ,
23 p_validation_end_date in date) ;
24 --
25 -- Checks that the range defined does not contain overlapping values
26 --
27 procedure check_overlap ( p_rowid in varchar2,
28 p_user_table_id in number,
29 p_user_row_id in number,
30 p_row_low_range_or_name in varchar2,
31 p_row_high_range in varchar2,
32 p_business_group_id in number);
33
34 --
35 -- Overloaded check_overlap procedure to accept p_validation_start_date and
36 -- p_validation_end_date to check for overlapping ranges which lie in the
37 -- validation range.Bug No 3734910.
38 --
39
40 procedure check_overlap ( p_rowid in varchar2,
41 p_user_table_id in number,
42 p_user_row_id in number,
43 p_row_low_range_or_name in varchar2,
44 p_row_high_range in varchar2,
45 p_business_group_id in number,
46 p_validation_start_date in date,
47 p_validation_end_date in date);
48
49 --
50 -- Set end date if overlapping future rows exist
51 --
52 function range_end_date (p_user_table_id in number,
53 p_effective_start_date in date,
54 p_row_low_range_or_name in varchar2,
55 p_row_high_range in varchar2,
56 p_business_group_id in number)return date;
57 --
58 -- Set end date if identical future matches exist
59 --
60 function match_end_date (p_user_table_id in number,
61 p_effective_start_date in date,
62 p_row_low_range_or_name in varchar2,
63 p_business_group_id in number) return date;
64 --
65 -- Check for future rows before delete next change
66 --
67 function future_ranges_exist (p_user_table_id in number,
68 p_effective_start_date in date,
69 p_row_low_range_or_name in varchar2,
70 p_row_high_range in varchar2,
71 p_business_group_id in number)return boolean;
72
73
74 --
75 -- Check for future identical matches before delete next change
76 --
77
78
79 --
80 -- Overloaded future_ranges_exist procedure to accept p_validation_start_date and
81 -- p_validation_end_date to check for future ranges only in validation range.
82 -- Also accepted user_row_id parameter to distinguish other records from future
83 -- updates of the row for which this function is called.
84 -- Bug No 3734910.
85 --
86
87
88 function future_ranges_exist (p_user_table_id in number,
89 p_effective_start_date in date,
90 p_row_low_range_or_name in varchar2,
91 p_row_high_range in varchar2,
92 p_business_group_id in number,
93 p_user_row_id in number,
94 p_validation_start_date in date,
95 p_validation_end_date in date)return boolean;
96
97 function future_matches_exist (p_user_table_id in number,
98 p_effective_start_date in date,
99 p_row_low_range_or_name in varchar2,
100 p_business_group_id in number) return boolean;
101 --
102 -- Gets the next value for the user_row_id field from the sequence
103 -- Retrieve the next sequence number
104 --
105 procedure get_seq ( p_user_row_id in out NOCOPY number ) ;
106 --
107 -- Package check_unique and get_sequence_number calls
108 --
109 procedure pre_insert ( p_rowid in varchar2,
110 p_user_table_id in number,
111 p_row_low_range_or_name in varchar2,
112 p_user_row_id in out NOCOPY number,
113 p_business_group_id in number,
114 p_ghr_installed in varchar2 default 'N' ) ;
115 --
116 -- Check that the given delete mode is appropriate
117 --
118 procedure check_delete_row ( p_user_row_id in number,
119 p_validation_start_date in date,
120 p_dt_delete_mode in varchar2 ) ;
121 --
122 --For MLS-----------------------------------------------------------------------
123 procedure ADD_LANGUAGE;
124 procedure TRANSLATE_ROW (X_B_ROW_LOW_RANGE_OR_NAME in VARCHAR2,
125 X_B_LEGISLATION_CODE in VARCHAR2,
126 X_ROW_LOW_RANGE_OR_NAME in VARCHAR2,
127 X_OWNER in VARCHAR2);
128
129 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
130 p_legislation_code IN VARCHAR2,
131 p_user_table_id IN NUMBER);
132
133 procedure validate_translation(user_row_id NUMBER,
134 language VARCHAR2,
135 row_low_range_or_name VARCHAR2,
136 p_business_group_id IN NUMBER DEFAULT NULL,
137 p_legislation_code IN VARCHAR2 DEFAULT NULL);
138 --------------------------------------------------------------------------------
139 END PAY_USER_ROWS_PKG;