eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELETE dependencies on HR_DELETE

Line 1: PACKAGE BODY hr_delete AS

1: PACKAGE BODY hr_delete AS
2: /* $Header: pedelete.pkb 120.0 2005/05/31 07:34:08 appldev noship $ */
3: /*
4: ******************************************************************
5: * *

Line 24: Name : hr_delete (BODY)

20: * *
21: ******************************************************************
22: ==================================================================
23:
24: Name : hr_delete (BODY)
25:
26: Description : Contains the definition of general delete procedures
27: as declared in the hr_delete package header
28:

Line 27: as declared in the hr_delete package header

23:
24: Name : hr_delete (BODY)
25:
26: Description : Contains the definition of general delete procedures
27: as declared in the hr_delete package header
28:
29:
30: Change List
31: -----------

Line 284: g_package varchar2(33) := 'hr_delete.'; -- Global package name

280: */
281: --
282: -- Package variables
283: --
284: g_package varchar2(33) := 'hr_delete.'; -- Global package name
285: --
286: PROCEDURE delete_time_def_direct(p_business_group_id NUMBER)
287: IS
288: --

Line 379: hr_utility.set_location('hr_delete.delete_mag_structure',1);

375: PROCEDURE delete_mag_structure(p_business_group_id NUMBER)
376: IS
377: begin
378: --
379: hr_utility.set_location('hr_delete.delete_mag_structure',1);
380: DELETE FROM pay_magnetic_records mr
381: WHERE EXISTS ( SELECT ''
382: FROM ff_formulas_f ff
383: WHERE ff.formula_id = mr.formula_id

Line 413: hr_utility.set_location('hr_delete.delete_bal_load_struct',10);

409: where bl.batch_id = p_batch;
410: --
411: begin
412: --
413: hr_utility.set_location('hr_delete.delete_bal_load_struct',10);
414: --
415: OPEN get_bg ;
416: FETCH get_bg INTO l_business_group_name ;
417: CLOSE get_bg ;

Line 419: hr_utility.set_location('hr_delete.delete_bal_load_struct',20);

415: OPEN get_bg ;
416: FETCH get_bg INTO l_business_group_name ;
417: CLOSE get_bg ;
418: --
419: hr_utility.set_location('hr_delete.delete_bal_load_struct',20);
420: --
421: FOR pbhrec IN pbh LOOP
422: if (pbhrec.batch_status in ('E', 'P', 'V')) then
423: hr_utility.set_location('hr_delete.delete_bal_load_struct',30);

Line 423: hr_utility.set_location('hr_delete.delete_bal_load_struct',30);

419: hr_utility.set_location('hr_delete.delete_bal_load_struct',20);
420: --
421: FOR pbhrec IN pbh LOOP
422: if (pbhrec.batch_status in ('E', 'P', 'V')) then
423: hr_utility.set_location('hr_delete.delete_bal_load_struct',30);
424: FOR pblrec IN pbl (pbhrec.batch_id) LOOP
425: DELETE FROM pay_message_lines
426: WHERE source_id = pblrec.batch_line_id
427: AND source_type = 'L';

Line 441: hr_utility.set_location('hr_delete.delete_bal_load_struct',99);

437: DELETE FROM pay_balance_batch_headers bh
438: WHERE bh.batch_id = pbhrec.batch_id;
439: END LOOP;
440: --
441: hr_utility.set_location('hr_delete.delete_bal_load_struct',99);
442: --
443: end delete_bal_load_struct;
444: --
445: PROCEDURE delete_formula_direct(p_business_group_id NUMBER)

Line 518: hr_utility.set_location('hr_delete.delete_assign_low_detail',1);

514: PROCEDURE delete_assign_low_detail(p_business_group_id NUMBER)
515: IS
516: begin
517: --
518: hr_utility.set_location('hr_delete.delete_assign_low_detail',1);
519: DELETE FROM pay_coin_anal_elements cae
520: WHERE EXISTS (SELECT ''
521: FROM pay_pre_payments ppp
522: WHERE ppp.pre_payment_id

Line 538: hr_utility.set_location('hr_delete.delete_assign_low_detail',3);

534: )
535: )
536: );
537: --
538: hr_utility.set_location('hr_delete.delete_assign_low_detail',3);
539: DELETE FROM pay_monetary_units_tl montl
540: WHERE EXISTS ( SELECT ''
541: FROM pay_monetary_units mon
542: WHERE montl.monetary_unit_id = mon.monetary_unit_id

Line 549: hr_utility.set_location('hr_delete.delete_assign_low_detail',5);

545: --
546: DELETE FROM pay_monetary_units mon
547: WHERE mon.business_group_id = p_business_group_id;
548: --
549: hr_utility.set_location('hr_delete.delete_assign_low_detail',5);
550: DELETE FROM pay_process_events ppe
551: WHERE EXISTS (SELECT ''
552: FROM per_assignments_f pa
553: WHERE pa.assignment_id = ppe.assignment_id

Line 1557: hr_utility.set_location('hr_delete.delete_org_low_detail',10);

1553: PROCEDURE delete_org_low_detail(p_business_group_id NUMBER)
1554: IS
1555: begin
1556: --
1557: hr_utility.set_location('hr_delete.delete_org_low_detail',10);
1558: DELETE FROM pay_grade_rules_f gr
1559: WHERE gr.business_group_id = p_business_group_id;
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);

Line 1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);

1557: hr_utility.set_location('hr_delete.delete_org_low_detail',10);
1558: DELETE FROM pay_grade_rules_f gr
1559: WHERE gr.business_group_id = p_business_group_id;
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1562: DELETE FROM pay_rates pr
1563: WHERE pr.business_group_id = p_business_group_id;
1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);
1565: --

Line 1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);

1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1562: DELETE FROM pay_rates pr
1563: WHERE pr.business_group_id = p_business_group_id;
1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);
1565: --
1566: --
1567: end delete_org_low_detail;
1568: --

Line 2131: hr_utility.set_location('hr_delete.delete_bg_misc',1);

2127: l_rows_processed number;
2128: --
2129: begin
2130: --
2131: hr_utility.set_location('hr_delete.delete_bg_misc',1);
2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --

Line 2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);

2128: --
2129: begin
2130: --
2131: hr_utility.set_location('hr_delete.delete_bg_misc',1);
2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --
2136: hr_utility.set_location('hr_delete.delete_bg_misc',4);

Line 2136: hr_utility.set_location('hr_delete.delete_bg_misc',4);

2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --
2136: hr_utility.set_location('hr_delete.delete_bg_misc',4);
2137: --
2138: -- Get table name if it exists.
2139: --
2140: open fsp_table_name;

Line 2145: hr_utility.set_location('hr_delete.delete_bg_misc',7);

2141: fetch fsp_table_name into l_fsp_table_name;
2142: if fsp_table_name%found then
2143: close fsp_table_name;
2144: --
2145: hr_utility.set_location('hr_delete.delete_bg_misc',7);
2146: --
2147: -- Define the dynamic cursor.
2148: --
2149: l_sql_text := 'delete from '

Line 2158: hr_utility.set_location('hr_delete.delete_bg_misc',8);

2154: -- Open Cursor for Processing Sql statment.
2155: --
2156: l_sql_cursor := dbms_sql.open_cursor;
2157: --
2158: hr_utility.set_location('hr_delete.delete_bg_misc',8);
2159: --
2160: -- Parse SQL statement.
2161: --
2162: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

Line 2164: hr_utility.set_location('hr_delete.delete_bg_misc',9);

2160: -- Parse SQL statement.
2161: --
2162: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
2163: --
2164: hr_utility.set_location('hr_delete.delete_bg_misc',9);
2165: --
2166: -- Execute the sql
2167: --
2168: l_rows_processed := dbms_sql.execute(l_sql_cursor);

Line 2170: hr_utility.set_location('hr_delete.delete_bg_misc',10);

2166: -- Execute the sql
2167: --
2168: l_rows_processed := dbms_sql.execute(l_sql_cursor);
2169: --
2170: hr_utility.set_location('hr_delete.delete_bg_misc',10);
2171: --
2172: -- Close cursor.
2173: --
2174: dbms_sql.close_cursor(l_sql_cursor);

Line 2176: hr_utility.set_location('hr_delete.delete_bg_misc',11);

2172: -- Close cursor.
2173: --
2174: dbms_sql.close_cursor(l_sql_cursor);
2175: --
2176: hr_utility.set_location('hr_delete.delete_bg_misc',11);
2177: --
2178: --
2179: else
2180: close fsp_table_name;

Line 2182: hr_utility.set_location('hr_delete.delete_bg_misc',12);

2178: --
2179: else
2180: close fsp_table_name;
2181: --
2182: hr_utility.set_location('hr_delete.delete_bg_misc',12);
2183: end if;
2184: end delete_bg_misc;
2185: --
2186: PROCEDURE delete_upg_details(p_business_group_id NUMBER)

Line 2191: hr_utility.set_location('hr_delete.p_business_group_id',1);

2187: IS
2188: --
2189: begin
2190: --
2191: hr_utility.set_location('hr_delete.p_business_group_id',1);
2192: --
2193: delete from pay_upgrade_status
2194: where business_group_id = p_business_group_id;
2195: --

Line 2196: hr_utility.set_location('hr_delete.p_business_group_id',2);

2192: --
2193: delete from pay_upgrade_status
2194: where business_group_id = p_business_group_id;
2195: --
2196: hr_utility.set_location('hr_delete.p_business_group_id',2);
2197: --
2198: end delete_upg_details;
2199: --
2200: -- ----------------------------------------------------------------------------

Line 2246: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);

2242: FROM hr_all_positions_f pos
2243: WHERE pos.position_id = pol.position_id
2244: AND pos.business_group_id = p_business_group_id);
2245: --
2246: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);
2247:
2248: -- Bug fix 3622082.
2249: -- Delete statement modified to improve performance.
2250:

Line 2256: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);

2252: WHERE ol.organization_id IN ( SELECT ou.organization_id
2253: FROM hr_all_organization_units ou
2254: WHERE ou.business_group_id = p_business_group_id);
2255: --
2256: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
2257: DELETE FROM per_security_profiles psp
2258: WHERE psp.business_group_id = p_business_group_id
2259: AND psp.view_all_flag = 'N';
2260: --

Line 2261: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);

2257: DELETE FROM per_security_profiles psp
2258: WHERE psp.business_group_id = p_business_group_id
2259: AND psp.view_all_flag = 'N';
2260: --
2261: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
2262: DELETE FROM per_security_organizations pso
2263: WHERE pso.organization_id IN ( SELECT ou.organization_id
2264: FROM hr_all_organization_units ou
2265: WHERE ou.business_group_id = p_business_group_id);

Line 2267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);

2263: WHERE pso.organization_id IN ( SELECT ou.organization_id
2264: FROM hr_all_organization_units ou
2265: WHERE ou.business_group_id = p_business_group_id);
2266: --
2267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
2268: DELETE FROM per_security_users psu
2269: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
2270: FROM per_security_profiles sp
2271: WHERE sp.business_group_id = p_business_group_id);

Line 2373: end hr_delete;

2369: hr_utility.set_location('Leaving: '||l_proc,230);
2370: end delete_below_bg;
2371: --
2372: --
2373: end hr_delete;