[Home] [Help]
PACKAGE: APPS.PAY_IP_UTILITY
Source
1 PACKAGE pay_ip_utility AUTHID CURRENT_USER as
2 /* $Header: payiputil.pkh 120.7.12020000.7 2013/03/18 12:20:34 rmugloo noship $ */
3
4
5 /**********************************************************************
6 ** Name : get_ip_installation
7 ** Purpose : This function returns whether the IP has been installed
8 ** Arguments : IN Parameters
9 ** p_business_grp_id -> Business Group ID
10 ** Notes :
11 **********************************************************************/
12
13 /* Global Variables */
14 g_net_pay_action_type pay_payroll_actions.action_type%TYPE;
15
16 FUNCTION get_ip_installation (p_business_grp_id IN NUMBER)
17 RETURN VARCHAR2;
18
19 FUNCTION get_ip_installation (p_legislation_code IN VARCHAR2)
20 RETURN VARCHAR2;
21
22 PROCEDURE create_ele_info_dff_ctxt(p_legislation_code IN VARCHAR2
23 ,p_dff_name IN VARCHAR2
24 ,p_appl_short_name IN VARCHAR2
25 , p_list_of_ctxt_string IN VARCHAR2);
26
27 PROCEDURE update_flex_col_usages_tl(P_SOURCE_CONTEXT_CODE IN VARCHAR2
28 ,P_DEST_CONTEXT_CODE IN VARCHAR2
29 ,P_DFF_NAME IN VARCHAR2);
30
31 PROCEDURE create_org_info_type
32 (p_ORG_INFORMATION_TYPE VARCHAR2
33 ,p_DESCRIPTION VARCHAR2
34 ,p_DESTINATION VARCHAR2
35 ,p_DISP_ORG_INFORMATION_TYPE VARCHAR2
36 ,p_LEGISLATION_CODE VARCHAR2
37 ,p_APPLICATION_SHORT_NAME VARCHAR2
38 ,p_NAVIGATION_METHOD VARCHAR2);
39
40
41
42 PROCEDURE create_org_info_type_by_class
43 (p_ORG_CLASSIFICATION VARCHAR2
44 ,p_ORG_INFORMATION_TYPE VARCHAR2
45 ,p_MANDATORY_FLAG VARCHAR2);
46
47 FUNCTION get_balance_name (p_balance_type_id IN NUMBER)
48 RETURN VARCHAR2;
49
50 -- ---------------------------------------------------------------------
51 -- Deleting organization info types by class
52 -- ---------------------------------------------------------------------
53
54 PROCEDURE delete_org_info_type_by_class
55 (p_ORG_CLASSIFICATION VARCHAR2
56 ,p_ORG_INFORMATION_TYPE VARCHAR2);
57
58 -- ---------------------------------------------------------------------
59 -- Deleting organization info type.
60 -- ---------------------------------------------------------------------
61
62 PROCEDURE delete_org_info_type
63 (p_ORG_INFORMATION_TYPE VARCHAR2);
64
65 PROCEDURE create_pqp_rep_dim
66 (p_legislation_code IN VARCHAR2,
67 p_install_tax_unit IN VARCHAR2,
68 p_tax_year IN VARCHAR2);
69
70 FUNCTION IS_release_122_plus return BOOLEAN;
71
72 FUNCTION get_check_number(p_pre_payment_assact in number
73 ,p_pre_payment_id in number)
74 RETURN varchar2;
75
76 /**********************************************************************
77 ** Name : insert_fnd_lookup_val
78 ** Purpose : This Procedure creates the lookup values for a look up
79 ** type
80 **********************************************************************/
81 PROCEDURE insert_fnd_lookup_val
82 ( p_lookup_type IN VARCHAR2
83 , p_lookup_code IN VARCHAR2
84 , p_territory_code IN VARCHAR2
85 , p_enabled_flag IN VARCHAR2
86 , p_meaning IN VARCHAR2
87 , p_description IN VARCHAR2
88 , p_start_date_active IN DATE
89 , p_end_date_active IN DATE
90 );
91
92 /**********************************************************************
93 ** Name : insert_bal_lookup_val
94 ** Purpose : This Procedure creates the lookup values required
95 ** for displaying the Balances window
96 **********************************************************************/
97 PROCEDURE insert_bal_lookup_val (p_legislation_code VARCHAR2);
98
99 /**********************************************************************
100 ** Name : create_fnd_menu_entry
101 ** Purpose : This procedure creates an entry(function/submenu)
102 ** into the given fnd Menu.
103 **********************************************************************/
104
105 PROCEDURE create_fnd_menu_entry
106 (p_mode IN VARCHAR2
107 ,p_menu_name IN VARCHAR2
108 ,p_sub_menu_name IN VARCHAR2
109 ,p_function_name IN VARCHAR2
110 ,p_grant_flag IN VARCHAR2
111 ,p_prompt IN VARCHAR2
112 ,p_description IN VARCHAR2
113 ,p_owner IN VARCHAR2);
114
115 PROCEDURE compile_flex_field(p_mode IN VARCHAR2,
116 p_application_short_name IN VARCHAR2 DEFAULT NULL,
117 p_id_flex_code IN VARCHAR2 DEFAULT NULL,
118 p_id_flex_structure_code IN VARCHAR2 DEFAULT NULL,
119 p_descriptive_flexfield_name IN VARCHAR2 DEFAULT NULL,
120 p_flex_value_set_name IN VARCHAR2 DEFAULT NULL);
121
122 /**********************************************************************
123 ** Name : insert_all_ownerships
124 ** Purpose : This Procedure inserts ownerships in table
125 ** hr_application_ownerships for data related to 'ZZ'
126 ** legislation
127 **********************************************************************/
128 PROCEDURE insert_all_ownerships;
129
130 /**********************************************************************
131 ** Name : check_patch_exists
132 ** Purpose : This function checks for a given patch
133 ** in table pay_patch_status
134 **********************************************************************/
135 FUNCTION check_patch_exists
136 (p_patch_name IN VARCHAR2
137 ,p_patch_status IN VARCHAR2
138 ,p_appl_release IN VARCHAR2
139 ,p_leg_code IN VARCHAR2
140 )
141 RETURN BOOLEAN;
142
143 /**********************************************************************
144 ** Name : insert_patch_statuts
145 ** Purpose : This procedure inserts a given patch
146 ** in table pay_patch_status
147 **********************************************************************/
148 PROCEDURE insert_patch_status
149 (p_patch_number IN VARCHAR2
150 ,p_patch_name IN VARCHAR2
151 ,p_patch_desc IN VARCHAR2
152 ,p_patch_status IN VARCHAR2
153 ,p_appl_release IN VARCHAR2
154 ,p_leg_code IN VARCHAR2
155 );
156
157 /**********************************************************************
158 ** Name : compile_formulas
159 ** Purpose : This procedure submits request for bulk
160 ** compiling the fromulas
161 **********************************************************************/
162 PROCEDURE compile_formulas
163 (p_user_id IN NUMBER
164 ,p_resp_id IN NUMBER
165 ,p_resp_appl_id IN NUMBER
166 );
167
168
169 /**********************************************************************
170 ** Name : check_run_balance_enabled
171 ** Purpose : This function checks whether rub balances
172 ** are enabled or not
173 **********************************************************************/
174 FUNCTION check_run_balance_enabled
175 RETURN BOOLEAN;
176
177 END pay_ip_utility;