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_PMV_PROFITABILITY dependencies on PJI_PMV_ENGINE

Line 14: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

10: l_Err_Message VARCHAR2(3200);
11: l_PMV_Sql VARCHAR2(3200);
12: BEGIN
13:
14: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
15: , P_SELECT_LIST =>
16: ' FACT.CT_REVENUE "PJI_REP_MSR_14"
17: , FACT.CT_MARGIN_PERCENT "PJI_REP_MSR_15"
18: , FACT.REVENUE "PJI_REP_MSR_16"

Line 77: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

73: l_Err_Message VARCHAR2(3200);
74: l_PMV_Sql VARCHAR2(3200);
75: BEGIN
76:
77: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
78: , P_SELECT_LIST =>
79: ' FACT.CT_FORECAST_REVENUE "PJI_REP_MSR_14"
80: , FACT.FCST_CT_MARGIN_PERCENT "PJI_REP_MSR_15"
81: , FACT.FORECAST_REVENUE "PJI_REP_MSR_16"

Line 140: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

136: l_Err_Message VARCHAR2(3200);
137: l_PMV_Sql VARCHAR2(3200);
138: BEGIN
139:
140: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
141: , P_SELECT_LIST =>
142: ' FACT.AMOUNT_TYPE_LABEL "VIEWBY"
143: , FACT.P_ACTUAL "PJI_REP_MSR_7"
144: , FACT.P_ACTUAL1 "PJI_REP_MSR_18"

Line 195: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

191: l_Err_Message VARCHAR2(3200);
192: l_PMV_Sql VARCHAR2(3200);
193: BEGIN
194:
195: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
196: , P_SELECT_LIST =>
197: ' FACT.CT_BURDENED_COST "PJI_REP_MSR_14"
198: , FACT.CT_FORECAST_BURDENED_COST "PJI_REP_MSR_15"
199: , FACT.CST_CHANGE_PERCENT "PJI_REP_MSR_1"

Line 249: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

245: l_Err_Message VARCHAR2(3200);
246: l_PMV_Sql VARCHAR2(3200);
247: BEGIN
248:
249: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
250: , P_SELECT_LIST =>
251: ' FACT.PROJECT_ID "PJI_REP_MSR_18"
252: , FACT.PROJECT_NAME "VIEWBY"
253: , FACT.PROJECT_NUMBER "PJI_REP_MSR_2"

Line 309: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

305: IS
306: l_Err_Message VARCHAR2(3200);
307: l_PMV_Sql VARCHAR2(3200);
308: BEGIN
309: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
310: , P_SELECT_LIST =>
311: ' FACT.PROJECT_ID "PJI_REP_MSR18"
312: , FACT.PROJECT_NAME "VIEWBY"
313: , FACT.PROJECT_NUMBER "PJI_REP_MSR_2"

Line 374: ** Various PJI_PMV_ENGINE.Convert APIs

370: ** Issues:
371: **
372: **
373: ** Called subprograms:
374: ** Various PJI_PMV_ENGINE.Convert APIs
375: **
376: ** Called objects:
377: ** PJI_REP_PP3_TBL (table of db object PJI_REP_PP3)
378: **

Line 383: ** PJI_PMV_ENGINE.Convert_Time API call

379: ** History:
380: ** 21-MAY-2002 jwhite Created.
381: **
382: ** 15-JUL-2002 jwhite As directed by Vijay, for the
383: ** PJI_PMV_ENGINE.Convert_Time API call
384: ** I removed the following parameter reference:
385: **
386: ** P_REPORT_TYPE => 'DBI'
387: **

Line 493: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

489: ** parameters passed by PMV and populate all the
490: ** temporary tables.
491: */
492:
493: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
494: , P_VIEW_BY => p_View_BY
495: );
496:
497:

Line 498: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

494: , P_VIEW_BY => p_View_BY
495: );
496:
497:
498: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
499: , P_VIEW_BY => p_View_BY
500: , p_Top_Organization_Name => l_Top_Organization_Name
501: );
502: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

Line 502: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

498: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
499: , P_VIEW_BY => p_View_BY
500: , p_Top_Organization_Name => l_Top_Organization_Name
501: );
502: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
503: , P_PERIOD_TYPE => p_Period_Type
504: , P_VIEW_BY => p_View_By
505: , P_PARSE_PRIOR => 'Y'
506: , P_COMPARATOR => NULL

Line 511: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications,

507: , P_PARSE_ITD => NULL
508: , P_FULL_PERIOD_FLAG => 'Y'
509: );
510:
511: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications,
512:
513: p_Class_Codes, p_View_BY);
514: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category,
515: p_Revenue_Type, p_View_BY );

Line 514: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category,

510:
511: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications,
512:
513: p_Class_Codes, p_View_BY);
514: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category,
515: p_Revenue_Type, p_View_BY );
516: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
517: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
518:

Line 516: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);

512:
513: p_Class_Codes, p_View_BY);
514: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category,
515: p_Revenue_Type, p_View_BY );
516: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
517: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
518:
519: /*
520: **

Line 517: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

513: p_Class_Codes, p_View_BY);
514: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category,
515: p_Revenue_Type, p_View_BY );
516: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
517: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
518:
519: /*
520: **
521: ** -- PHASE I: Insert Separate Current and Prior Year Rows for Revenue, Cost and Margin

Line 3146: ** Various PJI_PMV_ENGINE.Convert APIs

3142: ** Issues:
3143: **
3144: **
3145: ** Called subprograms:
3146: ** Various PJI_PMV_ENGINE.Convert APIs
3147: **
3148: ** Called objects:
3149: ** PJI_REP_PPDTL_TBL (table of db object PJI_REP_PPDTL)
3150: **

Line 3219: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

3215: ** parameters passed by PMV and populate all the
3216: ** temporary tables.
3217: */
3218:
3219: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3220: , P_VIEW_BY => p_View_BY
3221: );
3222:
3223: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

Line 3223: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

3219: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3220: , P_VIEW_BY => p_View_BY
3221: );
3222:
3223: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3224: , P_VIEW_BY => p_View_BY
3225: );
3226:
3227:

Line 3229: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

3225: );
3226:
3227:
3228:
3229: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
3230: , P_PERIOD_TYPE => p_Period_Type
3231: , P_VIEW_BY => p_View_By
3232: , P_PARSE_PRIOR => NULL
3233: , P_PARSE_ITD => NULL

Line 3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);

3234: , P_FULL_PERIOD_FLAG => 'Y'
3235: );
3236:
3237:
3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

Line 3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

3235: );
3236:
3237:
3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3243:

Line 3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );

3236:
3237:
3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3243:
3244: /*

Line 3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);

3237:
3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3243:
3244: /*
3245: ** PHASE I: Insert Separate Current and Prior Year Rows for Revenue, Cost and Margin

Line 3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

3238: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3239: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3240: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
3241: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3242: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3243:
3244: /*
3245: ** PHASE I: Insert Separate Current and Prior Year Rows for Revenue, Cost and Margin
3246: */

Line 3291: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS

3287:
3288: END;
3289:
3290: ELSE
3291: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS
3292: , P_VIEW_BY =>p_View_BY);
3293: END IF;
3294:
3295:

Line 3933: ** Various PJI_PMV_ENGINE.Convert APIs

3929: ** NOTE:
3930: ** The Project SUMMARY Profitability reports are DBI reports.
3931: **
3932: ** Called subprograms:
3933: ** Various PJI_PMV_ENGINE.Convert APIs
3934: **
3935: ** Called objects:
3936: ** PJI_REP_PPSUM_TBL (table of db object PJI_REP_PPSUM)
3937: **

Line 4023: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

4019: ** parameters passed by PMV and populate all the
4020: ** temporary tables.
4021: */
4022:
4023: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
4024: , P_VIEW_BY => p_View_BY
4025: );
4026:
4027:

Line 4028: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

4024: , P_VIEW_BY => p_View_BY
4025: );
4026:
4027:
4028: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
4029: , P_VIEW_BY => p_View_BY
4030: , p_Top_Organization_Name => l_Top_Organization_Name
4031: );
4032:

Line 4035: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

4031: );
4032:
4033:
4034: IF p_Time_Comparison_Type <> 'BUDGET' THEN
4035: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
4036: , P_PERIOD_TYPE => p_Period_Type
4037: , P_VIEW_BY => p_View_By
4038: , P_PARSE_PRIOR => NULL
4039: , P_REPORT_TYPE => 'DBI'

Line 4045: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

4041: , P_PARSE_ITD => NULL
4042: , P_FULL_PERIOD_FLAG => 'Y'
4043: );
4044: ELSE
4045: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
4046: , P_PERIOD_TYPE => p_Period_Type
4047: , P_VIEW_BY => p_View_By
4048: , P_PARSE_PRIOR => NULL
4049: , P_REPORT_TYPE => NULL

Line 4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);

4052: , P_FULL_PERIOD_FLAG => 'Y'
4053: );
4054: END IF;
4055:
4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

Line 4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

4053: );
4054: END IF;
4055:
4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
4061:

Line 4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );

4054: END IF;
4055:
4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
4061:
4062: /*

Line 4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);

4055:
4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
4061:
4062: /*
4063: ** -- Conditionally Processing from different facts --------------------------------+

Line 4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

4056: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
4057: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
4058: l_Convert_Event_Revenue_Type := PJI_PMV_ENGINE.Convert_Event_Revenue_Type(p_Revenue_Category, p_Revenue_Type, p_View_BY );
4059: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
4060: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
4061:
4062: /*
4063: ** -- Conditionally Processing from different facts --------------------------------+
4064: */