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_XBS_ACCUM_UTILS dependencies on PJI_FM_XBS_ACCUM_TMP1

Line 26: INSERT INTO pji_fm_xbs_accum_tmp1_debug

22: /* added procedure for bug#3993830 */
23: PROCEDURE debug_accum
24: IS
25: BEGIN
26: INSERT INTO pji_fm_xbs_accum_tmp1_debug
27: (
28: PROJECT_ID ,
29: STRUCT_VERSION_ID ,
30: PROJECT_ELEMENT_ID ,

Line 269: pji_fm_xbs_accum_tmp1 ;

265: LPB_EQUIP_HOURS ,
266: PERIOD_FLAG ,
267: SYSDATE
268: FROM
269: pji_fm_xbs_accum_tmp1 ;
270:
271: END;
272: ----------------------------------------------------------------------------
273: -- Created DEGUPTA

Line 402: DELETE FROM pji_fm_xbs_accum_tmp1;

398: , x_return_status => x_return_status );
399:
400:
401: -- Cleanup tmp1 table for 3750147.
402: DELETE FROM pji_fm_xbs_accum_tmp1;
403:
404: DELETE FROM pa_res_list_map_tmp1; /* Uncommented for bug 9859199 */
405: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170
406:

Line 735: INSERT INTO pji_fm_xbs_accum_tmp1

731:
732: IF nvl(p_calling_context,'F') in ('P','W') THEN
733: IF p_extraction_type <>'INCREMENTAL' THEN
734:
735: INSERT INTO pji_fm_xbs_accum_tmp1
736: (
737: SOURCE_ID, RES_LIST_MEMBER_ID, PROJECT_ID, STRUCT_VERSION_ID,
738: PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID,
739: TXN_CURRENCY_CODE, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE,

Line 936: INSERT INTO pji_fm_xbs_accum_tmp1

932: );
933:
934: else /* p_extraction_type ='INCREMENTAL*/
935:
936: INSERT INTO pji_fm_xbs_accum_tmp1
937: (
938: SOURCE_ID, RES_LIST_MEMBER_ID, PROJECT_ID, STRUCT_VERSION_ID,
939: PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID,
940: TXN_CURRENCY_CODE, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE,

Line 1136: INSERT INTO pji_fm_xbs_accum_tmp1

1132: );
1133: END IF;/* IF p_extraction_type <>'INCREMENTAL' THEN*/
1134: ELSE /* nvl(p_calling_context,'F') NOT IN ('P','W') */
1135:
1136: INSERT INTO pji_fm_xbs_accum_tmp1
1137: (
1138: SOURCE_ID, RES_LIST_MEMBER_ID, PROJECT_ID, STRUCT_VERSION_ID,
1139: PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID,
1140: TXN_CURRENCY_CODE, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE,

Line 1442: from PJI_FM_XBS_ACCUM_TMP1

1438: END IF;/* End of l_plan_ver_flag='Y' and l_get_summarized_Data='Y' */
1439: END LOOP;
1440:
1441: delete
1442: from PJI_FM_XBS_ACCUM_TMP1
1443: where nvl(TXN_RAW_COST, 0) = 0 and
1444: nvl(TXN_BRDN_COST, 0) = 0 and
1445: nvl(TXN_LABOR_RAW_COST, 0) = 0 and
1446: nvl(TXN_LABOR_BRDN_COST, 0) = 0 and

Line 1574: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1

1570:
1571:
1572:
1573: /*********************************************************
1574: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1
1575: for workplans.
1576: API supports both work plans and progress actuals
1577: The parameters that the API accepts can have one of the
1578: following combinations

Line 1936: DELETE FROM pji_fm_xbs_accum_tmp1;

1932: --Ensures that data is cleaned up for the Project / Program and the linked sub projects
1933: IF (p_delete_flag = 'Y') THEN
1934:
1935: print_time ( ' populate_updatewbs_data 0002 ' ) ;
1936: DELETE FROM pji_fm_xbs_accum_tmp1;
1937: print_time ( ' # rows deleted from tmp1 = ' || SQL%ROWCOUNT ) ;
1938:
1939: END IF;
1940:

Line 2045: INSERT INTO pji_fm_xbs_accum_tmp1 (

2041: -- OLAP END
2042: -- SRI_BUG END
2043:
2044:
2045: INSERT INTO pji_fm_xbs_accum_tmp1 (
2046: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
2047: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
2048: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
2049: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,

Line 2540: INSERT INTO pji_fm_xbs_accum_tmp1 (

2536:
2537:
2538: null;
2539:
2540: INSERT INTO pji_fm_xbs_accum_tmp1 (
2541: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
2542: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
2543: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
2544: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,

Line 2881: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1

2877:
2878:
2879:
2880: /*********************************************************
2881: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1
2882: for workplans.
2883: API supports both work plans and progress actuals
2884: The parameters that the API accepts can have one of the
2885: following combinations

Line 2991: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1

2987:
2988: PRINT_TIME ( ' populate_workplan_data 0003.10 ' ) ;
2989:
2990:
2991: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1
2992: WHERE EXISTS ( SELECT 'x'
2993: FROM PJI_PLAN_EXTR_TMP HEAD
2994: WHERE -1*HEAD.PROJECT_ID=TMP1.PROJECT_ID);
2995:

Line 3064: INSERT INTO pji_fm_xbs_accum_tmp1 (

3060: end if;
3061:
3062:
3063:
3064: INSERT INTO pji_fm_xbs_accum_tmp1 (
3065: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
3066: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
3067: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
3068: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,

Line 3814: DELETE FROM pji_fm_xbs_accum_tmp1

3810: PRINT_TIME ( ' populate_workplan_data 0003.10 ' ) ;
3811:
3812: -- Bug 10049710
3813: /*
3814: DELETE FROM pji_fm_xbs_accum_tmp1
3815: WHERE rowid IN
3816: (
3817: SELECT tmp.rowid
3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

Line 3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

3814: DELETE FROM pji_fm_xbs_accum_tmp1
3815: WHERE rowid IN
3816: (
3817: SELECT tmp.rowid
3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp
3819: WHERE head.project_id=tmp.project_id
3820: );
3821: */
3822: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1

Line 3822: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1

3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp
3819: WHERE head.project_id=tmp.project_id
3820: );
3821: */
3822: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1
3823: WHERE EXISTS ( SELECT 'x'
3824: FROM PJI_PLAN_EXTR_TMP HEAD
3825: WHERE HEAD.PROJECT_ID=TMP1.PROJECT_ID);
3826:

Line 3849: INSERT INTO pji_fm_xbs_accum_tmp1 (

3845: -- Data is rolled up by WBS hierarchy
3846: -- Data inserted is the Totals
3847: --
3848:
3849: INSERT INTO pji_fm_xbs_accum_tmp1 (
3850: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
3851: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
3852: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
3853: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,