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 160: INSERT INTO pji_fp_aggr_pjp1_t

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

Line 407: INSERT INTO pji_fp_aggr_pjp1_t

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

Line 620: INSERT INTO pji_fp_aggr_pjp1_t

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

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

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

Line 1396: INSERT INTO PJI_FP_AGGR_PJP1_T

1392: IF (l_max_plnver_id IS NULL) THEN
1393: RETURN;
1394: END IF;
1395:
1396: INSERT INTO PJI_FP_AGGR_PJP1_T
1397: (
1398: WORKER_ID
1399: , PROJECT_ID
1400: , PROJECT_ORG_ID

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

1888:
1889:
1890: --
1891: -- Extract the period level plan amounts for PA/GL/non time phased entries from budget lines
1892: -- for the secondary RBS for this plan version into pji_fp_aggr_pjp1_t.
1893: -- EXTRACT_PLAN_AMOUNTS_SECRBS
1894: PROCEDURE EXTRACT_PLAN_AMOUNTS_SECRBS IS
1895: BEGIN
1896:

Line 1928: INSERT INTO PJI_FP_AGGR_PJP1_T

1924: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
1925: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
1926: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
1927:
1928: INSERT INTO PJI_FP_AGGR_PJP1_T
1929: (
1930: WORKER_ID
1931: , PROJECT_ID
1932: , PROJECT_ORG_ID

Line 2976: INSERT INTO PJI_FP_AGGR_PJP1_T

2972: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
2973: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
2974: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
2975:
2976: INSERT INTO PJI_FP_AGGR_PJP1_T
2977: (
2978: WORKER_ID
2979: , PROJECT_ID
2980: , PROJECT_ORG_ID

Line 3978: INSERT INTO pji_fp_aggr_pjp1_t fact

3974: BEGIN
3975:
3976: print_time ( '.....Begin REVERSE_PLAN_AMTS. ' );
3977:
3978: INSERT INTO pji_fp_aggr_pjp1_t fact
3979: (
3980: WORKER_ID
3981: , PRG_LEVEL
3982: , PROJECT_ID

Line 4159: DELETE FROM pji_fp_aggr_pjp1_t

4155:
4156: PROCEDURE DELETE_PRI_NONTIMEPH_ENTDAMTS IS
4157: BEGIN
4158:
4159: DELETE FROM pji_fp_aggr_pjp1_t
4160: WHERE 1=1
4161: AND period_type_id = 32
4162: AND time_id = -1
4163: AND worker_id = g_worker_id;

Line 4190: DELETE FROM pji_fp_aggr_pjp1_t

4186: MERGE_INTO_FP_FACT;
4187:
4188: ELSIF (p_slice_type = 'SEC') THEN
4189:
4190: DELETE FROM pji_fp_aggr_pjp1_t
4191: WHERE line_type = 'OF'
4192: AND worker_id = g_worker_id; -- Data in entered calendar should not be rolled up.
4193:
4194: MERGE_INTO_FP_FACT;

Line 4212: INSERT INTO PJI_FP_AGGR_PJP1_T

4208: , p_commit IN VARCHAR2 := 'F') IS
4209: BEGIN
4210:
4211: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST
4212: INSERT INTO PJI_FP_AGGR_PJP1_T
4213: (
4214: WORKER_ID
4215: , PROJECT_ID
4216: , PROJECT_ORG_ID

Line 4453: INSERT INTO PJI_FP_AGGR_PJP1_T

4449: IF (l_max_plnver_id IS NULL) THEN
4450: RETURN;
4451: END IF;
4452:
4453: INSERT INTO PJI_FP_AGGR_PJP1_T
4454: (
4455: WORKER_ID
4456: , PROJECT_ID
4457: , PROJECT_ORG_ID

Line 5413: DELETE FROM pji_fp_aggr_pjp1_t

5409:
5410: PROCEDURE DELETE_DNGLRATE_PLNVER_DATA IS
5411: BEGIN
5412:
5413: DELETE FROM pji_fp_aggr_pjp1_t
5414: WHERE plan_version_id IN
5415: (
5416: SELECT DISTINCT plan_version_id
5417: FROM pji_fp_aggr_pjp1_t

Line 5417: FROM pji_fp_aggr_pjp1_t

5413: DELETE FROM pji_fp_aggr_pjp1_t
5414: WHERE plan_version_id IN
5415: (
5416: SELECT DISTINCT plan_version_id
5417: FROM pji_fp_aggr_pjp1_t
5418: WHERE worker_id = g_worker_id
5419: AND rate_dangling_flag IS NOT NULL )
5420: AND worker_id = g_worker_id;
5421:

Line 5453: INSERT INTO PJI_FP_AGGR_PJP1_T

5449: print_time('........CREATE_GL1_GL2_CURR_RCDS: Begin. ' );
5450:
5451:
5452:
5453: INSERT INTO PJI_FP_AGGR_PJP1_T
5454: (
5455: WORKER_ID
5456: , PROJECT_ID
5457: , PROJECT_ORG_ID

Line 5784: FROM pji_fp_aggr_pjp1_t fact

5780: , NULL) rate_dangling_flag
5781: , null TIME_DANGLING_FLAG
5782: -- , 0 prg_level
5783: , fact.plan_type_code plan_type_code -- 4471527
5784: FROM pji_fp_aggr_pjp1_t fact
5785: , pa_projects_all ppa
5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL

Line 6009: FROM pji_fp_aggr_pjp1_t fact

6005: , fact.RATE_DANGLING_FLAG
6006: , fact.TIME_DANGLING_FLAG
6007: -- , 0
6008: , fact.plan_type_code plan_type_code -- 4471527
6009: FROM pji_fp_aggr_pjp1_t fact
6010: , pji_fm_extr_plnver3_t ver
6011: WHERE 1=1
6012: AND fact.worker_id = -1
6013: AND fact.project_id = ver.project_id

Line 6173: UPDATE pji_fp_aggr_pjp1_t

6169: WHERE 1=1
6170: AND baselined_flag = 'Y'
6171: AND wp_flag = 'N');
6172:
6173: UPDATE pji_fp_aggr_pjp1_t
6174: SET CURR_RECORD_TYPE_ID = CURR_RECORD_TYPE_ID +
6175: DECODE (currency_code, g_global1_currency_code, 2, 0) -- 000.000.010 = 2
6176: + DECODE (currency_code, g_global2_currency_code, 1, 0) -- 000.000.001 = 1
6177: WHERE BITAND(curr_record_type_id, 28) >= 4 -- 000.011.110 = 16 + 8 + 4 = 28

Line 6206: FROM pji_fp_aggr_pjp1_t fact

6202: SET rate_dangling_flag = 'Y'
6203: WHERE plan_version_id IN (
6204: SELECT
6205: fact.PLAN_VERSION_ID
6206: FROM pji_fp_aggr_pjp1_t fact
6207: , PJI_FM_AGGR_DLY_RATES_T rates
6208: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6209: UNION ALL
6210: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v

Line 6575: pji_fp_aggr_pjp1_t tmp

6571: g_worker_id WORKER_ID
6572: , tmp.ROWID pjp1_rowid
6573: , rl.ROWID fpr_ROWID
6574: FROM
6575: pji_fp_aggr_pjp1_t tmp
6576: , pji_fp_xbs_accum_f rl
6577: WHERE 1 = 1
6578: AND tmp.WORKER_ID = g_worker_id
6579: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)

Line 6686: INSERT INTO PJI_FP_AGGR_PJP1_T

6682:
6683: print_time ( ' REVERSE_ETC l_prev_pub_version_id ' || l_prev_pub_version_id || ' l_actual_plan_version_id ' || l_actual_plan_version_id || ' l_project_id ' || l_project_id ) ;
6684:
6685:
6686: INSERT INTO PJI_FP_AGGR_PJP1_T
6687: (
6688: WORKER_ID
6689: , PRG_LEVEL
6690: , PROJECT_ID

Line 7428: , pji_fp_aggr_pjp1_t tmp

7424: , l_last_updated_by
7425: , l_last_update_login
7426: FROM
7427: PJI_FP_RMAP_FPR_T rwid
7428: , pji_fp_aggr_pjp1_t tmp
7429: , pji_pjp_wbs_header ver3
7430: WHERE 1 = 1
7431: AND tmp.rowid = rwid.pjp1_rowid
7432: AND rl.rowid = rwid.fpr_rowid

Line 7693: , pji_fp_aggr_pjp1_t tmp

7689: , CUSTOM14
7690: , CUSTOM15
7691: , tmp.plan_type_code /* 4471527 */
7692: FROM PJI_FP_RMAP_FPR_T rwid
7693: , pji_fp_aggr_pjp1_t tmp
7694: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
7695: WHERE 1 = 1
7696: AND tmp.worker_id = g_worker_id
7697: AND rwid.worker_id = g_worker_id

Line 8259: FROM pji_fp_aggr_pjp1_t

8255: SELECT plan_version_id
8256: , ( COUNT(DISTINCT time_dangling_flag)
8257: + COUNT(DISTINCT rate_dangling_flag)
8258: ) dangling
8259: FROM pji_fp_aggr_pjp1_t
8260: WHERE worker_id = g_worker_id
8261: GROUP BY plan_version_id
8262: ) b
8263: WHERE dangling > 2

Line 8277: FROM pji_fp_aggr_pjp1_t

8273: SELECT plan_version_id
8274: , ( COUNT(DISTINCT time_dangling_flag)
8275: + COUNT(DISTINCT rate_dangling_flag)
8276: ) dangling
8277: FROM pji_fp_aggr_pjp1_t
8278: WHERE worker_id = g_worker_id
8279: GROUP BY plan_version_id
8280: ) b
8281: WHERE dangling = 2

Line 8346: INSERT INTO pji_fp_aggr_pjp1_t

8342: PROCEDURE RETRIEVE_ENTERED_SLICE (
8343: p_pln_ver_id IN NUMBER := NULL ) IS
8344: BEGIN
8345:
8346: INSERT INTO pji_fp_aggr_pjp1_t
8347: (
8348: WORKER_ID
8349: , PROJECT_ID
8350: , PROJECT_ORG_ID

Line 8519: INSERT INTO pji_fp_aggr_pjp1_t

8515: -- l_worker_id NUMBER := 1;
8516:
8517: BEGIN
8518:
8519: INSERT INTO pji_fp_aggr_pjp1_t
8520: (
8521: WORKER_ID
8522: , PROJECT_ID
8523: , PROJECT_ORG_ID

Line 8671: FROM pji_fp_aggr_pjp1_t fact1

8667: , SUM(fact1.CUSTOM15 )
8668: , fact1.line_type
8669: , g_default_prg_level
8670: , fact1.plan_type_code /* 4471527 */
8671: FROM pji_fp_aggr_pjp1_t fact1
8672: , Pji_RBS_DENORM rbs
8673: , pji_rollup_level_status smart
8674: , pji_pjp_rbs_header rhdr
8675: WHERE 1 = 1

Line 8723: INSERT INTO pji_fp_aggr_pjp1_t

8719: BEGIN
8720:
8721: print_time(' worker id is ... ' || 1);
8722:
8723: INSERT INTO pji_fp_aggr_pjp1_t
8724: (
8725: WORKER_ID
8726: , PROJECT_ID
8727: , PROJECT_ORG_ID

Line 8875: FROM pji_fp_aggr_pjp1_t fact1

8871: , SUM(fact1.CUSTOM15 )
8872: , fact1.line_type
8873: , g_default_prg_level
8874: , fact1.PLAN_TYPE_CODE /* 4471527 */
8875: FROM pji_fp_aggr_pjp1_t fact1
8876: , pji_fm_extr_plnver3_t ver3
8877: WHERE
8878: fact1.RBS_AGGR_LEVEL = g_lowest_level
8879: AND fact1.worker_id = g_worker_id

Line 9118: FROM PJI_FP_AGGR_PJP1_T pjp1

9114: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
9115: , l_last_update_date
9116: , l_last_updated_by
9117: , l_last_update_login
9118: FROM PJI_FP_AGGR_PJP1_T pjp1
9119: , pji_time_cal_period_v cal
9120: WHERE
9121: pjp1.worker_id = g_worker_id
9122: AND pjp1.plan_version_id = whdr.plan_version_id

Line 9131: FROM pji_fp_aggr_pjp1_t

9127: )
9128: WHERE (project_id, plan_version_id) IN
9129: (
9130: SELECT DISTINCT project_id, plan_version_id
9131: FROM pji_fp_aggr_pjp1_t
9132: );
9133:
9134: print_time ( ' After update wbs header. # rows updated = ' || SQL%ROWCOUNT );
9135:

Line 9153: FROM pji_fp_aggr_pjp1_t fact

9149: UPDATE PJI_FM_EXTR_PLNVER3_T
9150: SET TIME_DANGLING_FLAG = 'Y'
9151: WHERE plan_version_id IN
9152: (SELECT fact.plan_version_id
9153: FROM pji_fp_aggr_pjp1_t fact
9154: , pji_time_cal_period_v time
9155: , pji_org_extr_info orginfo
9156: WHERE fact.period_type_id = 32
9157: AND fact.worker_id = g_worker_id

Line 9167: FROM pji_fp_aggr_pjp1_t fact

9163: UPDATE PJI_FM_EXTR_PLNVER3_T
9164: SET TIME_DANGLING_FLAG = 'Y'
9165: WHERE plan_version_id IN
9166: (SELECT fact.plan_version_id
9167: FROM pji_fp_aggr_pjp1_t fact
9168: , pji_time_cal_period_v time
9169: , pji_org_extr_info orginfo
9170: WHERE fact.period_type_id = 32
9171: AND fact.worker_id = g_worker_id

Line 9236: FROM pji_fp_aggr_pjp1_t

9232: INTO l_dangling_flag
9233: FROM DUAL
9234: WHERE EXISTS(
9235: SELECT 1
9236: FROM pji_fp_aggr_pjp1_t
9237: WHERE ( time_dangling_flag IS NOT NULL
9238: OR rate_dangling_flag IS NOT NULL )
9239: AND worker_id=g_worker_id
9240: AND project_id=l_plans_to_mark.project_id

Line 9274: FROM pji_fp_aggr_pjp1_t

9270: record_version_number=nvl(record_version_number,0)+1
9271: WHERE budget_version_id IN
9272: (
9273: SELECT DISTINCT plan_version_id
9274: FROM pji_fp_aggr_pjp1_t
9275: WHERE worker_id = g_worker_id
9276: )
9277: AND budget_version_id NOT IN
9278: (

Line 9280: FROM pji_fp_aggr_pjp1_t

9276: )
9277: AND budget_version_id NOT IN
9278: (
9279: SELECT DISTINCT plan_version_id
9280: FROM pji_fp_aggr_pjp1_t
9281: WHERE worker_id = g_worker_id
9282: AND (time_dangling_flag IS NOT NULL
9283: OR rate_dangling_flag IS NOT NULL )
9284: )

Line 9297: FROM pji_fp_aggr_pjp1_t

9293: record_version_number=nvl(record_version_number,0)+1
9294: WHERE budget_version_id IN
9295: (
9296: SELECT DISTINCT plan_version_id
9297: FROM pji_fp_aggr_pjp1_t
9298: WHERE worker_id = g_worker_id
9299: AND (time_dangling_flag IS NOT NULL
9300: OR rate_dangling_flag IS NOT NULL )
9301: )

Line 9364: FROM pji_fp_aggr_pjp1_t

9360:
9361: /*
9362: select count(1)
9363: INTO l_count
9364: FROM pji_fp_aggr_pjp1_t
9365: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9366: AND prg_rollup_flag = l_prg_rollup_flag;
9367:
9368: 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 9376: FROM pji_fp_aggr_pjp1_t

9372: l_prg_rollup_flag := 'Y';
9373:
9374: select count(1)
9375: INTO l_count
9376: FROM pji_fp_aggr_pjp1_t
9377: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9378: AND prg_rollup_flag = l_prg_rollup_flag;
9379:
9380: 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 9388: FROM pji_fp_aggr_pjp1_t

9384: l_prg_rollup_flag := 'N';
9385:
9386: select count(1)
9387: INTO l_count
9388: FROM pji_fp_aggr_pjp1_t
9389: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9390: AND prg_rollup_flag = l_prg_rollup_flag;
9391:
9392: 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 9400: FROM pji_fp_aggr_pjp1_t

9396: l_prg_rollup_flag := 'Y';
9397:
9398: select count(1)
9399: INTO l_count
9400: FROM pji_fp_aggr_pjp1_t
9401: WHERE wbs_rollup_flag = l_wbs_rollup_flag
9402: AND prg_rollup_flag = l_prg_rollup_flag;
9403:
9404: 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 9428: DELETE FROM pji_fp_aggr_pjp1_t ; -- No worker id join needed for online case.

9424: DELETE FROM PJI_FM_EXTR_PLNVER3_T ; -- No worker id join needed for online case.
9425:
9426: print_time('.......ver3 rows deleted: #= ' || sql%rowcount);
9427:
9428: DELETE FROM pji_fp_aggr_pjp1_t ; -- No worker id join needed for online case.
9429:
9430: print_time('.......pjp1 rows deleted: #= ' || sql%rowcount);
9431:
9432: print_time('.......CLEANUP_INTERIM_TABLES: End. ');