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

Line 20: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

16: l_Err_Message VARCHAR2(3200);
17: l_PMV_Sql VARCHAR2(3200);
18: begin
19:
20: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
21: , P_SELECT_LIST =>
22: 'FACT.COST "PJI_REP_MSR_1" , FACT.COST "PJI_REP_MSR_19"
23: , FACT.CT_COST "PJI_REP_MSR_2" , FACT.COST_CHANGE_PRCNT "PJI_REP_MSR_3"
24: , FACT.CAP_COST "PJI_REP_MSR_4" , FACT.CAP_COST "PJI_REP_MSR_20"

Line 71: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

67: , x_PMV_Sql out nocopy VARCHAR2
68: , x_PMV_Output out nocopy BIS_QUERY_ATTRIBUTES_TBL)
69: is
70: begin
71: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
72: , P_SQL_STATEMENT => x_PMV_Sql
73: , P_SELECT_LIST => 'FACT.COST "PJI_REP_MSR_1"
74: , FACT.COST "PJI_REP_MSR_19"
75: , FACT.CT_COST "PJI_REP_MSR_2"

Line 119: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

115: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
116: IS
117: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
118: BEGIN
119: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
120: , P_SELECT_LIST =>
121: ' FACT.COST "PJI_REP_MSR_1"
122: , FACT.COST "PJI_REP_MSR_19"
123: , FACT.CT_COST "PJI_REP_MSR_2"

Line 180: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

176: l_Err_Message VARCHAR2(3200);
177: l_PMV_Sql VARCHAR2(3200);
178: BEGIN
179:
180: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
181: , P_SELECT_LIST =>
182: ' FACT.PROJECT_ID "PJI_REP_MSR_18"
183: , FACT.PROJECT_NAME "VIEWBY"
184: , FACT.PROJECT_NUMBER "PJI_REP_MSR_2"

Line 303: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

299: ** temporary tables.
300: */
301:
302:
303: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
304: , P_VIEW_BY => p_View_BY
305: );
306:
307: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

Line 307: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

303: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
304: , P_VIEW_BY => p_View_BY
305: );
306:
307: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
308: , P_VIEW_BY => p_View_BY
309: , p_Top_Organization_Name => l_Top_Organization_Name
310: );
311:

Line 312: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

308: , P_VIEW_BY => p_View_BY
309: , p_Top_Organization_Name => l_Top_Organization_Name
310: );
311:
312: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
313: , P_PERIOD_TYPE => p_Period_Type
314: , P_VIEW_BY => p_View_By
315: , P_PARSE_PRIOR => null
316: , P_REPORT_TYPE => 'DBI'

Line 325: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification

321: /*
322: ** -- Conditionally Execute ORG, CLASS, EXPENDITURE_TYPE, WORK_TYPE Processing --------------------------------+
323: */
324:
325: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
326: (p_Classifications, p_Class_Codes, p_View_BY);
327:
328: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
329: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

Line 328: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type

324:
325: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
326: (p_Classifications, p_Class_Codes, p_View_BY);
327:
328: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
329: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
330:
331: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
332: (p_Work_Type, p_View_BY);

Line 331: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type

327:
328: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
329: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
330:
331: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
332: (p_Work_Type, p_View_BY);
333:
334: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
335:

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

330:
331: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
332: (p_Work_Type, p_View_BY);
333:
334: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
335:
336: /*
337: ** ORGANIZATION Processing: No parameter other than Organization is specified
338: */

Line 2237: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);

2233: ** parameters passed by PMV and populate all the
2234: ** temporary tables.
2235: */
2236:
2237: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2238: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization, p_View_BY=>p_View_BY, p_Top_Organization_Name=>l_Top_Organization_Name);
2239: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date=>p_As_Of_Date, p_Period_Type=>p_Period_Type, p_View_BY=>p_View_BY, p_Parse_Prior=>'Y',p_Report_Type=>p_Report_Type);
2240:
2241: /*

Line 2238: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization, p_View_BY=>p_View_BY, p_Top_Organization_Name=>l_Top_Organization_Name);

2234: ** temporary tables.
2235: */
2236:
2237: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2238: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization, p_View_BY=>p_View_BY, p_Top_Organization_Name=>l_Top_Organization_Name);
2239: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date=>p_As_Of_Date, p_Period_Type=>p_Period_Type, p_View_BY=>p_View_BY, p_Parse_Prior=>'Y',p_Report_Type=>p_Report_Type);
2240:
2241: /*
2242: ** Determine the fact tables you choose to run the database

Line 2239: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date=>p_As_Of_Date, p_Period_Type=>p_Period_Type, p_View_BY=>p_View_BY, p_Parse_Prior=>'Y',p_Report_Type=>p_Report_Type);

2235: */
2236:
2237: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2238: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization, p_View_BY=>p_View_BY, p_Top_Organization_Name=>l_Top_Organization_Name);
2239: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date=>p_As_Of_Date, p_Period_Type=>p_Period_Type, p_View_BY=>p_View_BY, p_Parse_Prior=>'Y',p_Report_Type=>p_Report_Type);
2240:
2241: /*
2242: ** Determine the fact tables you choose to run the database
2243: ** query on ( this step is what we call manual query re-write).

Line 2246: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification

2242: ** Determine the fact tables you choose to run the database
2243: ** query on ( this step is what we call manual query re-write).
2244: */
2245:
2246: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
2247: (p_Classifications, p_Class_Codes, p_View_BY);
2248:
2249: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2250: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

Line 2249: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type

2245:
2246: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
2247: (p_Classifications, p_Class_Codes, p_View_BY);
2248:
2249: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2250: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2251:
2252: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2253:

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

2248:
2249: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2250: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2251:
2252: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2253:
2254: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
2255:
2256: /*

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

2250: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2251:
2252: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2253:
2254: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
2255:
2256: /*
2257: ** ORGANIZATION Processing: No parameter other than Organization is specified
2258: */

Line 3396: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

3392: ** parameters passed by PMV and populate all the
3393: ** temporary tables.
3394: */
3395:
3396: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3397: , P_VIEW_BY => p_View_BY
3398: );
3399:
3400: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

Line 3400: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

3396: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3397: , P_VIEW_BY => p_View_BY
3398: );
3399:
3400: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3401: , P_VIEW_BY => p_View_BY
3402: );
3403:
3404: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

Line 3404: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

3400: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3401: , P_VIEW_BY => p_View_BY
3402: );
3403:
3404: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
3405: , P_PERIOD_TYPE => p_Period_Type
3406: , P_VIEW_BY => p_View_By
3407: , P_PARSE_PRIOR => NULL
3408: , P_PARSE_ITD => NULL

Line 3412: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification

3408: , P_PARSE_ITD => NULL
3409: , P_FULL_PERIOD_FLAG => 'Y'
3410: );
3411:
3412: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
3413: (p_Classifications, p_Class_Codes, p_View_BY);
3414:
3415: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
3416: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

Line 3415: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type

3411:
3412: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
3413: (p_Classifications, p_Class_Codes, p_View_BY);
3414:
3415: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
3416: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3417:
3418: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
3419: (p_Work_Type, p_View_BY);

Line 3418: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type

3414:
3415: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
3416: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3417:
3418: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
3419: (p_Work_Type, p_View_BY);
3420: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3421:
3422: IF p_Project_IDS IS NULL THEN

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

3416: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3417:
3418: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
3419: (p_Work_Type, p_View_BY);
3420: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3421:
3422: IF p_Project_IDS IS NULL THEN
3423:
3424: /*

Line 3479: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS

3475: END IF;
3476: END;
3477:
3478: ELSE
3479: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS
3480: , P_VIEW_BY =>p_View_BY);
3481: END IF;
3482:
3483: /*