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.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FP_AGGR_PJP1_T

Line 162: INSERT INTO pji_fp_aggr_pjp1_t

158: print_time('Populated ver3 table.');
159:
160:
161: FORALL I IN 1..p_source_fp_version_ids.COUNT
162: INSERT INTO pji_fp_aggr_pjp1_t
163: (
164: WORKER_ID
165: , PROJECT_ID
166: , PROJECT_ORG_ID

Line 409: INSERT INTO pji_fp_aggr_pjp1_t

405:
406: CLEANUP_INTERIM_TABLES; print_time(' 2.3 .. ');
407:
408: FORALL I IN 1..p_source_fp_version_ids.COUNT
409: INSERT INTO pji_fp_aggr_pjp1_t
410: (
411: worker_id
412: , PROJECT_ID
413: , PROJECT_ORG_ID

Line 622: INSERT INTO pji_fp_aggr_pjp1_t

618:
619: CLEANUP_INTERIM_TABLES;
620: print_time(' 1.9 .. ');
621:
622: INSERT INTO pji_fp_aggr_pjp1_t
623: (
624: worker_id
625: , PROJECT_ID
626: , PROJECT_ORG_ID

Line 1382: -- for the primary RBS for this plan version into pji_fp_aggr_pjp1_t.

1378:
1379:
1380: --
1381: -- Extract the period level plan amounts for PA/GL/non time phased entries from budget lines
1382: -- for the primary RBS for this plan version into pji_fp_aggr_pjp1_t.
1383: -- EXTRACT_PLAN_AMOUNTS_PRIRBS
1384: PROCEDURE EXTRACT_PLAN_AMOUNTS_PRIRBS IS
1385: l_count NUMBER;
1386: l_max_plnver_id NUMBER := NULL;

Line 1436: INSERT INTO PJI_FP_AGGR_PJP1_T

1432:
1433: -- End cbs change
1434:
1435:
1436: INSERT INTO PJI_FP_AGGR_PJP1_T
1437: (
1438: WORKER_ID
1439: , PROJECT_ID
1440: , PROJECT_ORG_ID

Line 1944: -- for the secondary RBS for this plan version into pji_fp_aggr_pjp1_t.

1940:
1941:
1942: --
1943: -- Extract the period level plan amounts for PA/GL/non time phased entries from budget lines
1944: -- for the secondary RBS for this plan version into pji_fp_aggr_pjp1_t.
1945: -- EXTRACT_PLAN_AMOUNTS_SECRBS
1946: PROCEDURE EXTRACT_PLAN_AMOUNTS_SECRBS IS
1947: BEGIN
1948:

Line 1992: INSERT INTO PJI_FP_AGGR_PJP1_T

1988: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
1989: END IF;
1990: -- End cbs change
1991:
1992: INSERT INTO PJI_FP_AGGR_PJP1_T
1993: (
1994: WORKER_ID
1995: , PROJECT_ID
1996: , PROJECT_ORG_ID

Line 3057: INSERT INTO PJI_FP_AGGR_PJP1_T

3053: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
3054: END IF;
3055: -- End cbs change
3056:
3057: INSERT INTO PJI_FP_AGGR_PJP1_T
3058: (
3059: WORKER_ID
3060: , PROJECT_ID
3061: , PROJECT_ORG_ID

Line 4065: INSERT INTO pji_fp_aggr_pjp1_t fact

4061: BEGIN
4062:
4063: print_time ( '.....Begin REVERSE_PLAN_AMTS. ' );
4064:
4065: INSERT INTO pji_fp_aggr_pjp1_t fact
4066: (
4067: WORKER_ID
4068: , PRG_LEVEL
4069: , PROJECT_ID

Line 4246: DELETE FROM pji_fp_aggr_pjp1_t

4242:
4243: PROCEDURE DELETE_PRI_NONTIMEPH_ENTDAMTS IS
4244: BEGIN
4245:
4246: DELETE FROM pji_fp_aggr_pjp1_t
4247: WHERE 1=1
4248: AND period_type_id = 32
4249: AND time_id = -1
4250: AND worker_id = g_worker_id;

Line 4277: DELETE FROM pji_fp_aggr_pjp1_t

4273: MERGE_INTO_FP_FACT;
4274:
4275: ELSIF (p_slice_type = 'SEC') THEN
4276:
4277: DELETE FROM pji_fp_aggr_pjp1_t
4278: WHERE line_type = 'OF'
4279: AND worker_id = g_worker_id; -- Data in entered calendar should not be rolled up.
4280:
4281: MERGE_INTO_FP_FACT;

Line 4299: INSERT INTO PJI_FP_AGGR_PJP1_T

4295: , p_commit IN VARCHAR2 := 'F') IS
4296: BEGIN
4297:
4298: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST
4299: INSERT INTO PJI_FP_AGGR_PJP1_T
4300: (
4301: WORKER_ID
4302: , PROJECT_ID
4303: , PROJECT_ORG_ID

Line 4551: INSERT INTO PJI_FP_AGGR_PJP1_T

4547: IF (l_max_plnver_id IS NULL) THEN
4548: RETURN;
4549: END IF;
4550:
4551: INSERT INTO PJI_FP_AGGR_PJP1_T
4552: (
4553: WORKER_ID
4554: , PROJECT_ID
4555: , PROJECT_ORG_ID

Line 5514: DELETE FROM pji_fp_aggr_pjp1_t

5510:
5511: PROCEDURE DELETE_DNGLRATE_PLNVER_DATA IS
5512: BEGIN
5513:
5514: DELETE FROM pji_fp_aggr_pjp1_t
5515: WHERE plan_version_id IN
5516: (
5517: SELECT DISTINCT plan_version_id
5518: FROM pji_fp_aggr_pjp1_t

Line 5518: FROM pji_fp_aggr_pjp1_t

5514: DELETE FROM pji_fp_aggr_pjp1_t
5515: WHERE plan_version_id IN
5516: (
5517: SELECT DISTINCT plan_version_id
5518: FROM pji_fp_aggr_pjp1_t
5519: WHERE worker_id = g_worker_id
5520: AND rate_dangling_flag IS NOT NULL )
5521: AND worker_id = g_worker_id;
5522:

Line 5554: INSERT INTO PJI_FP_AGGR_PJP1_T

5550: print_time('........CREATE_GL1_GL2_CURR_RCDS: Begin. ' );
5551:
5552:
5553:
5554: INSERT INTO PJI_FP_AGGR_PJP1_T
5555: (
5556: WORKER_ID
5557: , PROJECT_ID
5558: , PROJECT_ORG_ID

Line 5885: FROM pji_fp_aggr_pjp1_t fact

5881: , NULL) rate_dangling_flag
5882: , null TIME_DANGLING_FLAG
5883: -- , 0 prg_level
5884: , fact.plan_type_code plan_type_code -- 4471527
5885: FROM pji_fp_aggr_pjp1_t fact
5886: , pa_projects_all ppa
5887: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5888: UNION
5889: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL

Line 6110: FROM pji_fp_aggr_pjp1_t fact

6106: , fact.RATE_DANGLING_FLAG
6107: , fact.TIME_DANGLING_FLAG
6108: -- , 0
6109: , fact.plan_type_code plan_type_code -- 4471527
6110: FROM pji_fp_aggr_pjp1_t fact
6111: , pji_fm_extr_plnver3_t ver
6112: WHERE 1=1
6113: AND fact.worker_id = -1
6114: AND fact.project_id = ver.project_id

Line 6274: UPDATE pji_fp_aggr_pjp1_t

6270: WHERE 1=1
6271: AND baselined_flag = 'Y'
6272: AND wp_flag = 'N');
6273:
6274: UPDATE pji_fp_aggr_pjp1_t
6275: SET CURR_RECORD_TYPE_ID = CURR_RECORD_TYPE_ID +
6276: DECODE (currency_code, g_global1_currency_code, 2, 0) -- 000.000.010 = 2
6277: + DECODE (currency_code, g_global2_currency_code, 1, 0) -- 000.000.001 = 1
6278: WHERE BITAND(curr_record_type_id, 28) >= 4 -- 000.011.110 = 16 + 8 + 4 = 28

Line 6307: FROM pji_fp_aggr_pjp1_t fact

6303: SET rate_dangling_flag = 'Y'
6304: WHERE plan_version_id IN (
6305: SELECT
6306: fact.PLAN_VERSION_ID
6307: FROM pji_fp_aggr_pjp1_t fact
6308: , PJI_FM_AGGR_DLY_RATES_T rates
6309: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6310: UNION ALL
6311: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v

Line 6632: DELETE FROM PJI_FP_AGGR_PJP1_T

6628: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');
6629:
6630: if l_per_analysis_flag = 'N' then
6631:
6632: DELETE FROM PJI_FP_AGGR_PJP1_T
6633: WHERE calendar_type <> 'A'
6634: and plan_type_id=10; -- Modified for Bug 14369993
6635:
6636: end if;

Line 6698: pji_fp_aggr_pjp1_t tmp

6694: g_worker_id WORKER_ID
6695: , tmp.ROWID pjp1_rowid
6696: , rl.ROWID fpr_ROWID
6697: FROM
6698: pji_fp_aggr_pjp1_t tmp
6699: , pji_fp_xbs_accum_f rl
6700: WHERE 1 = 1
6701: AND tmp.WORKER_ID = g_worker_id
6702: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)

Line 6811: INSERT INTO PJI_FP_AGGR_PJP1_T

6807:
6808:
6809: PJI_FM_PLAN_MAINT_PVT.set_res_class_flag;
6810:
6811: INSERT INTO PJI_FP_AGGR_PJP1_T
6812: (
6813: WORKER_ID
6814: , PRG_LEVEL
6815: , PROJECT_ID

Line 7564: , pji_fp_aggr_pjp1_t tmp

7560: , l_last_updated_by
7561: , l_last_update_login
7562: FROM
7563: PJI_FP_RMAP_FPR_T rwid
7564: , pji_fp_aggr_pjp1_t tmp
7565: , pji_pjp_wbs_header ver3
7566: WHERE 1 = 1
7567: AND tmp.rowid = rwid.pjp1_rowid
7568: AND rl.rowid = rwid.fpr_rowid

Line 7836: , pji_fp_aggr_pjp1_t tmp

7832: , CUSTOM14
7833: , CUSTOM15
7834: , tmp.plan_type_code /* 4471527 */
7835: FROM PJI_FP_RMAP_FPR_T rwid
7836: , pji_fp_aggr_pjp1_t tmp
7837: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
7838: WHERE 1 = 1
7839: AND tmp.worker_id = g_worker_id
7840: AND rwid.worker_id = g_worker_id

Line 8407: FROM pji_fp_aggr_pjp1_t

8403: SELECT plan_version_id
8404: , ( COUNT(DISTINCT time_dangling_flag)
8405: + COUNT(DISTINCT rate_dangling_flag)
8406: ) dangling
8407: FROM pji_fp_aggr_pjp1_t
8408: WHERE worker_id = g_worker_id
8409: GROUP BY plan_version_id
8410: ) b
8411: WHERE dangling > 2

Line 8425: FROM pji_fp_aggr_pjp1_t

8421: SELECT plan_version_id
8422: , ( COUNT(DISTINCT time_dangling_flag)
8423: + COUNT(DISTINCT rate_dangling_flag)
8424: ) dangling
8425: FROM pji_fp_aggr_pjp1_t
8426: WHERE worker_id = g_worker_id
8427: GROUP BY plan_version_id
8428: ) b
8429: WHERE dangling = 2

Line 8494: INSERT INTO pji_fp_aggr_pjp1_t

8490: PROCEDURE RETRIEVE_ENTERED_SLICE (
8491: p_pln_ver_id IN NUMBER := NULL ) IS
8492: BEGIN
8493:
8494: INSERT INTO pji_fp_aggr_pjp1_t
8495: (
8496: WORKER_ID
8497: , PROJECT_ID
8498: , PROJECT_ORG_ID

Line 8667: INSERT INTO pji_fp_aggr_pjp1_t

8663: -- l_worker_id NUMBER := 1;
8664:
8665: BEGIN
8666:
8667: INSERT INTO pji_fp_aggr_pjp1_t
8668: (
8669: WORKER_ID
8670: , PROJECT_ID
8671: , PROJECT_ORG_ID

Line 8819: FROM pji_fp_aggr_pjp1_t fact1

8815: , SUM(fact1.CUSTOM15 )
8816: , fact1.line_type
8817: , g_default_prg_level
8818: , fact1.plan_type_code /* 4471527 */
8819: FROM pji_fp_aggr_pjp1_t fact1
8820: , Pji_RBS_DENORM rbs
8821: , pji_rollup_level_status smart
8822: , pji_pjp_rbs_header rhdr
8823: WHERE 1 = 1

Line 8871: INSERT INTO pji_fp_aggr_pjp1_t

8867: BEGIN
8868:
8869: print_time(' worker id is ... ' || 1);
8870:
8871: INSERT INTO pji_fp_aggr_pjp1_t
8872: (
8873: WORKER_ID
8874: , PROJECT_ID
8875: , PROJECT_ORG_ID

Line 9023: FROM pji_fp_aggr_pjp1_t fact1

9019: , SUM(fact1.CUSTOM15 )
9020: , fact1.line_type
9021: , g_default_prg_level
9022: , fact1.PLAN_TYPE_CODE /* 4471527 */
9023: FROM pji_fp_aggr_pjp1_t fact1
9024: , pji_fm_extr_plnver3_t ver3
9025: WHERE
9026: fact1.RBS_AGGR_LEVEL = g_lowest_level
9027: AND fact1.worker_id = g_worker_id

Line 9266: FROM PJI_FP_AGGR_PJP1_T pjp1

9262: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
9263: , l_last_update_date
9264: , l_last_updated_by
9265: , l_last_update_login
9266: FROM PJI_FP_AGGR_PJP1_T pjp1
9267: , pji_time_cal_period_v cal
9268: WHERE
9269: pjp1.worker_id = g_worker_id
9270: AND pjp1.plan_version_id = whdr.plan_version_id

Line 9280: FROM pji_fp_aggr_pjp1_t

9276: /*
9277: WHERE (project_id, plan_version_id) IN
9278: (
9279: SELECT DISTINCT project_id, plan_version_id
9280: FROM pji_fp_aggr_pjp1_t
9281: );
9282: For bug 7192035 */
9283:
9284: WHERE exists (select 1 from pji_fp_aggr_pjp1_t ver where worker_id = g_worker_id

Line 9284: WHERE exists (select 1 from pji_fp_aggr_pjp1_t ver where worker_id = g_worker_id

9280: FROM pji_fp_aggr_pjp1_t
9281: );
9282: For bug 7192035 */
9283:
9284: WHERE exists (select 1 from pji_fp_aggr_pjp1_t ver where worker_id = g_worker_id
9285: and ver.project_id = whdr.project_id
9286: and ver.plan_version_id = whdr.plan_version_id
9287: and ver.plan_type_id = whdr.plan_type_id);
9288:

Line 9308: FROM pji_fp_aggr_pjp1_t fact

9304: UPDATE PJI_FM_EXTR_PLNVER3_T
9305: SET TIME_DANGLING_FLAG = 'Y'
9306: WHERE plan_version_id IN
9307: (SELECT fact.plan_version_id
9308: FROM pji_fp_aggr_pjp1_t fact
9309: , pji_time_cal_period_v time
9310: , pji_org_extr_info orginfo
9311: WHERE fact.period_type_id = 32
9312: AND fact.worker_id = g_worker_id

Line 9322: FROM pji_fp_aggr_pjp1_t fact

9318: UPDATE PJI_FM_EXTR_PLNVER3_T
9319: SET TIME_DANGLING_FLAG = 'Y'
9320: WHERE plan_version_id IN
9321: (SELECT fact.plan_version_id
9322: FROM pji_fp_aggr_pjp1_t fact
9323: , pji_time_cal_period_v time
9324: , pji_org_extr_info orginfo
9325: WHERE fact.period_type_id = 32
9326: AND fact.worker_id = g_worker_id

Line 9391: FROM pji_fp_aggr_pjp1_t

9387: INTO l_dangling_flag
9388: FROM DUAL
9389: WHERE EXISTS(
9390: SELECT 1
9391: FROM pji_fp_aggr_pjp1_t
9392: WHERE ( time_dangling_flag IS NOT NULL
9393: OR rate_dangling_flag IS NOT NULL )
9394: AND worker_id=g_worker_id
9395: AND project_id=l_plans_to_mark.project_id

Line 9429: FROM pji_fp_aggr_pjp1_t

9425: record_version_number=nvl(record_version_number,0)+1
9426: WHERE budget_version_id IN
9427: (
9428: SELECT DISTINCT plan_version_id
9429: FROM pji_fp_aggr_pjp1_t
9430: WHERE worker_id = g_worker_id
9431: )
9432: AND budget_version_id NOT IN
9433: (

Line 9435: FROM pji_fp_aggr_pjp1_t

9431: )
9432: AND budget_version_id NOT IN
9433: (
9434: SELECT DISTINCT plan_version_id
9435: FROM pji_fp_aggr_pjp1_t
9436: WHERE worker_id = g_worker_id
9437: AND (time_dangling_flag IS NOT NULL
9438: OR rate_dangling_flag IS NOT NULL )
9439: )

Line 9452: FROM pji_fp_aggr_pjp1_t

9448: record_version_number=nvl(record_version_number,0)+1
9449: WHERE budget_version_id IN
9450: (
9451: SELECT DISTINCT plan_version_id
9452: FROM pji_fp_aggr_pjp1_t
9453: WHERE worker_id = g_worker_id
9454: AND (time_dangling_flag IS NOT NULL
9455: OR rate_dangling_flag IS NOT NULL )
9456: )

Line 9519: FROM pji_fp_aggr_pjp1_t

9515:
9516: /*
9517: select count(1)
9518: INTO l_count
9519: FROM pji_fp_aggr_pjp1_t
9520: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9521: AND prg_rollup_flag = l_prg_rollup_flag;
9522:
9523: print_time ( ' l_worker_id = '|| g_worker_id || ' wbs rollup flag = ' || l_wbs_rollup_flag || ' prg rollup flag = ' || l_prg_rollup_flag || ' l_count ' || l_count);

Line 9531: FROM pji_fp_aggr_pjp1_t

9527: l_prg_rollup_flag := 'Y';
9528:
9529: select count(1)
9530: INTO l_count
9531: FROM pji_fp_aggr_pjp1_t
9532: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9533: AND prg_rollup_flag = l_prg_rollup_flag;
9534:
9535: print_time ( ' l_worker_id = '|| g_worker_id || ' wbs rollup flag = ' || l_wbs_rollup_flag || ' prg rollup flag = ' || l_prg_rollup_flag || ' l_count ' || l_count);

Line 9543: FROM pji_fp_aggr_pjp1_t

9539: l_prg_rollup_flag := 'N';
9540:
9541: select count(1)
9542: INTO l_count
9543: FROM pji_fp_aggr_pjp1_t
9544: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9545: AND prg_rollup_flag = l_prg_rollup_flag;
9546:
9547: print_time ( ' l_worker_id = '|| g_worker_id || ' wbs rollup flag = ' || l_wbs_rollup_flag || ' prg rollup flag = ' || l_prg_rollup_flag || ' l_count ' || l_count);

Line 9555: FROM pji_fp_aggr_pjp1_t

9551: l_prg_rollup_flag := 'Y';
9552:
9553: select count(1)
9554: INTO l_count
9555: FROM pji_fp_aggr_pjp1_t
9556: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9557: AND prg_rollup_flag = l_prg_rollup_flag;
9558:
9559: print_time ( ' l_worker_id = '|| g_worker_id || ' wbs rollup flag = ' || l_wbs_rollup_flag || ' prg rollup flag = ' || l_prg_rollup_flag || ' l_count ' || l_count);

Line 9583: DELETE FROM pji_fp_aggr_pjp1_t ; -- No worker id join needed for online case.

9579: DELETE FROM PJI_FM_EXTR_PLNVER3_T ; -- No worker id join needed for online case.
9580:
9581: print_time('.......ver3 rows deleted: #= ' || sql%rowcount);
9582:
9583: DELETE FROM pji_fp_aggr_pjp1_t ; -- No worker id join needed for online case.
9584:
9585: print_time('.......pjp1 rows deleted: #= ' || sql%rowcount);
9586:
9587: print_time('.......CLEANUP_INTERIM_TABLES: End. ');