[Home] [Help]
PACKAGE: APPS.PAY_ADHOC_UTILS_PKG
Source
1 PACKAGE PAY_ADHOC_UTILS_PKG AS
2 /* $Header: pyadcutl.pkh 120.4.12000000.1 2007/01/17 15:15:19 appldev noship $ */
3 --
4 TYPE r_record IS RECORD
5 (v_input_name pay_input_values_f.name%type,
6 v_input_value varchar2(80),
7 v_element_name pay_element_types_f.element_name%type,
8 v_classification pay_element_classifications.classification_name%type ,
9 v_recurring varchar2(1000) );
10 --
11 TYPE v_input_name_value_tab IS TABLE OF r_record INDEX BY BINARY_INTEGER;
12 --
13 g_input_name_value_tab v_input_name_value_tab;
14 --
15 g_element_entry_id NUMBER ;
16 g_effective_start_date DATE ;
17 g_effective_end_date DATE ;
18 --
19 --Variables for the Assignment Run Balance Details with GRE workbook
20 --Used in the function get_balance_valid_load_date
21 --
22 g_balance_name pay_balance_types.balance_name%TYPE;
23 g_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
24 g_balance_load_date DATE;
25 --
26 FUNCTION decode_OPM_territory ( p_territory_code varchar2,
27 p_business_group_id number ) RETURN VARCHAR2;
28
29 FUNCTION decode_currency_code ( p_currency_code varchar2 ) RETURN VARCHAR2;
30
31 FUNCTION decode_event_group ( p_event_group_id varchar2 ) RETURN VARCHAR2;
32
33 FUNCTION decode_element_type ( p_element_type_id varchar2,
34 p_effective_date date ) RETURN VARCHAR2;
35
36 FUNCTION get_bank_details ( p_external_account_id in number ) RETURN VARCHAR2;
37
38 FUNCTION get_element_link_status ( p_status varchar2,
39 p_link_start_date date,
40 p_link_end_date date,
41 p_effective_start_date date,
42 p_effective_end_date date,
43 p_effective_date date
44 ) RETURN VARCHAR2;
45
46 FUNCTION flex_concatenated (app_short_name in varchar2,
47 flex_name in varchar2,
48 flex_context_or_struct in varchar2,
49 column_name in varchar2,
50 no_of_columns in varchar2 default null,
51 flex_type in varchar2, -- 'DESCRIPTIVE' or 'KEY'
52 v1 in varchar2 default null,
53 v2 in varchar2 default null,
54 v3 in varchar2 default null,
55 v4 in varchar2 default null,
56 v5 in varchar2 default null,
57 v6 in varchar2 default null,
58 v7 in varchar2 default null,
59 v8 in varchar2 default null,
60 v9 in varchar2 default null,
61 v10 in varchar2 default null,
62 v11 in varchar2 default null,
63 v12 in varchar2 default null,
64 v13 in varchar2 default null,
65 v14 in varchar2 default null,
66 v15 in varchar2 default null,
67 v16 in varchar2 default null,
68 v17 in varchar2 default null,
69 v18 in varchar2 default null,
70 v19 in varchar2 default null,
71 v20 in varchar2 default null,
72 v21 in varchar2 default null,
73 v22 in varchar2 default null,
74 v23 in varchar2 default null,
75 v24 in varchar2 default null,
76 v25 in varchar2 default null,
77 v26 in varchar2 default null,
78 v27 in varchar2 default null,
79 v28 in varchar2 default null,
80 v29 in varchar2 default null,
81 v30 in varchar2 default null
82 ) return varchar2;
83 --
84 --
85 FUNCTION get_prev_salary(p_assignment_id NUMBER,
86 p_start_date DATE,
87 p_end_date DATE,
88 p_sal_type VARCHAR2) RETURN NUMBER ;
89 --
90 --
91 FUNCTION get_prev_sal_change_date(p_assignment_id NUMBER,
92 p_end_date DATE) RETURN DATE ;
93 --
94 --
95 FUNCTION get_multiple_sal_change_flag(p_assignment_id NUMBER,
96 p_start_date DATE,
97 p_end_date DATE) RETURN VARCHAR2 ;
98
99 --
100 --
101 FUNCTION get_input_name(p_element_entry_id number,
102 p_sequence number,
103 p_inputname_or_value varchar2,
104 p_start_date date,
105 p_end_date date,
106 p_ele_start_date date,
107 p_ele_end_date date) return varchar2;
108 --
109 --
110 FUNCTION check_assignment_in_set(p_assignmentset_name VARCHAR2,
111 p_assignment_id NUMBER,
112 p_business_group_id NUMBER,
113 p_payroll_id NUMBER)
114 RETURN VARCHAR2;
115 --
116 --
117 FUNCTION check_balance_exists(p_defined_balance_id NUMBER,
118 p_business_group_id NUMBER,
119 p_attribute_name VARCHAR2)
120 RETURN VARCHAR2 ;
121 --
122 --
123 FUNCTION get_bal_valid_load_date(p_attribute_name varchar2,
124 p_balance_name varchar2,
125 p_business_group_id number,
126 p_database_item_suffix varchar2,
127 p_defined_balance_id number DEFAULT NULL)
128 RETURN DATE ;
129 --
130 --
131 g_post_r11i VARCHAR2(1);
132 --
133 --
134 FUNCTION chk_post_r11i RETURN VARCHAR2;
135 --
136 --
137 FUNCTION get_element_name(p_element_entry_id number,
138 p_retro_run_date date,
139 p_payroll_run_date date)
140 RETURN VARCHAR2 ;
141 --
142 --
143 END PAY_ADHOC_UTILS_PKG;