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_TIME_C

Line 1485: , pji_time.cal_period_id) time_id

1481: , plr.project_ORGANIZATION_ID
1482: , plr.WBS_ELEMENT_ID
1483: , DECODE(vers.time_phased_type_code
1484: , 'N', -1
1485: , pji_time.cal_period_id) time_id
1486: , DECODE(vers.time_phased_type_code
1487: , g_pa_cal_str, 32
1488: , g_gl_cal_str, 32
1489: , 'N', 2048

Line 1666: , spread_bl.RESOURCE_CLASS -- , spread_bl.CALENDAR_TYPE -- , pji_time.CALENDAR_ID

1662: , spread_bl.WBS_STRUCT_VERSION_ID
1663: , spread_bl.RBS_STRUCT_VERSION_ID
1664: , spread_bl.plan_type_id
1665: , spread_bl.BILLABLE_FLAG
1666: , spread_bl.RESOURCE_CLASS -- , spread_bl.CALENDAR_TYPE -- , pji_time.CALENDAR_ID
1667: , spread_bl.PROJECT_ORGANIZATION_ID
1668: , spread_bl.PROJECT_ORG_ID
1669: , spread_bl.TIME_PHASED_TYPE_CODE
1670: , DECODE( invert.INVERT_ID

Line 1833: , pji_time_cal_period_v pji_time

1829: ) plr
1830: ---- End of first inline view plr ..........
1831: , PJI_ORG_EXTR_INFO orginfo
1832: , PJI_FM_EXTR_PLNVER3_T vers
1833: , pji_time_cal_period_v pji_time
1834: WHERE 1=1
1835: -- AND orginfo.projfunc_currency_mau is not NULL
1836: AND plr.project_org_id = orginfo.org_id
1837: AND plr.project_id = vers.project_id

Line 1843: , -l_max_plnver_id ) = pji_time.calendar_id

1839: AND plr.plan_type_code = vers.plan_type_code /*4471527 */
1840: AND DECODE(vers.time_phased_type_code
1841: , g_pa_cal_str, orginfo.pa_calendar_id
1842: , g_gl_cal_str, orginfo.gl_calendar_id
1843: , -l_max_plnver_id ) = pji_time.calendar_id
1844: AND plr.period_name = pji_time.name
1845: AND vers.time_phased_type_code IN (g_pa_cal_str, g_gl_cal_str, 'N')
1846: GROUP BY
1847: plr.PROJECT_ID

Line 1853: , pji_time.cal_period_id)

1849: , plr.project_ORGANIZATION_ID
1850: , plr.WBS_ELEMENT_ID
1851: , DECODE(vers.time_phased_type_code
1852: , 'N', -1
1853: , pji_time.cal_period_id)
1854: --bug# 3886087 (put the below two decodes in sync with the ones in select stmt)
1855: , DECODE(vers.time_phased_type_code
1856: , g_pa_cal_str, 32
1857: , g_gl_cal_str, 32

Line 2545: , pji_time_cal_period_v prd

2541: , PJI_FM_EXTR_PLNVER3_T ver
2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2544: , PJI_FM_AGGR_DLY_RATES_T rates
2545: , pji_time_cal_period_v prd
2546: , PJI_ORG_EXTR_INFO oei
2547: , pji_fp_txn_accum_header hdr
2548: , pa_rbs_txn_accum_map map
2549: , pji_pjp_rbs_header rhdr

Line 2848: -- , pji_time_cal_period prd

2844: , PJI_FM_EXTR_PLNVER3_T ver
2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2847: , PJI_FM_AGGR_DLY_RATES_T rates
2848: -- , pji_time_cal_period prd
2849: -- , PJI_ORG_EXTR_INFO oei
2850: , pji_fp_txn_accum_header hdr
2851: , pa_rbs_txn_accum_map map
2852: , pji_pjp_rbs_header rhdr

Line 3589: , pji_time_cal_period_v prd

3585: , PJI_FM_EXTR_PLNVER3_T ver
3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3588: , PJI_FM_AGGR_DLY_RATES_T rates
3589: , pji_time_cal_period_v prd
3590: , PJI_ORG_EXTR_INFO oei
3591: WHERE 1=1
3592: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3593: AND ra.project_id = ver.PROJECT_ID

Line 4542: , pji_time.cal_period_id) time_id

4538: , plr.project_ORGANIZATION_ID
4539: , plr.WBS_ELEMENT_ID
4540: , DECODE(plr.time_phased_type_code -- change from vers to plr for bug 4604617
4541: , 'N', -1
4542: , pji_time.cal_period_id) time_id
4543: , DECODE(plr.time_phased_type_code
4544: , g_pa_cal_str, 32
4545: , g_gl_cal_str, 32
4546: , 'N', 2048) period_type_id -- period type id...

Line 4736: -- , pji_time.CALENDAR_ID

4732: , spread_bl.plan_type_id
4733: , spread_bl.BILLABLE_FLAG
4734: , spread_bl.RESOURCE_CLASS
4735: -- , spread_bl.CALENDAR_TYPE
4736: -- , pji_time.CALENDAR_ID
4737: , spread_bl.PROJECT_ORGANIZATION_ID
4738: , spread_bl.PROJECT_ORG_ID
4739: , spread_bl.TIME_PHASED_TYPE_CODE
4740: , DECODE( invert.INVERT_ID

Line 4901: , pji_time_cal_period_v pji_time

4897: ) plr
4898: ---- End of first inline view plr ..........
4899: , PJI_ORG_EXTR_INFO orginfo
4900: , PJI_FM_EXTR_PLNVER3_T vers
4901: , pji_time_cal_period_v pji_time
4902: WHERE 1=1
4903: AND plr.project_org_id = orginfo.org_id
4904: AND plr.project_id = vers.project_id
4905: AND plr.budget_version_id = vers.plan_version_id

Line 4910: , -l_max_plnver_id ) = pji_time.calendar_id

4906: AND plr.plan_type_code = vers.plan_type_code /*4471527 */
4907: AND DECODE(plr.time_phased_type_code -- change from vers to plr for bug 4604617
4908: , g_pa_cal_str, orginfo.pa_calendar_id
4909: , g_gl_cal_str, orginfo.gl_calendar_id
4910: , -l_max_plnver_id ) = pji_time.calendar_id
4911: AND plr.period_name = pji_time.name
4912: AND plr.time_phased_type_code IN (g_pa_cal_str, g_gl_cal_str, 'N')
4913: GROUP BY
4914: plr.PROJECT_ID

Line 4918: , pji_time.cal_period_id)

4914: plr.PROJECT_ID
4915: , plr.WBS_ELEMENT_ID
4916: , DECODE(plr.time_phased_type_code
4917: , 'N', -1
4918: , pji_time.cal_period_id)
4919: , DECODE(plr.time_phased_type_code
4920: , g_pa_cal_str, 32
4921: , g_gl_cal_str, 32
4922: , 'N', 2048) -- period type id...

Line 5116: , pji_time_cal_period_v prd

5112: , l_gl1_mau mau1
5113: , l_gl2_mau mau2
5114: FROM pa_budget_lines bl
5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa
5119: ,PJI_ORG_EXTR_INFO inf
5120: WHERE bl.budget_version_id = ver.plan_version_id

Line 5176: pji_time_cal_period_v prd,

5172: SET rate_dangling_flag = 'Y'
5173: WHERE (project_id,plan_version_id) IN
5174: ( SELECT project_id,budget_version_id
5175: FROM PA_BUDGET_LINES bl,
5176: pji_time_cal_period_v prd,
5177: PJI_FM_AGGR_DLY_RATES_T rates
5178: WHERE rates.time_id=prd.cal_period_id
5179: AND bl.period_name = prd.name
5180: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

Line 5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5789: ) curr
5790: , PJI_FM_AGGR_DLY_RATES_T rates
5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5792: UNION ALL
5793: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5794: ) dates
5795: , pji_fm_extr_plnver3_t ver

Line 5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5901: ) curr
5902: , PJI_FM_AGGR_DLY_RATES_T rates
5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5904: UNION ALL
5905: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5906: ) dates
5907: , pji_fm_extr_plnver3_t ver

Line 6208: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

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
6211: UNION ALL
6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v

Line 6210: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v

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
6211: UNION ALL
6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6213: UNION ALL
6214: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

Line 6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v

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
6211: UNION ALL
6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6213: UNION ALL
6214: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6215: UNION ALL
6216: SELECT ent_qtr_id, start_date, end_date FROM pji_time_ent_qtr

Line 6771: , pji_time.cal_period_id) time_id

6767: , plr.project_ORGANIZATION_ID
6768: , plr.WBS_ELEMENT_ID project_element_id
6769: , DECODE(vers.time_phased_type_code
6770: , 'N', -1
6771: , pji_time.cal_period_id) time_id
6772: , DECODE(vers.time_phased_type_code
6773: , 'P', 32
6774: , 'G', 32
6775: , 'N', 2048) period_type_id -- period type id...

Line 7182: , pji_time_cal_period_v pji_time

7178: ) plr
7179: ---- End of first inline view plr ..........
7180: , PJI_ORG_EXTR_INFO orginfo
7181: , PJI_FM_EXTR_PLNVER3_T vers
7182: , pji_time_cal_period_v pji_time
7183: WHERE 1=1
7184: AND plr.project_org_id = orginfo.org_id
7185: AND plr.project_id = vers.project_id
7186: AND plr.budget_version_id = vers.plan_version_id

Line 7192: = pji_time.calendar_id

7188: AND DECODE(vers.time_phased_type_code
7189: , 'P', orginfo.pa_calendar_id
7190: , 'G', orginfo.gl_calendar_id
7191: , - l_max_plnver_id )
7192: = pji_time.calendar_id
7193: AND plr.period_name = pji_time.name
7194: AND vers.time_phased_type_code IN ('P', 'G', 'N')
7195: GROUP BY
7196: plr.PROJECT_ID

Line 7200: , pji_time.cal_period_id)

7196: plr.PROJECT_ID
7197: , plr.WBS_ELEMENT_ID
7198: , DECODE(vers.time_phased_type_code
7199: , 'N', -1
7200: , pji_time.cal_period_id)
7201: , DECODE(vers.time_phased_type_code
7202: , 'P', 32
7203: , 'G', 32
7204: , 'N', 2048) -- period type id...

Line 9119: , pji_time_cal_period_v cal

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
9123: AND pjp1.project_id = whdr.project_id

Line 9154: , pji_time_cal_period_v time

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
9158: AND fact.calendar_type = 'P'

Line 9168: , pji_time_cal_period_v time

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
9172: AND fact.calendar_type = 'G'

Line 9494: INSERT INTO pji_time_cal_period

9490: END IF;
9491:
9492: print_time (' Inside INSERT_NTP_CAL_RECORD, max project_id is: ' || x_max_plnver_id);
9493:
9494: INSERT INTO pji_time_cal_period
9495: (
9496: CAL_PERIOD_ID,
9497: CAL_QTR_ID,
9498: CALENDAR_ID,

Line 9538: DELETE FROM pji_time_cal_period

9534: BEGIN
9535:
9536: print_time (' DELETE_NTP_CAL_RECORD, max project_id is: ' || p_max_plnver_id);
9537:
9538: DELETE FROM pji_time_cal_period
9539: WHERE cal_period_id = -p_max_plnver_id;
9540:
9541: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
9542:

Line 9607: PJI_TIME_C.LOAD(

9603:
9604: print_time( ' i.period_set_name = ' || i.period_set_name );
9605: print_time( ' i.period_type = ' || i.period_type);
9606:
9607: PJI_TIME_C.LOAD(
9608: p_period_set_name => i.period_set_name
9609: , p_period_type => i.period_type
9610: , x_return_status => l_return_status
9611: , x_msg_count => l_msg_count