[Home] [Help]
PACKAGE: APPS.PQH_UTILITY
Source
1 Package pqh_utility AUTHID CURRENT_USER as
2 /* $Header: pqutilty.pkh 120.2.12010000.1 2008/07/28 13:16:21 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 type warnings_rec is record(message_text fnd_new_messages.message_text%type);
9
10 type warnings_tab is table of warnings_rec index by binary_integer;
11 --
12 -- Procedure Specifications
13 --
14
15 function get_shared_type_name (
16 p_shared_type_id IN number,
17 p_business_group_id IN number ) return varchar2;
18 --
19
20 procedure init_warnings_table;
21
22 procedure insert_warning(p_warnings_rec IN warnings_rec);
23
24 procedure get_next_warning(p_warnings_rec OUT nocopy warnings_rec);
25
26 procedure get_all_warnings(p_warnings_tab OUT nocopy warnings_tab,
27 p_no_warnings OUT nocopy number);
28
29 procedure get_message_level_cd
30 (p_organization_id IN number default NULL,
31 p_application_id IN number,
32 p_message_name IN varchar2,
33 p_rule_level_cd OUT nocopy varchar2);
34
35 procedure set_message (applid in number,
36 l_message_name in varchar2,
37 l_organization_id in number default NULL);
38
39 procedure set_warning_message (applid in number,
40 l_message_name in varchar2);
41
42 procedure set_message_token (l_token_name in varchar2,
43 l_token_value in varchar2);
44
45 procedure set_message_token (l_applid in number,
46 l_token_name in varchar2,
47 l_token_message in varchar2);
48
49 function get_message_type_cd return varchar2;
50
51 function get_message return varchar2;
52
53 procedure raise_error;
54 --
55 function DECODE_ASSIGNMENT_NAME(p_assignment_id in number)
56 Return VARCHAR2;
57 --
58 --
59 procedure save_point;
60 --
61 procedure roll_back;
62 --
63 -- To set the datetrack session date
64 --
65 procedure set_session_date(p_date date);
66 --
67 --
68 FUNCTION get_pos_budget_values(p_position_id in number,
69 p_period_start_dt in date,
70 p_period_end_dt in date,
71 p_unit_of_measure in varchar2)
72 RETURN number;
73 --
74 Procedure get_all_unit_desc(p_worksheet_detail_id in number,
75 p_unit1_desc out nocopy varchar2,
76 p_unit2_desc out nocopy varchar2,
77 p_unit3_desc out nocopy varchar2);
78 --
79 function get_unit_desc(p_unit_id in number) return varchar2;
80 --
81 function chk_pos_pending_txns(p_position_id in number, p_position_transaction_id in number default null) return varchar2 ;
82 --
83 function get_attribute_name(p_table_alias in varchar2, p_column_name in varchar2) return varchar2;
84 --
85 procedure change_ptx_txn_status(
86 p_position_transaction_id number,
87 p_transaction_status varchar2,
88 p_effective_date date default sysdate);
89 --
90 --
91 function position_exists(p_position_id number, p_effective_date date) return varchar2;
92 --
93 function position_start_date( p_position_id number) return date;
94 --
95 function decode_grade_rule ( p_grade_rule_id number, p_type varchar2) return varchar2;
96 --
97 --
98 -- The following procedures are used to check if valid inpu is entered in
99 -- from and to range values for a Routing / Authorization attribute.
100 --
101 --
102 g_value_set fnd_flex_value_sets%ROWTYPE;
103 --
104 Procedure chk_if_valid_value_set( p_value_set_id in number,
105 p_value_set out nocopy g_value_set%type,
106 p_error_status out nocopy number);
107 --
108 -- Given the value set id , the item returns the corresponding sql statement
109 -- its format .
110 --
111 Procedure get_valueset(p_value_set_id in number,
112 p_validation_type out nocopy varchar2,
113 p_num_format_mask out nocopy varchar2,
114 p_min_value out nocopy varchar2,
115 p_max_value out nocopy varchar2,
116 p_sql_stmt out nocopy varchar2,
117 p_error_status out nocopy number);
118
119 Procedure get_valueset_sql(p_value_set_id in number,
120 p_validation_type out nocopy varchar2,
121 p_sql_stmt out nocopy varchar2,
122 p_error_status out nocopy number);
123
124 FUNCTION get_display_value(p_value IN VARCHAR2,
125 p_value_set_id IN NUMBER)
126 RETURN VARCHAR2;
127 --
128 FUNCTION get_display_value(p_value IN VARCHAR2,
129 p_value_set_id IN NUMBER,
130 p_prnt_valset_nm IN VARCHAR2,
131 p_prnt_value IN VARCHAR2) return VARCHAR2;
132 --
133 Procedure get_org_structure_version_id(p_org_structure_id IN NUMBER,
134 p_org_structure_version_id OUT nocopy NUMBER);
135 --
136 function get_transaction_category_id(p_short_name in varchar2, p_business_group_id in number default null) return number;
137 --
138 --
139 --
140 procedure set_message_level_cd (
141 p_rule_level_cd in varchar2 );
142 --
143 --
144 function get_ptx_create_flag(p_position_transaction_id number) return varchar2;
145 --
146 --
147 function get_pos_rec_eed(p_position_id number, p_start_date date) return date;
148 --
149 --
150 function get_df_context_desc(p_df_name varchar2, p_context_code varchar2) return varchar2;
151 --
152 function get_pte_context_desc(p_pte_id number) return varchar2;
153 --
154 function get_kf_structure_name(p_kf_short_name varchar2, p_id_flex_num number) return varchar2;
155 --
156 function get_tjr_classification(p_tjr_id number) return varchar2;
157 --
158 function is_pqh_installed(p_business_group_id IN number) return boolean;
159 --
160 function GET_PATEO_PROJECT_NAME(p_project_id in number) return varchar2 ;
161 --
162 function GET_PATEO_TASK_NAME(p_task_id in number,
163 p_project_id in number) return varchar2 ;
164 --
165 function GET_PATEO_AWARD_NAME(p_award_id in number,
166 p_project_id in number,
167 p_task_id in number) return varchar2 ;
168 --
169 function GET_PATEO_EXPENDITURE_TYPE(p_project_id in number,
170 p_award_id in number,
171 p_task_id in number,
172 p_expenditure_type in varchar2) return varchar2 ;
173 --
174 function GET_PATEO_ORGANIZATION_NAME(p_organization_id in number) return varchar2 ;
175 --
176 function pqh_rule_scope(p_business_group_id in number,
177 p_organization_structure_id in number,
178 p_starting_organization_id in number,
179 p_organization_id in number) return varchar2;
180 --
181 function get_rule_set_name(p_rule_set_id in number) return varchar2;
182 --
183 function Get_number_of_days(duration number, duration_units varchar2) return number;
184 --
185 function get_org_hierarchy_name(p_organization_structure_id in number) return varchar2;
186 --
187 Procedure init_query_date;
188 Procedure set_query_date(p_effective_date in date);
189 function get_query_date return date;
190 --
191 End;