[Home] [Help]
75:
76: CURSOR get_element_class_csr IS
77: SELECT distinct classification_id, legislation_code, classification_name
78: FROM hr_s_element_classifications pec
79: ,hr_s_application_ownerships ao
80: ,fnd_product_installations b
81: ,fnd_application c
82: WHERE nvl(legislation_code,'X') = 'ZZ'
83: AND ao.key_name = 'CLASSIFICATION_ID'
90:
91: CURSOR get_balance_type_csr IS
92: SELECT distinct balance_type_id, currency_code, balance_name
93: FROM hr_s_balance_types pbt
94: ,hr_s_application_ownerships ao
95: ,fnd_product_installations b
96: ,fnd_application c
97: WHERE pbt.legislation_code = 'ZZ'
98: AND ao.key_name = 'BALANCE_TYPE_ID'
106: CURSOR get_defined_balances_csr IS
107: SELECT distinct defined_balance_id, pbt.balance_name bname
108: FROM hr_s_defined_balances pdb
109: ,hr_s_balance_types pbt
110: ,hr_s_application_ownerships ao
111: ,fnd_product_installations b
112: ,fnd_application c
113: WHERE pdb.legislation_code ='ZZ'
114: AND ao.key_name = 'DEFINED_BALANCE_ID'
121: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
122:
123: CURSOR get_balance_dimensions_csr IS
124: SELECT distinct balance_dimension_id, dimension_name
125: FROM hr_s_application_ownerships ao
126: ,hr_s_balance_dimensions pbd
127: ,fnd_product_installations b
128: ,fnd_application c
129: WHERE pbd.legislation_code ='ZZ'
137:
138:
139: CURSOR get_routes_csr IS
140: SELECT distinct fr.route_id, route_name
141: FROM hr_s_application_ownerships ao
142: ,hr_s_routes fr
143: ,hr_s_balance_dimensions pbd
144: ,fnd_product_installations b
145: ,fnd_application c
242: END write_out;
243:
244:
245: -- ---------------------------------------------------------------------
246: -- This procedure inserts the Ownership in hr_s_application_ownerships
247: -- table. It takes the required values from where it is being called.
248: -- ---------------------------------------------------------------------
249: PROCEDURE insert_ownership(p_key_name IN VARCHAR2,
250: p_product_name IN VARCHAR2,
253:
254: null;
255:
256: /*hr_utility.set_location('--pay_ip_startup_util.insert_ownership',10);
257: INSERT INTO hr_s_application_ownerships
258: ( key_name
259: ,product_name
260: ,key_value)
261: SELECT
263: ,p_product_name
264: ,p_key_value
265: FROM dual
266: WHERE NOT EXISTS (SELECT NULL
267: FROM hr_s_application_ownerships
268: WHERE product_name = p_product_name
269: AND key_name = p_key_name
270: AND key_value = p_key_value);
271:
504: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);
505: DELETE hr_s_legislation_subgroups;
506: COMMIT;
507:
508: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_APPLICATION_OWNERSHIPS',NULL);
509: DELETE hr_s_application_ownerships;
510: COMMIT;
511:
512: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_PAYMENT_TYPES',NULL);
505: DELETE hr_s_legislation_subgroups;
506: COMMIT;
507:
508: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_APPLICATION_OWNERSHIPS',NULL);
509: DELETE hr_s_application_ownerships;
510: COMMIT;
511:
512: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_PAYMENT_TYPES',NULL);
513: DELETE hr_s_payment_types;
694: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
695: --Legislation Rules
696: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
697:
698: INSERT INTO hr_s_application_ownerships
699: (key_name
700: ,product_name
701: ,key_value)
702: SELECT ao.key_name
1039:
1040:
1041: IF p_install_tax_unit = 'N' THEN
1042:
1043: DELETE FROM hr_s_application_ownerships
1044: WHERE key_name = 'BALANCE_DIMENSION_ID'
1045: AND TO_NUMBER(key_value) IN (SELECT balance_dimension_id
1046: FROM hr_s_balance_dimensions
1047: WHERE legislation_code = 'ZZ'