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.PA_PERIOD_MASKS_PUB dependencies on PA_FP_PERIOD_MASK_TMP

Line 384: pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;

380: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS';
381:
382: CURSOR succ_pd IS
383: SELECT from_anchor_position,num_of_periods FROM
384: pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;
385:
386: CURSOR prec_pd IS
387: SELECT from_anchor_position,num_of_periods FROM
388: pa_fp_period_mask_tmp WHERE from_anchor_position < 0 ORDER BY from_anchor_position desc;

Line 388: pa_fp_period_mask_tmp WHERE from_anchor_position < 0 ORDER BY from_anchor_position desc;

384: pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;
385:
386: CURSOR prec_pd IS
387: SELECT from_anchor_position,num_of_periods FROM
388: pa_fp_period_mask_tmp WHERE from_anchor_position < 0 ORDER BY from_anchor_position desc;
389:
390:
391: l_from_anchor_position NUMBER;
392: l_first_no_of_pds NUMBER;

Line 416: DELETE FROM pa_fp_period_mask_tmp;

412:
413: x_msg_count := 0;
414:
415:
416: DELETE FROM pa_fp_period_mask_tmp;
417:
418: IF P_PA_DEBUG_MODE = 'Y' THEN
419: pa_fp_gen_amount_utils.fp_debug
420: (p_msg => 'Before inserting into temporary table',

Line 426: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)

422: p_log_level => 5);
423: END IF;
424:
425: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
426: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
427: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));
428:
429: IF P_PA_DEBUG_MODE = 'Y' THEN
430: pa_fp_gen_amount_utils.fp_debug

Line 436: from pa_fp_period_mask_tmp

432: p_module_name => l_module_name,
433: p_log_level => 5);
434: END IF;
435: select count(*) into l_count
436: from pa_fp_period_mask_tmp
437: where anchor_period_flag = 'Y';
438:
439: if l_count = 0 then
440: update pa_fp_period_mask_tmp set

Line 440: update pa_fp_period_mask_tmp set

436: from pa_fp_period_mask_tmp
437: where anchor_period_flag = 'Y';
438:
439: if l_count = 0 then
440: update pa_fp_period_mask_tmp set
441: anchor_period_flag = 'Y' where
442: from_anchor_position = 1;
443: end if;
444: SELECT from_anchor_position,num_of_periods

Line 446: FROM pa_fp_period_mask_tmp

442: from_anchor_position = 1;
443: end if;
444: SELECT from_anchor_position,num_of_periods
445: INTO l_from_anchor_position,l_first_no_of_pds
446: FROM pa_fp_period_mask_tmp
447: WHERE anchor_period_flag = 'Y';
448:
449: UPDATE pa_fp_period_mask_tmp
450: SET from_anchor_position = from_anchor_position - l_from_anchor_position;

Line 449: UPDATE pa_fp_period_mask_tmp

445: INTO l_from_anchor_position,l_first_no_of_pds
446: FROM pa_fp_period_mask_tmp
447: WHERE anchor_period_flag = 'Y';
448:
449: UPDATE pa_fp_period_mask_tmp
450: SET from_anchor_position = from_anchor_position - l_from_anchor_position;
451:
452: UPDATE pa_fp_period_mask_tmp
453: SET from_anchor_start = 0, from_anchor_end = num_of_periods - 1

Line 452: UPDATE pa_fp_period_mask_tmp

448:
449: UPDATE pa_fp_period_mask_tmp
450: SET from_anchor_position = from_anchor_position - l_from_anchor_position;
451:
452: UPDATE pa_fp_period_mask_tmp
453: SET from_anchor_start = 0, from_anchor_end = num_of_periods - 1
454: WHERE anchor_period_flag = 'Y';
455:
456: l_initial_flag := 'Y';

Line 470: UPDATE pa_fp_period_mask_tmp

466:
467: FOR succ_pd_rec IN succ_pd LOOP
468: l_tmp_end := l_tmp_end + succ_pd_rec.num_of_periods;
469:
470: UPDATE pa_fp_period_mask_tmp
471: SET from_anchor_start = l_tmp, from_anchor_end = l_tmp_end
472: WHERE from_anchor_position = succ_pd_rec.from_anchor_position;
473:
474: l_tmp := l_tmp + succ_pd_rec.num_of_periods;

Line 497: UPDATE pa_fp_period_mask_tmp

493:
494: FOR prec_pd_rec IN prec_pd LOOP
495: l_tmp := l_tmp - prec_pd_rec.num_of_periods;
496:
497: UPDATE pa_fp_period_mask_tmp
498: SET from_anchor_start = l_tmp, from_anchor_end = l_tmp_end
499: WHERE from_anchor_position = prec_pd_rec.from_anchor_position;
500:
501: l_tmp_end := l_tmp_end - prec_pd_rec.num_of_periods;

Line 523: INSERT INTO pa_fp_period_mask_tmp(num_of_periods, anchor_period_flag,

519: END IF;
520:
521: --Inserting additional records in the temp table to allow additional periods before/after the project periods
522:
523: INSERT INTO pa_fp_period_mask_tmp(num_of_periods, anchor_period_flag,
524: from_anchor_start,from_anchor_end,from_anchor_position
525: )
526: VALUES (0,'N',-99999,-99999,-99999);
527:

Line 528: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,

524: from_anchor_start,from_anchor_end,from_anchor_position
525: )
526: VALUES (0,'N',-99999,-99999,-99999);
527:
528: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
529: anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
530: VALUES (0,'N',99999,99999,99999 );
531:
532:

Line 563: sysdate FROM pa_fp_period_mask_tmp );

559: sysdate,
560: FND_GLOBAL.USER_ID,
561: FND_GLOBAL.LOGIN_ID,
562: FND_GLOBAL.LOGIN_ID,
563: sysdate FROM pa_fp_period_mask_tmp );
564:
565:
566: IF (SQL%NOTFOUND) THEN
567: IF P_PA_DEBUG_MODE = 'Y' THEN