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_PA_WHATIF_PROCESS dependencies on PQH_PA_WHATIF_RESULTS

Line 4: TYPE hierarchy_tab IS TABLE OF pqh_pa_whatif_results%ROWTYPE INDEX BY BINARY_INTEGER;

1: PACKAGE BODY pqh_pa_whatif_process AS
2: /* $Header: pqwifswi.pkb 120.2.12010000.4 2008/11/06 21:02:28 sagnanas ship $ */
3:
4: TYPE hierarchy_tab IS TABLE OF pqh_pa_whatif_results%ROWTYPE INDEX BY BINARY_INTEGER;
5:
6: g_hierarchy hierarchy_tab;
7:
8: g_debug boolean := hr_utility.debug_enabled;

Line 3418: pqh_pa_whatif_results

3414: l_include VARCHAR2(2);
3415:
3416: Cursor csr_oiplip IS
3417: Select hierarchy_id from
3418: pqh_pa_whatif_results
3419: where whatif_results_batch_id=p_whatif_results_batch_id
3420: and parent_hierarchy_id=p_plip_id
3421: and hierarchy_type='OIPLIP';
3422:

Line 3442: Delete from pqh_pa_whatif_results

3438: FETCH check_setup into l_include;
3439: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3440: CLOSE check_setup;
3441: IF l_include='E'or (p_parent_exclude and l_include='IE') Then
3442: Delete from pqh_pa_whatif_results
3443: where whatif_results_batch_id=p_whatif_results_batch_id
3444: and hierarchy_id=C1.hierarchy_id and hierarchy_type='OIPLIP';
3445: ELSIF l_include='I' THEN l_parent_include :=true;
3446: END IF;

Line 3462: pqh_pa_whatif_results

3458: l_include VARCHAR2(2);
3459:
3460: Cursor csr_plip IS
3461: Select hierarchy_id from
3462: pqh_pa_whatif_results
3463: where whatif_results_batch_id=p_whatif_results_batch_id
3464: and parent_hierarchy_id=p_ptip_id
3465: and hierarchy_type='PLIP';
3466:

Line 3483: Delete from pqh_pa_whatif_results

3479: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3480: CLOSE check_setup;
3481: IF l_include='E' OR (p_parent_exclude and l_include ='IE')Then
3482: IF NOT check_oiplip(C1.hierarchy_id,true,p_whatif_results_batch_id) THEN
3483: Delete from pqh_pa_whatif_results
3484: where whatif_results_batch_id=p_whatif_results_batch_id
3485: and hierarchy_id=C1.hierarchy_id and hierarchy_type='PLIP';
3486: ELSE l_parent_include :=true;
3487: END IF;

Line 3508: pqh_pa_whatif_results

3504: l_include VARCHAR2(2);
3505:
3506: Cursor csr_ptip IS
3507: Select hierarchy_id from
3508: pqh_pa_whatif_results
3509: where whatif_results_batch_id=p_whatif_results_batch_id
3510: and parent_hierarchy_id=p_pgm_id
3511: and hierarchy_type='PTIP';
3512:

Line 3529: Delete from pqh_pa_whatif_results

3525: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3526: CLOSE check_setup;
3527: IF l_include='E' OR (p_parent_exclude and l_include ='IE')Then
3528: IF NOT check_plip(C1.hierarchy_id,true,p_whatif_results_batch_id) THEN
3529: Delete from pqh_pa_whatif_results
3530: where whatif_results_batch_id=p_whatif_results_batch_id
3531: and hierarchy_id=C1.hierarchy_id and hierarchy_type='PTIP';
3532: ELSE l_parent_include :=true;
3533: END IF;

Line 3551: pqh_pa_whatif_results

3547: l_dummy BOOLEAN;
3548:
3549: Cursor csr_pgm IS
3550: Select hierarchy_id from
3551: pqh_pa_whatif_results
3552: where whatif_results_batch_id=p_whatif_results_batch_id
3553: and hierarchy_type='PGM';
3554:
3555: Cursor check_setup(p_pgm_id NUMBER) IS

Line 3571: Delete from pqh_pa_whatif_results

3567: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3568: CLOSE check_setup;
3569: IF l_include='E' Then
3570: IF NOT check_ptip(C1.hierarchy_id,true,p_whatif_results_batch_id) THEN
3571: Delete from pqh_pa_whatif_results
3572: where whatif_results_batch_id=p_whatif_results_batch_id
3573: and hierarchy_id=C1.hierarchy_id and hierarchy_type='PGM';
3574: END IF;
3575: ELSE l_dummy :=check_ptip(C1.hierarchy_id,false,p_whatif_results_batch_id);

Line 3592: pqh_pa_whatif_results

3588: l_include VARCHAR2(2);
3589:
3590: Cursor csr_oipnip IS
3591: Select hierarchy_id from
3592: pqh_pa_whatif_results
3593: where whatif_results_batch_id=p_whatif_results_batch_id
3594: and parent_hierarchy_id=p_pnip_id
3595: and hierarchy_type='OIPNIP';
3596:

Line 3612: Delete from pqh_pa_whatif_results

3608: FETCH check_setup into l_include;
3609: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3610: CLOSE check_setup;
3611: IF l_include='E'or (p_parent_exclude and l_include='IE') Then
3612: Delete from pqh_pa_whatif_results
3613: where whatif_results_batch_id=p_whatif_results_batch_id
3614: and hierarchy_id=C1.hierarchy_id and hierarchy_type='OIPNIP';
3615: ELSIF l_include='I' THEN l_parent_include :=true;
3616: END IF;

Line 3633: pqh_pa_whatif_results

3629: l_include VARCHAR2(2);
3630:
3631: Cursor csr_pnip IS
3632: Select hierarchy_id from
3633: pqh_pa_whatif_results
3634: where whatif_results_batch_id=p_whatif_results_batch_id
3635: and parent_hierarchy_id=p_pl_typ_id
3636: and hierarchy_type='PNIP';
3637:

Line 3654: Delete from pqh_pa_whatif_results

3650: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3651: CLOSE check_setup;
3652: IF l_include='E' OR (p_parent_exclude and l_include ='IE')Then
3653: IF NOT check_oipnip(C1.hierarchy_id,true,p_whatif_results_batch_id) THEN
3654: Delete from pqh_pa_whatif_results
3655: where whatif_results_batch_id=p_whatif_results_batch_id
3656: and hierarchy_id=C1.hierarchy_id and hierarchy_type='PNIP';
3657: ELSE l_parent_include :=true;
3658: END IF;

Line 3676: pqh_pa_whatif_results

3672: l_dummy BOOLEAN;
3673:
3674: Cursor csr_pt IS
3675: Select hierarchy_id from
3676: pqh_pa_whatif_results
3677: where whatif_results_batch_id=p_whatif_results_batch_id
3678: and hierarchy_type='PT';
3679:
3680: Cursor check_setup(p_pl_typ_id NUMBER) IS

Line 3696: Delete from pqh_pa_whatif_results

3692: IF check_setup%NOTFOUND THEN l_include :='IE'; END IF;
3693: CLOSE check_setup;
3694: IF l_include='E' Then
3695: IF NOT check_pnip(C1.hierarchy_id,true,p_whatif_results_batch_id) THEN
3696: Delete from pqh_pa_whatif_results
3697: where whatif_results_batch_id=p_whatif_results_batch_id
3698: and hierarchy_id=C1.hierarchy_id and hierarchy_type='PT';
3699: END IF;
3700: ELSE l_dummy :=check_pnip(C1.hierarchy_id,false,p_whatif_results_batch_id);

Line 3742: SELECT pqh_pa_whatif_results_s.nextval

3738: ,p_whatif_results_batch_id OUT NOCOPY NUMBER
3739: ) IS
3740:
3741: CURSOR csr_sequence_val IS
3742: SELECT pqh_pa_whatif_results_s.nextval
3743: FROM sys.dual;
3744: --
3745: l_proc VARCHAR2(72);
3746:

Line 3759: INSERT INTO PQH_PA_WHATIF_RESULTS (

3755: FETCH csr_sequence_val INTO p_whatif_results_batch_id;
3756: CLOSE csr_sequence_val;
3757:
3758: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
3759: INSERT INTO PQH_PA_WHATIF_RESULTS (
3760: WHATIF_RESULTS_BATCH_ID
3761: ,PERSON_ID
3762: ,BUSINESS_GROUP_ID
3763: ,TRANSACTION_ID

Line 3830: FROM pqh_pa_whatif_results

3826: PRAGMA AUTONOMOUS_TRANSACTION;
3827:
3828: CURSOR csr_purge_data IS
3829: SELECT DISTINCT whatif_results_batch_id
3830: FROM pqh_pa_whatif_results
3831: WHERE CREATION_DATE < trunc(SYSDATE);
3832: --
3833: l_proc VARCHAR2(72);
3834:

Line 3843: DELETE PQH_PA_WHATIF_RESULTS

3839: hr_utility.set_location('Entering: ' || l_proc,10);
3840: end if;
3841:
3842: FOR csr_purge_data_rec IN csr_purge_data LOOP
3843: DELETE PQH_PA_WHATIF_RESULTS
3844: WHERE WHATIF_RESULTS_BATCH_ID = csr_purge_data_rec.whatif_results_batch_id;
3845: END LOOP;
3846: COMMIT;
3847:

Line 4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;

4203: -- Dump data from PL / SQL table to pqh_pa_watif_results;
4204: IF l_conflict_life_events THEN
4205: -- Conflicting LE's are there
4206: BEGIN
4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
4211: hr_utility.set_message_token('ROUTINE', l_proc);

Line 4218: INSERT INTO PQH_PA_WHATIF_RESULTS (

4214: END;
4215: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST
4216: LOOP
4217: IF g_hierarchy(i).hierarchy_type =l_flag THEN
4218: INSERT INTO PQH_PA_WHATIF_RESULTS (
4219: WHATIF_RESULTS_BATCH_ID
4220: ,PERSON_ID
4221: ,BUSINESS_GROUP_ID
4222: ,LER_ID