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;
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 916: INSERT INTO pji_fm_xbs_accum_tmp1

912: );
913:
914: else /* p_extraction_type ='INCREMENTAL*/
915:
916: INSERT INTO pji_fm_xbs_accum_tmp1
917: (
918: SOURCE_ID, RES_LIST_MEMBER_ID, PROJECT_ID, STRUCT_VERSION_ID,
919: PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID,
920: TXN_CURRENCY_CODE, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE,

Line 1096: INSERT INTO pji_fm_xbs_accum_tmp1

1092: );
1093: END IF;/* IF p_extraction_type <>'INCREMENTAL' THEN*/
1094: ELSE /* nvl(p_calling_context,'F') NOT IN ('P','W') */
1095:
1096: INSERT INTO pji_fm_xbs_accum_tmp1
1097: (
1098: SOURCE_ID, RES_LIST_MEMBER_ID, PROJECT_ID, STRUCT_VERSION_ID,
1099: PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID,
1100: TXN_CURRENCY_CODE, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE,

Line 1379: from PJI_FM_XBS_ACCUM_TMP1

1375: END IF;/* End of l_plan_ver_flag='Y' and l_get_summarized_Data='Y' */
1376: END LOOP;
1377:
1378: delete
1379: from PJI_FM_XBS_ACCUM_TMP1
1380: where nvl(TXN_RAW_COST, 0) = 0 and
1381: nvl(TXN_BRDN_COST, 0) = 0 and
1382: nvl(TXN_LABOR_RAW_COST, 0) = 0 and
1383: nvl(TXN_LABOR_BRDN_COST, 0) = 0 and

Line 1511: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1

1507:
1508:
1509:
1510: /*********************************************************
1511: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1
1512: for workplans.
1513: API supports both work plans and progress actuals
1514: The parameters that the API accepts can have one of the
1515: following combinations

Line 1754: DELETE FROM pji_fm_xbs_accum_tmp1;

1750: --Ensures that data is cleaned up for the Project / Program and the linked sub projects
1751: IF (p_delete_flag = 'Y') THEN
1752:
1753: print_time ( ' populate_updatewbs_data 0002 ' ) ;
1754: DELETE FROM pji_fm_xbs_accum_tmp1;
1755: print_time ( ' # rows deleted from tmp1 = ' || SQL%ROWCOUNT ) ;
1756:
1757: END IF;
1758:

Line 1792: INSERT INTO pji_fm_xbs_accum_tmp1 (

1788: -- Data is rolled up by WBS hierarchy
1789: -- Data inserted is the Totals
1790: --
1791:
1792: INSERT INTO pji_fm_xbs_accum_tmp1 (
1793: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
1794: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
1795: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
1796: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,

Line 2296: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1

2292:
2293:
2294:
2295: /*********************************************************
2296: This procedure populates data in PJI_FM_XBS_ACCUM_TMP1
2297: for workplans.
2298: API supports both work plans and progress actuals
2299: The parameters that the API accepts can have one of the
2300: following combinations

Line 2704: DELETE FROM pji_fm_xbs_accum_tmp1

2700: IF (p_delete_flag = 'Y') THEN
2701:
2702: PRINT_TIME ( ' populate_workplan_data 0003.10 ' ) ;
2703:
2704: DELETE FROM pji_fm_xbs_accum_tmp1
2705: WHERE rowid IN
2706: (
2707: SELECT tmp.rowid
2708: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

Line 2708: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

2704: DELETE FROM pji_fm_xbs_accum_tmp1
2705: WHERE rowid IN
2706: (
2707: SELECT tmp.rowid
2708: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp
2709: WHERE head.project_id=tmp.project_id
2710: );
2711:
2712: END IF;

Line 2734: INSERT INTO pji_fm_xbs_accum_tmp1 (

2730: -- Data is rolled up by WBS hierarchy
2731: -- Data inserted is the Totals
2732: --
2733:
2734: INSERT INTO pji_fm_xbs_accum_tmp1 (
2735: PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE,
2736: PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST,
2737: TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST,
2738: TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST,