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_TIME_CAL_PERIOD

Line 4357: , pji_time.cal_period_id) time_id

4353: , plr.project_ORGANIZATION_ID
4354: , plr.WBS_ELEMENT_ID
4355: , DECODE(plr.time_phased_type_code
4356: , 'N', -1
4357: , pji_time.cal_period_id) time_id
4358:
4359: , DECODE(plr.time_phased_type_code
4360: , 'P', 32
4361: , 'G', 32

Line 4714: , pji_time_cal_period_v pji_time

4710: , collapse_bl.WP_FLAG
4711: ) plr
4712: ---- End of first inline view plr ..........
4713: , PJI_ORG_EXTR_INFO orginfo
4714: , pji_time_cal_period_v pji_time
4715: WHERE 1=1
4716: -- AND orginfo.projfunc_currency_mau is not NULL
4717: AND plr.project_org_id = orginfo.org_id
4718: AND DECODE(plr.time_phased_type_code

Line 4730: , pji_time.cal_period_id)

4726: , plr.project_ORGANIZATION_ID
4727: , plr.WBS_ELEMENT_ID
4728: , DECODE(plr.time_phased_type_code
4729: , 'N', -1
4730: , pji_time.cal_period_id)
4731: , DECODE(plr.time_phased_type_code
4732: , 'P', 32
4733: , 'G', 32
4734: , 'N', 2048

Line 5017: , pji_time.cal_period_id) time_id

5013: , plr.project_ORGANIZATION_ID
5014: , plr.WBS_ELEMENT_ID project_element_id
5015: , DECODE(plr.time_phased_type_code
5016: , 'N', -1
5017: , pji_time.cal_period_id) time_id
5018: , DECODE(plr.time_phased_type_code
5019: , 'P', 32
5020: , 'G', 32
5021: , 'N', 2048

Line 5387: , pji_time_cal_period_v pji_time

5383: , collapse_bl.time_phased_type_code
5384: ) plr
5385: ---- End of first inline view plr ..........
5386: , PJI_ORG_EXTR_INFO orginfo
5387: , pji_time_cal_period_v pji_time
5388: WHERE 1=1
5389: -- AND orginfo.projfunc_currency_mau is not NULL
5390: AND plr.project_org_id = orginfo.org_id
5391: AND DECODE(plr.time_phased_type_code

Line 5403: , pji_time.cal_period_id)

5399: , plr.project_ORGANIZATION_ID
5400: , plr.WBS_ELEMENT_ID
5401: , DECODE(plr.time_phased_type_code
5402: , 'N', -1
5403: , pji_time.cal_period_id)
5404: , DECODE(plr.time_phased_type_code
5405: , 'P', 32
5406: , 'G', 32
5407: , 'N', 2048

Line 6134: , pji_time_cal_period_v prd

6130: , prd.end_date
6131: , TO_DATE(NULL)
6132: ) end_date
6133: FROM pa_budget_lines bl
6134: , pji_time_cal_period_v prd
6135: , PJI_FM_EXTR_PLNVER4 ver
6136: , pa_projects_all ppa
6137: ,PJI_ORG_EXTR_INFO inf
6138: WHERE 1=1

Line 6187: UPDATE /+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) /

6183: ) temp;
6184:
6185: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
6186:
6187: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
6188: PJI_FM_EXTR_PLNVER4 ver
6189: SET rate_dangling_flag = 'Y'
6190: WHERE (project_id,plan_version_id) IN
6191: ( SELECT project_id,budget_version_id

Line 6193: pji_time_cal_period_v prd,

6189: SET rate_dangling_flag = 'Y'
6190: WHERE (project_id,plan_version_id) IN
6191: ( SELECT project_id,budget_version_id
6192: FROM PA_BUDGET_LINES bl,
6193: pji_time_cal_period_v prd,
6194: PJI_FM_AGGR_DLY_RATES rates
6195: WHERE rates.time_id=prd.cal_period_id
6196: AND bl.period_name = prd.name
6197: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

Line 8569: , pji_time_cal_period_v cal

8565: , whdr.PLAN_TYPE_CODE
8566: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
8567: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
8568: FROM PJI_FP_AGGR_PJP1 pjp1
8569: , pji_time_cal_period_v cal
8570: , pji_pjp_wbs_header whdr
8571: WHERE
8572: pjp1.worker_id = g_worker_id
8573: AND pjp1.project_id = whdr.project_id

Line 9614: , pji_time_cal_period_v prd

9610: , PA_BUDGET_LINES bl
9611: , pa_projects_all ppa
9612: , PJI_ORG_EXTR_INFO oei
9613: , pji_pjp_rbs_header rhdr
9614: , pji_time_cal_period_v prd
9615: , PJI_FM_AGGR_DLY_RATES rates
9616: , pji_fp_txn_accum_header hdr
9617: , pa_rbs_txn_accum_map map
9618: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 10802: , pji_time_cal_period_v prd

10798: , pa_resource_asSIGNments ra
10799: , PA_BUDGET_LINES bl
10800: , pa_projects_all ppa
10801: , PJI_ORG_EXTR_INFO oei
10802: , pji_time_cal_period_v prd
10803: , PJI_FM_AGGR_DLY_RATES rates
10804: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10805: WHERE 1=1
10806: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 11537: , pji_time.cal_period_id) time_id

11533: , plr.project_ORGANIZATION_ID
11534: , plr.WBS_ELEMENT_ID
11535: , DECODE(plr.time_phased_type_code
11536: , 'N', -1
11537: , pji_time.cal_period_id) time_id
11538: , DECODE(plr.time_phased_type_code
11539: , 'P', 32
11540: , 'G', 32
11541: , 'N', 2048

Line 11836: , pji_time_cal_period_v pji_time

11832: ,collapse_bl.plan_type_code
11833: ) plr
11834: ---- End of first inline view plr ..........
11835: , PJI_ORG_EXTR_INFO orginfo
11836: , pji_time_cal_period_v pji_time
11837: WHERE 1=1
11838: -- AND orginfo.projfunc_currency_mau is not TO_NUMBER(NULL
11839: AND plr.project_org_id = orginfo.org_id
11840: AND DECODE(plr.time_phased_type_code

Line 11852: , pji_time.cal_period_id)

11848: , plr.project_ORGANIZATION_ID
11849: , plr.WBS_ELEMENT_ID
11850: , DECODE(plr.time_phased_type_code
11851: , 'N', -1
11852: , pji_time.cal_period_id)
11853: , DECODE(plr.time_phased_type_code
11854: , 'P', 32
11855: , 'G', 32
11856: , 'N', 2048

Line 11917: INSERT INTO pji_time_cal_period

11913:
11914: print_time (' Inside INSERT_NTP_CAL_RECORD, max project_id is: ' || x_max_project_id);
11915:
11916:
11917: INSERT INTO pji_time_cal_period
11918: (
11919: CAL_PERIOD_ID,
11920: CAL_QTR_ID,
11921: CALENDAR_ID,

Line 11961: DELETE FROM pji_time_cal_period

11957: BEGIN
11958:
11959: print_time (' DELETE_NTP_CAL_RECORD, max project_id is: ' || p_max_project_id);
11960:
11961: DELETE FROM pji_time_cal_period
11962: WHERE cal_period_id = -p_max_project_id;
11963:
11964: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
11965:

Line 12126: , pji_time.cal_period_id) time_id

12122: , plr.project_ORGANIZATION_ID
12123: , plr.WBS_ELEMENT_ID project_element_id
12124: , DECODE(plr.time_phased_type_code
12125: , 'N', -1
12126: , pji_time.cal_period_id) time_id
12127: , DECODE(plr.time_phased_type_code
12128: , 'P', 32
12129: , 'G', 32
12130: , 'N', 2048

Line 12431: , pji_time_cal_period_v pji_time

12427: , collapse_bl.time_phased_type_code
12428: ) plr
12429: ---- End of first inline view plr ..........
12430: , PJI_ORG_EXTR_INFO orginfo
12431: , pji_time_cal_period_v pji_time
12432: WHERE 1=1
12433: -- AND orginfo.projfunc_currency_mau is not NULL
12434: AND plr.project_org_id = orginfo.org_id
12435: AND DECODE(plr.time_phased_type_code

Line 12447: , pji_time.cal_period_id)

12443: , plr.project_ORGANIZATION_ID
12444: , plr.WBS_ELEMENT_ID
12445: , DECODE(plr.time_phased_type_code
12446: , 'N', -1
12447: , pji_time.cal_period_id)
12448: , DECODE(plr.time_phased_type_code
12449: , 'P', 32
12450: , 'G', 32
12451: , 'N', 2048

Line 12508: , pji_time_cal_period_v cal

12504: , pjp1.PLAN_TYPE_CODE
12505: , cal.start_date min_txn_date
12506: , cal.end_date max_txn_date
12507: FROM PJI_FP_AGGR_PJP1 pjp1
12508: , pji_time_cal_period_v cal
12509: WHERE
12510: pjp1.worker_id = p_worker_id
12511: AND pjp1.time_id = cal.cal_period_id
12512: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.