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_PVT dependencies on PJI_FP_AGGR_PJP1

Line 3099: -- for the primary RBS for this plan version into pji_fp_aggr_pjp1.

3095:
3096:
3097: --
3098: -- Extract the period level plan amounts for PA/GL/non time phased entries from budget lines
3099: -- for the primary RBS for this plan version into pji_fp_aggr_pjp1.
3100: -- EXTRACT_PLAN_AMOUNTS_PRIRBS
3101: PROCEDURE EXTRACT_PLAN_AMOUNTS_PRIRBS IS
3102: l_count NUMBER;
3103: l_max_project_id NUMBER := NULL;

Line 3119: INSERT INTO PJI_FP_AGGR_PJP1

3115:
3116:
3117:
3118:
3119: INSERT INTO PJI_FP_AGGR_PJP1
3120: (
3121: WORKER_ID
3122: , PROJECT_ID
3123: , PROJECT_ORG_ID

Line 3762: INSERT INTO PJI_FP_AGGR_PJP1

3758: RETURN;
3759: END IF;
3760:
3761:
3762: INSERT INTO PJI_FP_AGGR_PJP1
3763: (
3764: WORKER_ID
3765: , PROJECT_ID
3766: , PROJECT_ORG_ID

Line 4342: select rowid from pji_fp_aggr_pjp1

4338: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
4339: x_row_id row_id_tab_type;
4340:
4341: cursor c1 is
4342: select rowid from pji_fp_aggr_pjp1
4343: where worker_id = g_worker_id;
4344: -- Bug 7010864
4345: */
4346: BEGIN

Line 4359: tabname => 'PJI_FP_AGGR_PJP1',

4355:
4356: If x_row_id.count > 0 then
4357: -- gather statistics for PJI metadata tables
4358: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4359: tabname => 'PJI_FP_AGGR_PJP1',
4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:
4363: -- gather statistics for PJI metadata tables

Line 4529: pji_fp_aggr_pjp1 pjp1

4525: , pjp1.CUSTOM14
4526: , pjp1.CUSTOM15
4527: , pjp1.PLAN_TYPE_CODE
4528: FROM
4529: pji_fp_aggr_pjp1 pjp1
4530: WHERE 1=1
4531: AND worker_id = g_worker_id
4532: --AND pjp1.rowid = x_row_id(i) commented for bug 7497672
4533: ORDER BY

Line 4542: delete from pji_fp_aggr_pjp1

4538: , pjp1.RBS_VERSION_ID;
4539: /*commenting for bug 7497672
4540: -- Bug 7010864
4541: Forall j in x_row_id.first..x_row_id.last
4542: delete from pji_fp_aggr_pjp1
4543: where worker_id = g_worker_id
4544: and rowid = x_row_id(j);
4545:
4546: commit;

Line 4565: DELETE FROM pji_fp_aggr_pjp1

4561: MERGE_INTO_FP_FACT;
4562:
4563: ELSIF (p_slice_type = 'SEC') THEN
4564:
4565: DELETE FROM pji_fp_aggr_pjp1
4566: WHERE line_type = 'OF'
4567: AND worker_id = g_worker_id; -- Data in entered calendar should not be rolled up.
4568:
4569: MERGE_INTO_FP_FACT;

Line 4587: INSERT INTO pji_fp_aggr_pjp1

4583: , p_commit IN VARCHAR2 := 'F') IS
4584: BEGIN
4585:
4586: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST
4587: INSERT INTO pji_fp_aggr_pjp1
4588: (
4589: WORKER_ID
4590: , PROJECT_ID
4591: , PROJECT_ORG_ID

Line 5080: DELETE FROM pji_fp_aggr_pjp1

5076:
5077: PROCEDURE DELETE_DNGLRATE_PLNVER_DATA IS
5078: BEGIN
5079:
5080: DELETE FROM pji_fp_aggr_pjp1
5081: WHERE plan_version_id IN
5082: (
5083: SELECT DISTINCT plan_version_id
5084: FROM pji_fp_aggr_pjp1

Line 5084: FROM pji_fp_aggr_pjp1

5080: DELETE FROM pji_fp_aggr_pjp1
5081: WHERE plan_version_id IN
5082: (
5083: SELECT DISTINCT plan_version_id
5084: FROM pji_fp_aggr_pjp1
5085: WHERE worker_id = g_worker_id
5086: AND rate_dangling_flag IS NOT NULL )
5087: AND worker_id = g_worker_id;
5088:

Line 5427: pji_fp_aggr_pjp1 tmp

5423: g_worker_id WORKER_ID
5424: , rl.ROWID rl_rowid
5425: , tmp.ROWID TMP_ROWID
5426: FROM
5427: pji_fp_aggr_pjp1 tmp
5428: , pji_fp_xbs_accum_f rl
5429: WHERE 1 = 1
5430: -- Removed outer join for bug 5927368
5431: -- AND tmp.WORKER_ID = g_worker_id

Line 5680: , pji_fp_aggr_pjp1 tmp

5676: , l_last_updated_by
5677: , l_last_update_login
5678: FROM
5679: PJI_FP_RMAP_FPR rwid
5680: , pji_fp_aggr_pjp1 tmp
5681: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5682: WHERE 1 = 1
5683: AND tmp.rowid = rwid.tmp_rowid
5684: AND rl.rowid = rwid.rl_rowid

Line 5727: PJI_FP_AGGR_PJP1 pjp1_u

5723: BEGIN
5724:
5725: --Start of addition for bug 5927368
5726: update /*+ use_nl(pjp1_u) rowid(pjp1_u) */
5727: PJI_FP_AGGR_PJP1 pjp1_u
5728: set RECORD_TYPE = 'U'
5729: where ROWID in (select rwid.TMP_ROWID
5730: from PJI_FP_RMAP_FPR rwid
5731: where rwid.WORKER_ID = g_worker_id) and

Line 5962: pji_fp_aggr_pjp1 tmp

5958: ,tmp.PLAN_TYPE_CODE PLAN_TYPE_CODE /*4471527 */
5959: FROM
5960: --Commented for 5927368
5961: -- PJI_FP_RMAP_FPR rwid
5962: pji_fp_aggr_pjp1 tmp
5963: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5964: WHERE 1 = 1
5965: AND tmp.worker_id = g_worker_id
5966: --commented for 5927368 and added tmp.RECORD_TYPE <> 'U' condition

Line 6530: FROM pji_fp_aggr_pjp1

6526: SELECT plan_version_id
6527: , ( COUNT(DISTINCT time_dangling_flag)
6528: + COUNT(DISTINCT rate_dangling_flag)
6529: ) dangling
6530: FROM pji_fp_aggr_pjp1
6531: WHERE worker_id = g_worker_id
6532: GROUP BY plan_version_id
6533: ) b
6534: WHERE dangling > 2

Line 6548: FROM pji_fp_aggr_pjp1

6544: SELECT plan_version_id
6545: , ( COUNT(DISTINCT time_dangling_flag)
6546: + COUNT(DISTINCT rate_dangling_flag)
6547: ) dangling
6548: FROM pji_fp_aggr_pjp1
6549: WHERE worker_id = g_worker_id
6550: GROUP BY plan_version_id
6551: ) b
6552: WHERE dangling = 2

Line 6598: INSERT INTO pji_fp_aggr_pjp1

6594: PROCEDURE RETRIEVE_ENTERED_SLICE (
6595: p_pln_ver_id IN NUMBER := NULL ) IS
6596: BEGIN
6597:
6598: INSERT INTO pji_fp_aggr_pjp1
6599: (
6600: WORKER_ID
6601: , PROJECT_ID
6602: , PROJECT_ORG_ID

Line 6771: INSERT INTO pji_fp_aggr_pjp1

6767: -- l_worker_id NUMBER := 1;
6768:
6769: BEGIN
6770:
6771: INSERT INTO pji_fp_aggr_pjp1
6772: (
6773: WORKER_ID
6774: , PROJECT_ID
6775: , PROJECT_ORG_ID

Line 6923: FROM pji_fp_aggr_pjp1 fact1

6919: , SUM(fact1.CUSTOM15 )
6920: , fact1.line_type
6921: , g_default_prg_level
6922: ,fact1.PLAN_TYPE_CODE /*4471527 */
6923: FROM pji_fp_aggr_pjp1 fact1
6924: , Pji_RBS_DENORM rbs
6925: , pji_rollup_level_status smart
6926: , pji_pjp_rbs_header rhdr
6927: WHERE 1 = 1

Line 6975: INSERT INTO pji_fp_aggr_pjp1

6971: BEGIN
6972:
6973: print_time(' worker id is ... ' || 1);
6974:
6975: INSERT INTO pji_fp_aggr_pjp1
6976: (
6977: WORKER_ID
6978: , PROJECT_ID
6979: , PROJECT_ORG_ID

Line 7127: FROM pji_fp_aggr_pjp1 fact1

7123: , SUM(fact1.CUSTOM15 )
7124: , fact1.line_type
7125: , g_default_prg_level
7126: , fact1.plan_type_code
7127: FROM pji_fp_aggr_pjp1 fact1
7128: , pji_fm_extr_plnver4 ver3
7129: WHERE
7130: fact1.RBS_AGGR_LEVEL = g_lowest_level
7131: AND fact1.worker_id = g_worker_id

Line 7324: delete from pji_fp_aggr_pjp1_t; -- 5309891

7320: BEGIN
7321:
7322: print_time ( ' Before update wbs header ' );
7323:
7324: delete from pji_fp_aggr_pjp1_t; -- 5309891
7325:
7326: INSERT INTO pji_fp_aggr_pjp1_t
7327: ( WORKER_ID
7328: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID

Line 7326: INSERT INTO pji_fp_aggr_pjp1_t

7322: print_time ( ' Before update wbs header ' );
7323:
7324: delete from pji_fp_aggr_pjp1_t; -- 5309891
7325:
7326: INSERT INTO pji_fp_aggr_pjp1_t
7327: ( WORKER_ID
7328: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID
7329: , TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL
7330: , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG , CURR_RECORD_TYPE_ID ,CURRENCY_CODE

Line 7341: FROM PJI_FP_AGGR_PJP1 pjp1

7337: , whdr.plan_version_id, NVL(whdr.plan_type_id, -1)
7338: , whdr.PLAN_TYPE_CODE
7339: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
7340: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
7341: FROM PJI_FP_AGGR_PJP1 pjp1
7342: , pji_time_cal_period_v cal
7343: , pji_pjp_wbs_header whdr
7344: WHERE
7345: pjp1.worker_id = g_worker_id

Line 7367: FROM pji_fp_aggr_pjp1_t dates

7363: , end_date
7364: , l_last_update_date
7365: , l_last_updated_by
7366: , l_last_update_login
7367: FROM pji_fp_aggr_pjp1_t dates
7368: WHERE
7369: dates.plan_version_id = whdr.plan_version_id
7370: AND dates.project_id = whdr.project_id
7371: AND dates.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 7376: FROM PJI_FP_AGGR_PJP1_T ver

7372: AND dates.plan_type_code = whdr.plan_type_code
7373: )
7374: WHERE (project_id, NVL(plan_type_id, -1), plan_version_id, plan_type_code) IN (
7375: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
7376: FROM PJI_FP_AGGR_PJP1_T ver
7377: );
7378:
7379: delete from pji_fp_aggr_pjp1_t;
7380:

Line 7379: delete from pji_fp_aggr_pjp1_t;

7375: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
7376: FROM PJI_FP_AGGR_PJP1_T ver
7377: );
7378:
7379: delete from pji_fp_aggr_pjp1_t;
7380:
7381:
7382: print_time ( ' After update wbs header ' );
7383:

Line 7434: FROM pji_fp_aggr_pjp1 pjp1

7430: UPDATE PJI_FM_EXTR_PLNVER4 ver3
7431: SET time_dangling_flag = 'Y'
7432: WHERE (project_id,plan_version_id,plan_type_code) IN
7433: ( SELECT project_id,plan_version_id,plan_type_code /*4471527 */
7434: FROM pji_fp_aggr_pjp1 pjp1
7435: WHERE pjp1.worker_id = g_worker_id
7436: AND ( pjp1.time_dangling_flag IS NOT NULL
7437: OR pjp1.rate_dangling_flag IS NOT NULL )
7438: )

Line 7514: FROM pji_fp_aggr_pjp1

7510:
7511: /*
7512: select count(1)
7513: INTO l_count
7514: FROM pji_fp_aggr_pjp1
7515: WHERE wbs_rollup_flag = l_wbs_rollup_flag
7516: AND prg_rollup_flag = l_prg_rollup_flag;
7517:
7518: 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 7526: FROM pji_fp_aggr_pjp1

7522: l_prg_rollup_flag := 'Y';
7523:
7524: select count(1)
7525: INTO l_count
7526: FROM pji_fp_aggr_pjp1
7527: WHERE wbs_rollup_flag = l_wbs_rollup_flag
7528: AND prg_rollup_flag = l_prg_rollup_flag;
7529:
7530: 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 7538: FROM pji_fp_aggr_pjp1

7534: l_prg_rollup_flag := 'N';
7535:
7536: select count(1)
7537: INTO l_count
7538: FROM pji_fp_aggr_pjp1
7539: WHERE wbs_rollup_flag = l_wbs_rollup_flag
7540: AND prg_rollup_flag = l_prg_rollup_flag;
7541:
7542: 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 7550: FROM pji_fp_aggr_pjp1

7546: l_prg_rollup_flag := 'Y';
7547:
7548: select count(1)
7549: INTO l_count
7550: FROM pji_fp_aggr_pjp1
7551: WHERE wbs_rollup_flag = l_wbs_rollup_flag
7552: AND prg_rollup_flag = l_prg_rollup_flag;
7553:
7554: 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 7579: DELETE FROM pji_fp_aggr_pjp1

7575: WHERE worker_id = g_worker_id ;
7576:
7577: print_time('.......ver3 rows deleted: #= ' || sql%rowcount);
7578:
7579: DELETE FROM pji_fp_aggr_pjp1
7580: WHERE worker_id = g_worker_id;
7581:
7582: print_time('.......pjp1 rows deleted: #= ' || sql%rowcount);
7583:

Line 7629: INSERT INTO PJI_FP_AGGR_PJP1

7625: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
7626: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
7627: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
7628:
7629: INSERT INTO PJI_FP_AGGR_PJP1
7630: (
7631: WORKER_ID
7632: , PROJECT_ID
7633: , PROJECT_ORG_ID

Line 8794: INSERT INTO PJI_FP_AGGR_PJP1

8790: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
8791: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
8792: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
8793:
8794: INSERT INTO PJI_FP_AGGR_PJP1
8795: (
8796: WORKER_ID
8797: , PROJECT_ID
8798: , PROJECT_ORG_ID

Line 9911: INSERT INTO PJI_FP_AGGR_PJP1

9907: BEGIN
9908:
9909: print_time ( ' EXTRACT_DANGL_REVERSAL begin. ' );
9910:
9911: INSERT INTO PJI_FP_AGGR_PJP1
9912: (
9913: WORKER_ID
9914: , PROJECT_ID
9915: , PROJECT_ORG_ID

Line 10122: INSERT INTO PJI_FP_AGGR_PJP1

10118: RETURN;
10119: END IF;
10120:
10121:
10122: INSERT INTO PJI_FP_AGGR_PJP1
10123: (
10124: WORKER_ID
10125: , PRG_LEVEL
10126: , PROJECT_ID

Line 10688: INSERT INTO PJI_FP_AGGR_PJP1

10684: RETURN;
10685: END IF;
10686:
10687:
10688: INSERT INTO PJI_FP_AGGR_PJP1
10689: (
10690: WORKER_ID
10691: , PROJECT_ID
10692: , PROJECT_ORG_ID

Line 11150: FROM PJI_FP_AGGR_PJP1 pjp1

11146: , pjp1.plan_version_id, NVL(pjp1.plan_type_id, -1) plan_type_id
11147: , pjp1.PLAN_TYPE_CODE
11148: , cal.start_date min_txn_date
11149: , cal.end_date max_txn_date
11150: FROM PJI_FP_AGGR_PJP1 pjp1
11151: , pji_time_cal_period_v cal
11152: WHERE
11153: pjp1.worker_id = p_worker_id
11154: AND pjp1.time_id = cal.cal_period_id

Line 11224: select rowid from pji_fp_aggr_pjp1

11220: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
11221: x_row_id row_id_tab_type;
11222:
11223: cursor c1 is
11224: select rowid from pji_fp_aggr_pjp1
11225: where worker_id = g_worker_id;
11226: BEGIN
11227:
11228: print_time ( 'SAM MERGE_INTO_FP_FACTS worker id..' || g_worker_id || ' sysdate ' || sysdate) ;

Line 11239: tabname => 'PJI_FP_AGGR_PJP1',

11235:
11236: If x_row_id.count > 0 then
11237: -- gather statistics for PJI metadata tables
11238: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11239: tabname => 'PJI_FP_AGGR_PJP1',
11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:
11243: -- gather statistics for PJI metadata tables

Line 11389: FROM pji_fp_aggr_pjp1 tmp

11385: , tmp.CUSTOM13
11386: , tmp.CUSTOM14
11387: , tmp.CUSTOM15
11388: , tmp.PLAN_TYPE_CODE
11389: FROM pji_fp_aggr_pjp1 tmp
11390: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
11391: WHERE 1 = 1
11392: AND tmp.worker_id = g_worker_id
11393: AND tmp.project_id = ver3.project_id

Line 11639: delete from pji_fp_aggr_pjp1

11635:
11636: print_time ( 'SAM MERGE_INTO_FP_FACTS worker id..' || g_worker_id || 'row count ' || SQL%ROWCOUNT) ;
11637:
11638: Forall j in x_row_id.first..x_row_id.last
11639: delete from pji_fp_aggr_pjp1
11640: where worker_id = g_worker_id
11641: and rowid = x_row_id(j);
11642:
11643: commit;