[Home] [Help]
81:
82: CURSOR get_element_class_csr IS
83: SELECT distinct classification_id, legislation_code, classification_name
84: FROM hr_s_element_classifications pec
85: ,hr_s_application_ownerships ao
86: ,fnd_product_installations b
87: ,fnd_application c
88: WHERE nvl(legislation_code,'X') = 'ZZ'
89: AND ao.key_name = 'CLASSIFICATION_ID'
96:
97: CURSOR get_balance_type_csr IS
98: SELECT distinct balance_type_id, currency_code, balance_name
99: FROM hr_s_balance_types pbt
100: ,hr_s_application_ownerships ao
101: ,fnd_product_installations b
102: ,fnd_application c
103: WHERE pbt.legislation_code = 'ZZ'
104: AND ao.key_name = 'BALANCE_TYPE_ID'
112: CURSOR get_defined_balances_csr IS
113: SELECT distinct defined_balance_id, pbt.balance_name bname
114: FROM hr_s_defined_balances pdb
115: ,hr_s_balance_types pbt
116: ,hr_s_application_ownerships ao
117: ,fnd_product_installations b
118: ,fnd_application c
119: WHERE pdb.legislation_code ='ZZ'
120: AND ao.key_name = 'DEFINED_BALANCE_ID'
127: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
128:
129: CURSOR get_balance_dimensions_csr IS
130: SELECT distinct balance_dimension_id, dimension_name
131: FROM hr_s_application_ownerships ao
132: ,hr_s_balance_dimensions pbd
133: ,fnd_product_installations b
134: ,fnd_application c
135: WHERE pbd.legislation_code ='ZZ'
143:
144:
145: CURSOR get_routes_csr IS
146: SELECT distinct fr.route_id, route_name
147: FROM hr_s_application_ownerships ao
148: ,hr_s_routes fr
149: ,hr_s_balance_dimensions pbd
150: ,fnd_product_installations b
151: ,fnd_application c
248: END write_out;
249:
250:
251: -- ---------------------------------------------------------------------
252: -- This procedure inserts the Ownership in hr_s_application_ownerships
253: -- table. It takes the required values from where it is being called.
254: -- ---------------------------------------------------------------------
255: PROCEDURE insert_ownership(p_key_name IN VARCHAR2,
256: p_product_name IN VARCHAR2,
259:
260: null;
261:
262: /*hr_utility.set_location('--pay_ip_startup_util.insert_ownership',10);
263: INSERT INTO hr_s_application_ownerships
264: ( key_name
265: ,product_name
266: ,key_value)
267: SELECT
269: ,p_product_name
270: ,p_key_value
271: FROM dual
272: WHERE NOT EXISTS (SELECT NULL
273: FROM hr_s_application_ownerships
274: WHERE product_name = p_product_name
275: AND key_name = p_key_name
276: AND key_value = p_key_value);
277:
566: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);
567: DELETE hr_s_legislation_subgroups;
568: COMMIT;
569:
570: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_APPLICATION_OWNERSHIPS',NULL);
571: DELETE hr_s_application_ownerships;
572: COMMIT;
573:
574: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_PAYMENT_TYPES',NULL);
567: DELETE hr_s_legislation_subgroups;
568: COMMIT;
569:
570: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_APPLICATION_OWNERSHIPS',NULL);
571: DELETE hr_s_application_ownerships;
572: COMMIT;
573:
574: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_PAYMENT_TYPES',NULL);
575: DELETE hr_s_payment_types;
801: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
802: --Legislation Rules
803: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
804:
805: INSERT INTO hr_s_application_ownerships
806: (key_name
807: ,product_name
808: ,key_value)
809: SELECT ao.key_name
1228: WHERE legislation_code = 'ZZ'
1229: AND database_item_suffix = '_ASG_RUN'
1230: );
1231:
1232: DELETE FROM hr_s_application_ownerships
1233: WHERE key_name = 'BALANCE_DIMENSION_ID'
1234: AND TO_NUMBER(key_value) IN (SELECT balance_dimension_id
1235: FROM hr_s_balance_dimensions
1236: WHERE legislation_code = 'ZZ'