[Home] [Help]
131: /*
132: NAME
133: ins_application_ownership
134: DESCRIPTION
135: Insert startup data into hr_application_ownerships.
136: NOTE (M Dyer)
137: Changes in the way child records in startup mode work mean that we
138: no longer want to derive the ownership of the balance feeds from the
139: current session. Instead we want to derive it from the record that is
150: --
151: if p_input_value_id is null then
152: -- We want the balance feed to inherit the ownership of the balance type
153: --
154: INSERT INTO hr_application_ownerships
155: (KEY_NAME,PRODUCT_NAME,KEY_VALUE)
156: SELECT 'BALANCE_FEED_ID',
157: AO.PRODUCT_NAME,
158: p_balance_feed_id
155: (KEY_NAME,PRODUCT_NAME,KEY_VALUE)
156: SELECT 'BALANCE_FEED_ID',
157: AO.PRODUCT_NAME,
158: p_balance_feed_id
159: FROM hr_application_ownerships AO
160: WHERE ao.key_name = 'BALANCE_TYPE_ID'
161: AND ao.key_value = to_char(p_balance_type_id);
162: --
163: elsif p_balance_type_id is null then
163: elsif p_balance_type_id is null then
164: --
165: hr_utility.set_location('ins_application_ownership', 2);
166: --
167: INSERT INTO hr_application_ownerships
168: (KEY_NAME,PRODUCT_NAME,KEY_VALUE)
169: SELECT 'BALANCE_FEED_ID',
170: AO.PRODUCT_NAME,
171: p_balance_feed_id
168: (KEY_NAME,PRODUCT_NAME,KEY_VALUE)
169: SELECT 'BALANCE_FEED_ID',
170: AO.PRODUCT_NAME,
171: p_balance_feed_id
172: FROM hr_application_ownerships AO
173: WHERE ao.key_name = 'INPUT_VALUE_ID'
174: AND ao.key_value = to_char(p_input_value_id);
175: --
176: end if;
1666: IF p_balance_feed_id is not NULL THEN
1667: IF p_delete_mode = 'ZAP' THEN
1668: --
1669: IF p_mode <> 'USER' THEN
1670: DELETE FROM hr_application_ownerships
1671: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1672: AND KEY_VALUE = p_balance_feed_id;
1673: END IF;
1674: --
1723: IF p_input_value_id is not NULL THEN
1724: IF p_delete_mode = 'ZAP' THEN
1725: --
1726: IF p_mode <> 'USER' THEN
1727: DELETE FROM hr_application_ownerships
1728: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1729: AND KEY_VALUE IN
1730: (SELECT balance_feed_id
1731: FROM pay_balance_feeds_f
1792: --
1793: IF p_delete_mode = 'ZAP' THEN
1794: --
1795: IF p_mode <> 'USER' THEN
1796: DELETE FROM hr_application_ownerships
1797: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1798: AND KEY_VALUE IN
1799: (SELECT feed.balance_feed_id
1800: FROM pay_balance_feeds_f feed,
1919: --
1920: v_pay_value := hr_input_values.get_pay_value_name(p_legislation_code);
1921: --
1922: IF p_mode <> 'USER' THEN
1923: DELETE FROM hr_application_ownerships
1924: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1925: AND KEY_VALUE IN
1926: (SELECT balance_feed_id
1927: FROM pay_balance_feeds_f
1972: --
1973: v_pay_value := hr_input_values.get_pay_value_name(p_legislation_code);
1974: --
1975: IF p_mode <> 'USER' THEN
1976: DELETE FROM hr_application_ownerships
1977: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1978: AND KEY_VALUE IN
1979: (SELECT balance_feed_id
1980: FROM pay_balance_feeds_f
2073: DELETE FROM pay_balance_classifications
2074: WHERE balance_type_id = p_balance_type_id;
2075: --
2076: IF p_mode <> 'USER' THEN
2077: DELETE FROM hr_application_ownerships
2078: WHERE KEY_NAME = 'BALANCE_FEED_ID'
2079: AND KEY_VALUE IN
2080: (SELECT balance_feed_id
2081: FROM pay_balance_feeds_f