DBA Data[Home] [Help]

APPS.PAY_ITERATE dependencies on HR_STARTUP_DATA_API_SUPPORT

Line 788: hr_startup_data_api_support.enable_startup_mode(l_mode);

784: procedure insert_row is
785: --
786: begin
787: --
788: hr_startup_data_api_support.enable_startup_mode(l_mode);
789: --
790: if l_mode <> 'USER' then
791: hr_startup_data_api_support.delete_owner_definitions;
792: hr_startup_data_api_support.create_owner_definition('PAY');

Line 791: hr_startup_data_api_support.delete_owner_definitions;

787: --
788: hr_startup_data_api_support.enable_startup_mode(l_mode);
789: --
790: if l_mode <> 'USER' then
791: hr_startup_data_api_support.delete_owner_definitions;
792: hr_startup_data_api_support.create_owner_definition('PAY');
793: end if;
794: --
795: -- call insert api. End date will be EOT for now, will be updated

Line 792: hr_startup_data_api_support.create_owner_definition('PAY');

788: hr_startup_data_api_support.enable_startup_mode(l_mode);
789: --
790: if l_mode <> 'USER' then
791: hr_startup_data_api_support.delete_owner_definitions;
792: hr_startup_data_api_support.create_owner_definition('PAY');
793: end if;
794: --
795: -- call insert api. End date will be EOT for now, will be updated
796: -- later if it should be anything other than eot.

Line 946: hr_startup_data_api_support.enable_startup_mode(l_mode);

942: l_tl_exists number;
943: --
944: begin
945: --
946: hr_startup_data_api_support.enable_startup_mode(l_mode);
947: --
948: if l_mode <> 'USER' then
949: hr_startup_data_api_support.delete_owner_definitions;
950: hr_startup_data_api_support.create_owner_definition('PAY');

Line 949: hr_startup_data_api_support.delete_owner_definitions;

945: --
946: hr_startup_data_api_support.enable_startup_mode(l_mode);
947: --
948: if l_mode <> 'USER' then
949: hr_startup_data_api_support.delete_owner_definitions;
950: hr_startup_data_api_support.create_owner_definition('PAY');
951: end if;
952: --
953: -- remove check_for_children as going to do a direct delete, not an api delete.

Line 950: hr_startup_data_api_support.create_owner_definition('PAY');

946: hr_startup_data_api_support.enable_startup_mode(l_mode);
947: --
948: if l_mode <> 'USER' then
949: hr_startup_data_api_support.delete_owner_definitions;
950: hr_startup_data_api_support.create_owner_definition('PAY');
951: end if;
952: --
953: -- remove check_for_children as going to do a direct delete, not an api delete.
954: -- children will be temporarily orphaned, til the row is reinserted with

Line 982: l_sess := nvl(hr_startup_data_api_support.g_startup_session_id

978: --
979: -- also need to delete the row in hr_application_ownerships, else will get
980: -- a unique contraint error
981: --
982: l_sess := nvl(hr_startup_data_api_support.g_startup_session_id
983: ,hr_startup_data_api_support.g_session_id);
984: --
985: for each_row in get_prods(l_sess) loop
986: delete from hr_application_ownerships

Line 983: ,hr_startup_data_api_support.g_session_id);

979: -- also need to delete the row in hr_application_ownerships, else will get
980: -- a unique contraint error
981: --
982: l_sess := nvl(hr_startup_data_api_support.g_startup_session_id
983: ,hr_startup_data_api_support.g_session_id);
984: --
985: for each_row in get_prods(l_sess) loop
986: delete from hr_application_ownerships
987: where key_name = 'RUN_TYPE_ID'

Line 1100: hr_startup_data_api_support.enable_startup_mode(l_mode);

1096: procedure update_row is
1097: --
1098: begin
1099: --
1100: hr_startup_data_api_support.enable_startup_mode(l_mode);
1101: --
1102: if l_mode <> 'USER' then
1103: hr_startup_data_api_support.delete_owner_definitions;
1104: hr_startup_data_api_support.create_owner_definition('PAY');

Line 1103: hr_startup_data_api_support.delete_owner_definitions;

1099: --
1100: hr_startup_data_api_support.enable_startup_mode(l_mode);
1101: --
1102: if l_mode <> 'USER' then
1103: hr_startup_data_api_support.delete_owner_definitions;
1104: hr_startup_data_api_support.create_owner_definition('PAY');
1105: end if;
1106: --
1107: pay_run_type_api.update_run_type

Line 1104: hr_startup_data_api_support.create_owner_definition('PAY');

1100: hr_startup_data_api_support.enable_startup_mode(l_mode);
1101: --
1102: if l_mode <> 'USER' then
1103: hr_startup_data_api_support.delete_owner_definitions;
1104: hr_startup_data_api_support.create_owner_definition('PAY');
1105: end if;
1106: --
1107: pay_run_type_api.update_run_type
1108: (p_effective_date => p_effective_start_date

Line 1237: hr_startup_data_api_support.enable_startup_mode(l_mode);

1233: l_tl_exists number;
1234: --
1235: begin
1236: --
1237: hr_startup_data_api_support.enable_startup_mode(l_mode);
1238: --
1239: if l_mode <> 'USER' then
1240: hr_startup_data_api_support.delete_owner_definitions;
1241: hr_startup_data_api_support.create_owner_definition('PAY');

Line 1240: hr_startup_data_api_support.delete_owner_definitions;

1236: --
1237: hr_startup_data_api_support.enable_startup_mode(l_mode);
1238: --
1239: if l_mode <> 'USER' then
1240: hr_startup_data_api_support.delete_owner_definitions;
1241: hr_startup_data_api_support.create_owner_definition('PAY');
1242: end if;
1243: --
1244: open chk_for_children;

Line 1241: hr_startup_data_api_support.create_owner_definition('PAY');

1237: hr_startup_data_api_support.enable_startup_mode(l_mode);
1238: --
1239: if l_mode <> 'USER' then
1240: hr_startup_data_api_support.delete_owner_definitions;
1241: hr_startup_data_api_support.create_owner_definition('PAY');
1242: end if;
1243: --
1244: open chk_for_children;
1245: fetch chk_for_children into l_ch_rtu_id, l_ch_ovn, l_ch_bg, l_ch_leg;

Line 2094: hr_startup_data_api_support.enable_startup_mode(l_mode);

2090: procedure insert_row is
2091: --
2092: begin
2093: --
2094: hr_startup_data_api_support.enable_startup_mode(l_mode);
2095: --
2096: if l_mode <> 'USER' then
2097: hr_startup_data_api_support.delete_owner_definitions;
2098: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2097: hr_startup_data_api_support.delete_owner_definitions;

2093: --
2094: hr_startup_data_api_support.enable_startup_mode(l_mode);
2095: --
2096: if l_mode <> 'USER' then
2097: hr_startup_data_api_support.delete_owner_definitions;
2098: hr_startup_data_api_support.create_owner_definition('PAY');
2099: end if;
2100: --
2101: -- call insert api. End date will be EOT for now, will be updated

Line 2098: hr_startup_data_api_support.create_owner_definition('PAY');

2094: hr_startup_data_api_support.enable_startup_mode(l_mode);
2095: --
2096: if l_mode <> 'USER' then
2097: hr_startup_data_api_support.delete_owner_definitions;
2098: hr_startup_data_api_support.create_owner_definition('PAY');
2099: end if;
2100: --
2101: -- call insert api. End date will be EOT for now, will be updated
2102: -- later if it should be anything other than eot.

Line 2148: hr_startup_data_api_support.enable_startup_mode(l_mode);

2144: procedure zap_insert(p_rtu_id number) is
2145: --
2146: begin
2147: --
2148: hr_startup_data_api_support.enable_startup_mode(l_mode);
2149: --
2150: if l_mode <> 'USER' then
2151: hr_startup_data_api_support.delete_owner_definitions;
2152: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2151: hr_startup_data_api_support.delete_owner_definitions;

2147: --
2148: hr_startup_data_api_support.enable_startup_mode(l_mode);
2149: --
2150: if l_mode <> 'USER' then
2151: hr_startup_data_api_support.delete_owner_definitions;
2152: hr_startup_data_api_support.create_owner_definition('PAY');
2153: end if;
2154: --
2155: -- in order to update an existing row, need to purge the existing row

Line 2152: hr_startup_data_api_support.create_owner_definition('PAY');

2148: hr_startup_data_api_support.enable_startup_mode(l_mode);
2149: --
2150: if l_mode <> 'USER' then
2151: hr_startup_data_api_support.delete_owner_definitions;
2152: hr_startup_data_api_support.create_owner_definition('PAY');
2153: end if;
2154: --
2155: -- in order to update an existing row, need to purge the existing row
2156: -- then insert a new row.

Line 2217: hr_startup_data_api_support.enable_startup_mode(l_mode);

2213: procedure update_row is
2214: --
2215: begin
2216: --
2217: hr_startup_data_api_support.enable_startup_mode(l_mode);
2218: --
2219: if l_mode <> 'USER' then
2220: hr_startup_data_api_support.delete_owner_definitions;
2221: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2220: hr_startup_data_api_support.delete_owner_definitions;

2216: --
2217: hr_startup_data_api_support.enable_startup_mode(l_mode);
2218: --
2219: if l_mode <> 'USER' then
2220: hr_startup_data_api_support.delete_owner_definitions;
2221: hr_startup_data_api_support.create_owner_definition('PAY');
2222: end if;
2223: --
2224: pay_run_type_usage_api.update_run_type_usage

Line 2221: hr_startup_data_api_support.create_owner_definition('PAY');

2217: hr_startup_data_api_support.enable_startup_mode(l_mode);
2218: --
2219: if l_mode <> 'USER' then
2220: hr_startup_data_api_support.delete_owner_definitions;
2221: hr_startup_data_api_support.create_owner_definition('PAY');
2222: end if;
2223: --
2224: pay_run_type_usage_api.update_run_type_usage
2225: (p_effective_date => p_effective_start_date

Line 2266: hr_startup_data_api_support.enable_startup_mode(l_mode);

2262: procedure set_end_date is
2263: --
2264: begin
2265: --
2266: hr_startup_data_api_support.enable_startup_mode(l_mode);
2267: --
2268: if l_mode <> 'USER' then
2269: hr_startup_data_api_support.delete_owner_definitions;
2270: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2269: hr_startup_data_api_support.delete_owner_definitions;

2265: --
2266: hr_startup_data_api_support.enable_startup_mode(l_mode);
2267: --
2268: if l_mode <> 'USER' then
2269: hr_startup_data_api_support.delete_owner_definitions;
2270: hr_startup_data_api_support.create_owner_definition('PAY');
2271: end if;
2272: --
2273: -- delete the run type usage

Line 2270: hr_startup_data_api_support.create_owner_definition('PAY');

2266: hr_startup_data_api_support.enable_startup_mode(l_mode);
2267: --
2268: if l_mode <> 'USER' then
2269: hr_startup_data_api_support.delete_owner_definitions;
2270: hr_startup_data_api_support.create_owner_definition('PAY');
2271: end if;
2272: --
2273: -- delete the run type usage
2274: --

Line 2670: hr_startup_data_api_support.enable_startup_mode('USER');

2666: procedure zap_insert_rom is
2667: --
2668: begin
2669: --
2670: hr_startup_data_api_support.enable_startup_mode('USER');
2671: --
2672: pay_run_type_org_method_api.delete_run_type_org_method(
2673: p_effective_date => p_effective_start_date
2674: ,p_datetrack_delete_mode => 'ZAP'

Line 2680: hr_startup_data_api_support.enable_startup_mode('USER');

2676: ,p_object_version_number => l_ovn
2677: ,p_effective_start_date => l_esd
2678: ,p_effective_end_date => l_eed);
2679: --
2680: hr_startup_data_api_support.enable_startup_mode('USER');
2681: --
2682: pay_run_type_org_method_api.create_run_type_org_method(
2683: p_effective_date => p_effective_start_date
2684: ,p_run_type_id => l_rt_id

Line 2701: hr_startup_data_api_support.enable_startup_mode('USER');

2697: procedure insert_rom is
2698: --
2699: begin
2700: --
2701: hr_startup_data_api_support.enable_startup_mode('USER');
2702: --
2703: pay_run_type_org_method_api.create_run_type_org_method(
2704: p_effective_date => p_effective_start_date
2705: ,p_run_type_id => l_rt_id

Line 2722: hr_startup_data_api_support.enable_startup_mode('USER');

2718: procedure update_rom is
2719: --
2720: begin
2721: --
2722: hr_startup_data_api_support.enable_startup_mode('USER');
2723: --
2724: pay_run_type_org_method_api.update_run_type_org_method(
2725: p_effective_date => p_effective_start_date
2726: ,p_datetrack_update_mode => 'UPDATE'

Line 2742: hr_startup_data_api_support.enable_startup_mode('USER');

2738: procedure end_date_rom is
2739: --
2740: begin
2741: --
2742: hr_startup_data_api_support.enable_startup_mode('USER');
2743: --
2744: pay_run_type_org_method_api.delete_run_type_org_method(
2745: p_effective_date => g_rom_rec.old_eed
2746: ,p_datetrack_delete_mode => 'DELETE'

Line 2938: hr_startup_data_api_support.enable_startup_mode(l_mode);

2934: procedure insert_etu is
2935: --
2936: begin
2937: --
2938: hr_startup_data_api_support.enable_startup_mode(l_mode);
2939: --
2940: if l_mode <> 'USER' then
2941: hr_startup_data_api_support.delete_owner_definitions;
2942: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2941: hr_startup_data_api_support.delete_owner_definitions;

2937: --
2938: hr_startup_data_api_support.enable_startup_mode(l_mode);
2939: --
2940: if l_mode <> 'USER' then
2941: hr_startup_data_api_support.delete_owner_definitions;
2942: hr_startup_data_api_support.create_owner_definition('PAY');
2943: end if;
2944: --
2945: pay_element_type_usage_api.create_element_type_usage(

Line 2942: hr_startup_data_api_support.create_owner_definition('PAY');

2938: hr_startup_data_api_support.enable_startup_mode(l_mode);
2939: --
2940: if l_mode <> 'USER' then
2941: hr_startup_data_api_support.delete_owner_definitions;
2942: hr_startup_data_api_support.create_owner_definition('PAY');
2943: end if;
2944: --
2945: pay_element_type_usage_api.create_element_type_usage(
2946: p_effective_date => p_effective_start_date

Line 2964: hr_startup_data_api_support.enable_startup_mode(g_etu_rec.l_mode);

2960: procedure end_date_etu is
2961: --
2962: begin
2963: --
2964: hr_startup_data_api_support.enable_startup_mode(g_etu_rec.l_mode);
2965: --
2966: if l_mode <> 'USER' then
2967: hr_startup_data_api_support.delete_owner_definitions;
2968: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2967: hr_startup_data_api_support.delete_owner_definitions;

2963: --
2964: hr_startup_data_api_support.enable_startup_mode(g_etu_rec.l_mode);
2965: --
2966: if l_mode <> 'USER' then
2967: hr_startup_data_api_support.delete_owner_definitions;
2968: hr_startup_data_api_support.create_owner_definition('PAY');
2969: end if;
2970: --
2971: pay_element_type_usage_api.delete_element_type_usage(

Line 2968: hr_startup_data_api_support.create_owner_definition('PAY');

2964: hr_startup_data_api_support.enable_startup_mode(g_etu_rec.l_mode);
2965: --
2966: if l_mode <> 'USER' then
2967: hr_startup_data_api_support.delete_owner_definitions;
2968: hr_startup_data_api_support.create_owner_definition('PAY');
2969: end if;
2970: --
2971: pay_element_type_usage_api.delete_element_type_usage(
2972: p_effective_date => g_etu_rec.old_eed

Line 2985: hr_startup_data_api_support.enable_startup_mode(l_mode);

2981: procedure zap_insert_etu is
2982: --
2983: begin
2984: --
2985: hr_startup_data_api_support.enable_startup_mode(l_mode);
2986: --
2987: if l_mode <> 'USER' then
2988: hr_startup_data_api_support.delete_owner_definitions;
2989: hr_startup_data_api_support.create_owner_definition('PAY');

Line 2988: hr_startup_data_api_support.delete_owner_definitions;

2984: --
2985: hr_startup_data_api_support.enable_startup_mode(l_mode);
2986: --
2987: if l_mode <> 'USER' then
2988: hr_startup_data_api_support.delete_owner_definitions;
2989: hr_startup_data_api_support.create_owner_definition('PAY');
2990: end if;
2991: --
2992: pay_element_type_usage_api.delete_element_type_usage(

Line 2989: hr_startup_data_api_support.create_owner_definition('PAY');

2985: hr_startup_data_api_support.enable_startup_mode(l_mode);
2986: --
2987: if l_mode <> 'USER' then
2988: hr_startup_data_api_support.delete_owner_definitions;
2989: hr_startup_data_api_support.create_owner_definition('PAY');
2990: end if;
2991: --
2992: pay_element_type_usage_api.delete_element_type_usage(
2993: p_effective_date => p_effective_start_date

Line 3000: hr_startup_data_api_support.enable_startup_mode(l_mode);

2996: ,p_object_version_number => l_ovn
2997: ,p_effective_start_date => l_esd
2998: ,p_effective_end_date => l_eed);
2999: --
3000: hr_startup_data_api_support.enable_startup_mode(l_mode);
3001: --
3002: if l_mode <> 'USER' then
3003: hr_startup_data_api_support.delete_owner_definitions;
3004: hr_startup_data_api_support.create_owner_definition('PAY');

Line 3003: hr_startup_data_api_support.delete_owner_definitions;

2999: --
3000: hr_startup_data_api_support.enable_startup_mode(l_mode);
3001: --
3002: if l_mode <> 'USER' then
3003: hr_startup_data_api_support.delete_owner_definitions;
3004: hr_startup_data_api_support.create_owner_definition('PAY');
3005: end if;
3006: --
3007: pay_element_type_usage_api.create_element_type_usage(

Line 3004: hr_startup_data_api_support.create_owner_definition('PAY');

3000: hr_startup_data_api_support.enable_startup_mode(l_mode);
3001: --
3002: if l_mode <> 'USER' then
3003: hr_startup_data_api_support.delete_owner_definitions;
3004: hr_startup_data_api_support.create_owner_definition('PAY');
3005: end if;
3006: --
3007: pay_element_type_usage_api.create_element_type_usage(
3008: p_effective_date => p_effective_start_date

Line 3026: hr_startup_data_api_support.enable_startup_mode(l_mode);

3022: procedure update_etu is
3023: --
3024: begin
3025: --
3026: hr_startup_data_api_support.enable_startup_mode(l_mode);
3027: --
3028: if l_mode <> 'USER' then
3029: hr_startup_data_api_support.delete_owner_definitions;
3030: hr_startup_data_api_support.create_owner_definition('PAY');

Line 3029: hr_startup_data_api_support.delete_owner_definitions;

3025: --
3026: hr_startup_data_api_support.enable_startup_mode(l_mode);
3027: --
3028: if l_mode <> 'USER' then
3029: hr_startup_data_api_support.delete_owner_definitions;
3030: hr_startup_data_api_support.create_owner_definition('PAY');
3031: end if;
3032: --
3033: pay_element_type_usage_api.update_element_type_usage(

Line 3030: hr_startup_data_api_support.create_owner_definition('PAY');

3026: hr_startup_data_api_support.enable_startup_mode(l_mode);
3027: --
3028: if l_mode <> 'USER' then
3029: hr_startup_data_api_support.delete_owner_definitions;
3030: hr_startup_data_api_support.create_owner_definition('PAY');
3031: end if;
3032: --
3033: pay_element_type_usage_api.update_element_type_usage(
3034: p_effective_date => p_effective_start_date