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 1525: , pji_time.cal_period_id) time_id /* Modified for bug 9048716 */

1521: , plr.project_ORGANIZATION_ID
1522: , plr.WBS_ELEMENT_ID
1523: , decode(vers.time_phased_type_code
1524: , 'N', -1
1525: , pji_time.cal_period_id) time_id /* Modified for bug 9048716 */
1526: , decode(vers.time_phased_type_code
1527: , g_pa_cal_str, 32
1528: , g_gl_cal_str, 32
1529: , 'N', 2048

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

1702: , spread_bl.WBS_STRUCT_VERSION_ID
1703: , spread_bl.RBS_STRUCT_VERSION_ID
1704: , spread_bl.plan_type_id
1705: , spread_bl.BILLABLE_FLAG
1706: , spread_bl.RESOURCE_CLASS -- , spread_bl.CALENDAR_TYPE -- , pji_time.CALENDAR_ID
1707: , spread_bl.PROJECT_ORGANIZATION_ID
1708: , spread_bl.PROJECT_ORG_ID
1709: , spread_bl.TIME_PHASED_TYPE_CODE
1710: , DECODE( invert.INVERT_ID

Line 1875: , pji_time_cal_period_v pji_time

1871: ) plr
1872: ---- End of first inline view plr ..........
1873: , PJI_ORG_EXTR_INFO orginfo
1874: , PJI_FM_EXTR_PLNVER3_T vers
1875: , pji_time_cal_period_v pji_time
1876: WHERE 1=1
1877: -- AND orginfo.projfunc_currency_mau is not NULL
1878: AND plr.project_org_id = orginfo.org_id
1879: AND plr.project_id = vers.project_id

Line 1885: , -l_max_plnver_id ) = pji_time.calendar_id

1881: AND plr.plan_type_code = vers.plan_type_code /*4471527 */
1882: AND DECODE(vers.time_phased_type_code
1883: , g_pa_cal_str, orginfo.pa_calendar_id
1884: , g_gl_cal_str, orginfo.gl_calendar_id
1885: , -l_max_plnver_id ) = pji_time.calendar_id
1886: AND plr.period_name = pji_time.name
1887: AND vers.time_phased_type_code IN (g_pa_cal_str, g_gl_cal_str, 'N')
1888: GROUP BY
1889: plr.PROJECT_ID

Line 1895: , pji_time.cal_period_id) /* Modified for bug 9048716 */

1891: , plr.project_ORGANIZATION_ID
1892: , plr.WBS_ELEMENT_ID
1893: , decode(vers.time_phased_type_code
1894: , 'N', -1
1895: , pji_time.cal_period_id) /* Modified for bug 9048716 */
1896: , decode(vers.time_phased_type_code
1897: , g_pa_cal_str, 32
1898: , g_gl_cal_str, 32
1899: , 'N', 2048

Line 2612: , pji_time_cal_period_v prd

2608: , PJI_FM_EXTR_PLNVER3_T ver
2609: , pa_projects_all ppa
2610: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2611: , PJI_FM_AGGR_DLY_RATES_T rates
2612: , pji_time_cal_period_v prd
2613: , PJI_ORG_EXTR_INFO oei
2614: , pji_fp_txn_accum_header hdr
2615: , pa_rbs_txn_accum_map map
2616: , pji_pjp_rbs_header rhdr

Line 2918: -- , pji_time_cal_period prd

2914: , PJI_FM_EXTR_PLNVER3_T ver
2915: , pa_projects_all ppa
2916: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2917: , PJI_FM_AGGR_DLY_RATES_T rates
2918: -- , pji_time_cal_period prd
2919: -- , PJI_ORG_EXTR_INFO oei
2920: , pji_fp_txn_accum_header hdr
2921: , pa_rbs_txn_accum_map map
2922: , pji_pjp_rbs_header rhdr

Line 3673: , pji_time_cal_period_v prd

3669: , PJI_FM_EXTR_PLNVER3_T ver
3670: , pa_projects_all ppa
3671: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3672: , PJI_FM_AGGR_DLY_RATES_T rates
3673: , pji_time_cal_period_v prd
3674: , PJI_ORG_EXTR_INFO oei
3675: WHERE 1=1
3676: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3677: AND ra.project_id = ver.PROJECT_ID

Line 4640: , pji_time.cal_period_id) time_id /* Modified for bug 9048716 */

4636: , plr.project_ORGANIZATION_ID
4637: , plr.WBS_ELEMENT_ID
4638: , decode(plr.time_phased_type_code -- change from vers to plr for bug 4604617
4639: , 'N', -1
4640: , pji_time.cal_period_id) time_id /* Modified for bug 9048716 */
4641: , decode(vers.time_phased_type_code
4642: , g_pa_cal_str, 32
4643: , g_gl_cal_str, 32
4644: , 'N', 2048

Line 4835: -- , pji_time.CALENDAR_ID

4831: , spread_bl.plan_type_id
4832: , spread_bl.BILLABLE_FLAG
4833: , spread_bl.RESOURCE_CLASS
4834: -- , spread_bl.CALENDAR_TYPE
4835: -- , pji_time.CALENDAR_ID
4836: , spread_bl.PROJECT_ORGANIZATION_ID
4837: , spread_bl.PROJECT_ORG_ID
4838: , spread_bl.TIME_PHASED_TYPE_CODE
4839: , DECODE( invert.INVERT_ID

Line 5000: , pji_time_cal_period_v pji_time

4996: ) plr
4997: ---- End of first inline view plr ..........
4998: , PJI_ORG_EXTR_INFO orginfo
4999: , PJI_FM_EXTR_PLNVER3_T vers
5000: , pji_time_cal_period_v pji_time
5001: WHERE 1=1
5002: AND plr.project_org_id = orginfo.org_id
5003: AND plr.project_id = vers.project_id
5004: AND plr.budget_version_id = vers.plan_version_id

Line 5009: , -l_max_plnver_id ) = pji_time.calendar_id

5005: AND plr.plan_type_code = vers.plan_type_code /*4471527 */
5006: AND DECODE(plr.time_phased_type_code -- change from vers to plr for bug 4604617
5007: , g_pa_cal_str, orginfo.pa_calendar_id
5008: , g_gl_cal_str, orginfo.gl_calendar_id
5009: , -l_max_plnver_id ) = pji_time.calendar_id
5010: AND plr.period_name = pji_time.name
5011: AND plr.time_phased_type_code IN (g_pa_cal_str, g_gl_cal_str, 'N')
5012: GROUP BY
5013: plr.PROJECT_ID

Line 5017: , pji_time.cal_period_id) /* Modified for bug 9048716 */

5013: plr.PROJECT_ID
5014: , plr.WBS_ELEMENT_ID
5015: , decode(plr.time_phased_type_code
5016: , 'N', -1
5017: , pji_time.cal_period_id) /* Modified for bug 9048716 */
5018: , decode(vers.time_phased_type_code
5019: , g_pa_cal_str, 32
5020: , g_gl_cal_str, 32
5021: , 'N', 2048

Line 5216: , pji_time_cal_period_v prd

5212: , l_gl1_mau mau1
5213: , l_gl2_mau mau2
5214: FROM pa_budget_lines bl
5215: , pa_budget_versions bv -- added for bug 5842896
5216: , pji_time_cal_period_v prd
5217: , PJI_FM_EXTR_PLNVER3_T ver
5218: , pa_projects_all ppa
5219: ,PJI_ORG_EXTR_INFO inf
5220: WHERE bl.budget_version_id = ver.plan_version_id

Line 5277: pji_time_cal_period_v prd,

5273: SET rate_dangling_flag = 'Y'
5274: WHERE (project_id,plan_version_id) IN
5275: ( SELECT project_id,budget_version_id
5276: FROM PA_BUDGET_LINES bl,
5277: pji_time_cal_period_v prd,
5278: PJI_FM_AGGR_DLY_RATES_T rates
5279: WHERE rates.time_id=prd.cal_period_id
5280: AND bl.period_name = prd.name
5281: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

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

5888: UNION
5889: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5890: ) curr
5891: , PJI_FM_AGGR_DLY_RATES_T rates
5892: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5893: UNION ALL
5894: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5895: ) dates
5896: , pji_fm_extr_plnver3_t ver

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

6000: UNION
6001: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
6002: ) curr
6003: , PJI_FM_AGGR_DLY_RATES_T rates
6004: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6005: UNION ALL
6006: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6007: ) dates
6008: , pji_fm_extr_plnver3_t ver

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

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

Line 6311: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v

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
6312: UNION ALL
6313: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6314: UNION ALL
6315: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

Line 6313: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v

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
6312: UNION ALL
6313: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6314: UNION ALL
6315: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6316: UNION ALL
6317: SELECT ent_qtr_id, start_date, end_date FROM pji_time_ent_qtr

Line 6896: , pji_time.cal_period_id) time_id

6892: , plr.project_ORGANIZATION_ID
6893: , plr.WBS_ELEMENT_ID project_element_id
6894: , DECODE(vers.time_phased_type_code
6895: , 'N', -1
6896: , pji_time.cal_period_id) time_id
6897: , DECODE(vers.time_phased_type_code
6898: , 'P', 32
6899: , 'G', 32
6900: , 'N', 2048) period_type_id -- period type id...

Line 7315: , pji_time_cal_period_v pji_time

7311: ) plr
7312: ---- End of first inline view plr ..........
7313: , PJI_ORG_EXTR_INFO orginfo
7314: , PJI_FM_EXTR_PLNVER3_T vers
7315: , pji_time_cal_period_v pji_time
7316: WHERE 1=1
7317: AND plr.project_org_id = orginfo.org_id
7318: AND plr.project_id = vers.project_id
7319: AND plr.budget_version_id = vers.plan_version_id

Line 7325: = pji_time.calendar_id

7321: AND DECODE(vers.time_phased_type_code
7322: , 'P', orginfo.pa_calendar_id
7323: , 'G', orginfo.gl_calendar_id
7324: , - l_max_plnver_id )
7325: = pji_time.calendar_id
7326: AND plr.period_name = pji_time.name
7327: AND vers.time_phased_type_code IN ('P', 'G', 'N')
7328: GROUP BY
7329: plr.PROJECT_ID

Line 7333: , pji_time.cal_period_id)

7329: plr.PROJECT_ID
7330: , plr.WBS_ELEMENT_ID
7331: , DECODE(vers.time_phased_type_code
7332: , 'N', -1
7333: , pji_time.cal_period_id)
7334: , DECODE(vers.time_phased_type_code
7335: , 'P', 32
7336: , 'G', 32
7337: , 'N', 2048) -- period type id...

Line 9267: , pji_time_cal_period_v cal

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

Line 9309: , pji_time_cal_period_v time

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

Line 9323: , pji_time_cal_period_v time

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

Line 9649: INSERT INTO pji_time_cal_period

9645: END IF;
9646:
9647: print_time (' Inside INSERT_NTP_CAL_RECORD, max project_id is: ' || x_max_plnver_id);
9648:
9649: INSERT INTO pji_time_cal_period
9650: (
9651: CAL_PERIOD_ID,
9652: CAL_QTR_ID,
9653: CALENDAR_ID,

Line 9693: DELETE FROM pji_time_cal_period

9689: BEGIN
9690:
9691: print_time (' DELETE_NTP_CAL_RECORD, max project_id is: ' || p_max_plnver_id);
9692:
9693: DELETE FROM pji_time_cal_period
9694: WHERE cal_period_id = -p_max_plnver_id;
9695:
9696: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
9697:

Line 9762: PJI_TIME_C.LOAD(

9758:
9759: print_time( ' i.period_set_name = ' || i.period_set_name );
9760: print_time( ' i.period_type = ' || i.period_type);
9761:
9762: PJI_TIME_C.LOAD(
9763: p_period_set_name => i.period_set_name
9764: , p_period_type => i.period_type
9765: , x_return_status => l_return_status
9766: , x_msg_count => l_msg_count