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.PQH_GSP_GRD_STEP_REMOVE dependencies on PQH_GSP_GRD_STEP_REMOVE

Line 1: Package Body Pqh_Gsp_Grd_Step_Remove As

1: Package Body Pqh_Gsp_Grd_Step_Remove As
2: /* $Header: pqgspsde.pkb 120.2 2006/01/10 02:05 ggnanagu noship $ */
3: --
4: --------------------------- get_ovn -----------------------------
5: --

Line 6: g_package VARCHAR2 (30) := 'Pqh_Gsp_Grd_Step_Remove.';

2: /* $Header: pqgspsde.pkb 120.2 2006/01/10 02:05 ggnanagu noship $ */
3: --
4: --------------------------- get_ovn -----------------------------
5: --
6: g_package VARCHAR2 (30) := 'Pqh_Gsp_Grd_Step_Remove.';
7:
8: FUNCTION get_ovn (p_copy_entity_result_id IN NUMBER)
9: RETURN NUMBER
10: IS

Line 266: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (

262:
263: IF l_dml_operation = 'INSERT' THEN
264: -- 1) Purge ABR,HRRATE, CRRATE
265: hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate... :', 30);
266: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (
267: p_opt_result_id => p_copy_entity_result_id,
268: p_copy_entity_txn_id => p_copy_entity_txn_id,
269: p_effective_date => p_effective_date
270: );

Line 277: pqh_gsp_grd_step_remove.purge_pay_scale (

273: hr_utility.set_location ('Calling purge_pay_scale... :', 40);
274:
275: IF l_point_or_step = 'STEP'
276: THEN
277: pqh_gsp_grd_step_remove.purge_pay_scale (
278: p_opt_result_id => p_copy_entity_result_id,
279: p_copy_entity_txn_id => p_copy_entity_txn_id,
280: p_effective_date => p_effective_date
281: );

Line 292: pqh_gsp_grd_step_remove.unlink_opt_abr_hrrate_crrate (

288: );
289: ELSE -- l_dml_operation is UPDATE/UPD_INS/COPIED
290:
291:
292: pqh_gsp_grd_step_remove.unlink_opt_abr_hrrate_crrate (
293: p_opt_result_id => p_copy_entity_result_id,
294: p_copy_entity_txn_id => p_copy_entity_txn_id,
295: p_effective_date => p_effective_date
296: );

Line 398: -- 1) Call Pqh_Gsp_Grd_Step_Remove.remove_opt

394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);
395:
396: IF l_point_or_step = 'STEP' THEN
397: IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN
398: -- 1) Call Pqh_Gsp_Grd_Step_Remove.remove_opt
399: IF p_remove_opt = 'Y' THEN
400: hr_utility.set_location ('Calling remove_opt... :', 60);
401: pqh_gsp_grd_step_remove.remove_opt (
402: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 401: pqh_gsp_grd_step_remove.remove_opt (

397: IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN
398: -- 1) Call Pqh_Gsp_Grd_Step_Remove.remove_opt
399: IF p_remove_opt = 'Y' THEN
400: hr_utility.set_location ('Calling remove_opt... :', 60);
401: pqh_gsp_grd_step_remove.remove_opt (
402: p_copy_entity_txn_id => p_copy_entity_txn_id,
403: p_copy_entity_result_id => l_opt_result_id,
404: p_effective_date => p_effective_date);
405: ELSE

Line 411: pqh_gsp_grd_step_remove.remove_elig_profile (

407: END IF;
408:
409: -- 2) Purge Elig Profile call procedure remove_elig_profile
410: hr_utility.set_location ('Calling remove_elig_profile... :', 70);
411: pqh_gsp_grd_step_remove.remove_elig_profile (
412: p_copy_entity_txn_id => p_copy_entity_txn_id,
413: p_copy_entity_result_id => p_copy_entity_result_id
414: );
415: -- 3) purge OIPL

Line 423: pqh_gsp_grd_step_remove.remove_elig_profile (

419: p_effective_date => p_effective_date
420: );
421: ELSE -- dml_operation = COPIED/UPD_INS/UPDATE
422: -- 1) Mark for deletion call procedure remove_elig_profile
423: pqh_gsp_grd_step_remove.remove_elig_profile (
424: p_copy_entity_txn_id => p_copy_entity_txn_id,
425: p_copy_entity_result_id => p_copy_entity_result_id
426: );
427:

Line 430: pqh_gsp_grd_step_remove.remove_opt (

426: );
427:
428: -- UNLINK OPT
429: IF p_remove_opt = 'Y' Then
430: pqh_gsp_grd_step_remove.remove_opt (
431: p_copy_entity_txn_id => p_copy_entity_txn_id,
432: p_copy_entity_result_id => l_opt_result_id,
433: p_effective_date => p_effective_date);
434: end if;

Line 455: 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile

451: if oipl.dml_operation = 'INSERT'
452: 1) Purge Standard Rates and Criteria Rates
453: 1.a) Purge Standard Rates i.e ABR, HRRATE
454: 1.b) Purge Criteria Rates i.e CRRATE
455: 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
456: 3) purge OIPL
457: else if opt.dml_operation in ('COPIED','UPD_INS','UPDATE')
458: 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
459: 2) oipl.information104 = UNLINK

Line 458: 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile

454: 1.b) Purge Criteria Rates i.e CRRATE
455: 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
456: 3) purge OIPL
457: else if opt.dml_operation in ('COPIED','UPD_INS','UPDATE')
458: 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
459: 2) oipl.information104 = UNLINK
460: */
461: PROCEDURE remove_oipl_point_flavour (
462: p_copy_entity_txn_id IN NUMBER,

Line 494: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (

490: IF l_point_or_step = 'POINT' THEN
491: IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN
492: -- 1) Purge Standard Rates : ABR, HRRATE and Criteria Rates : CRRATE
493: /* hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate ... :', 70);
494: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (
495: p_opt_result_id => l_opt_result_id,
496: p_copy_entity_txn_id => p_copy_entity_txn_id,
497: p_effective_date => p_effective_date
498: );

Line 500: -- 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile

496: p_copy_entity_txn_id => p_copy_entity_txn_id,
497: p_effective_date => p_effective_date
498: );
499: */
500: -- 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
501: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);
502: pqh_gsp_grd_step_remove.remove_elig_profile (
503: p_copy_entity_txn_id => p_copy_entity_txn_id,
504: p_copy_entity_result_id => p_copy_entity_result_id

Line 501: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);

497: p_effective_date => p_effective_date
498: );
499: */
500: -- 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
501: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);
502: pqh_gsp_grd_step_remove.remove_elig_profile (
503: p_copy_entity_txn_id => p_copy_entity_txn_id,
504: p_copy_entity_result_id => p_copy_entity_result_id
505: );

Line 502: pqh_gsp_grd_step_remove.remove_elig_profile (

498: );
499: */
500: -- 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
501: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);
502: pqh_gsp_grd_step_remove.remove_elig_profile (
503: p_copy_entity_txn_id => p_copy_entity_txn_id,
504: p_copy_entity_result_id => p_copy_entity_result_id
505: );
506: -- 3) purge OIPL

Line 513: -- 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile

509: p_copy_entity_result_id => p_copy_entity_result_id,
510: p_effective_date => p_effective_date
511: );
512: ELSE -- dml_operation = COPIED/UPD_INS/UPDATE
513: -- 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
514: pqh_gsp_grd_step_remove.remove_elig_profile (
515: p_copy_entity_txn_id => p_copy_entity_txn_id,
516: p_copy_entity_result_id => p_copy_entity_result_id
517: );

Line 514: pqh_gsp_grd_step_remove.remove_elig_profile (

510: p_effective_date => p_effective_date
511: );
512: ELSE -- dml_operation = COPIED/UPD_INS/UPDATE
513: -- 1) Mark for deletion call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
514: pqh_gsp_grd_step_remove.remove_elig_profile (
515: p_copy_entity_txn_id => p_copy_entity_txn_id,
516: p_copy_entity_result_id => p_copy_entity_result_id
517: );
518: -- 2) oipl.information104 = UNLINK

Line 546: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (

542: hr_utility.set_location ('Entering remove_oipl', 10);
543: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
544: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
545: IF (l_which_flavour = 'POINT') THEN
546: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (
547: p_copy_entity_txn_id => p_copy_entity_txn_id,
548: p_copy_entity_result_id => p_copy_entity_result_id,
549: p_effective_date => p_effective_date
550: );

Line 553: pqh_gsp_grd_step_remove.remove_oipl_step_flavour (

549: p_effective_date => p_effective_date
550: );
551: END IF;
552: IF (l_which_flavour = 'STEP') THEN
553: pqh_gsp_grd_step_remove.remove_oipl_step_flavour (
554: p_copy_entity_txn_id => p_copy_entity_txn_id,
555: p_copy_entity_result_id => p_copy_entity_result_id,
556: p_effective_date => p_effective_date,
557: p_remove_opt => p_remove_opt

Line 607: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (

603: -- Remove Rates, Elig Profiles attahced to OIPL
604: -- Remove OIPL
605: FOR rec_oipls IN csr_oipl_ids LOOP
606: IF (l_which_flavour = 'POINT') THEN
607: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (
608: p_copy_entity_txn_id => p_copy_entity_txn_id,
609: p_copy_entity_result_id => rec_oipls.copy_entity_result_id,
610: p_effective_date => p_effective_date
611: );

Line 615: pqh_gsp_grd_step_remove.remove_oipl_step_flavour (

611: );
612: END IF;
613:
614: IF (l_which_flavour = 'STEP') THEN
615: pqh_gsp_grd_step_remove.remove_oipl_step_flavour (
616: p_copy_entity_txn_id => p_copy_entity_txn_id,
617: p_copy_entity_result_id => rec_oipls.copy_entity_result_id,
618: p_effective_date => p_effective_date
619: );

Line 626: pqh_gsp_grd_step_remove.remove_elig_profile (

622:
623: IF l_dml_operation = 'INSERT' THEN
624: -- 1) Purge Elig Profile call procedure remove_elig_profile
625: hr_utility.set_location ('Calling remove_elig_profile... :', 70);
626: pqh_gsp_grd_step_remove.remove_elig_profile (
627: p_copy_entity_txn_id => p_copy_entity_txn_id,
628: p_copy_entity_result_id => p_copy_entity_result_id
629: );
630:

Line 711: END pqh_gsp_grd_step_remove;

707: THEN
708: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);
709: END unlink_opt_abr_hrrate_crrate;
710:
711: END pqh_gsp_grd_step_remove;