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_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: COST "PJI_REP_MSR_1"
23: , COST "PJI_REP_MSR_19"
24: , CT_COST "PJI_REP_MSR_2"

Line 100: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

96: , x_PMV_Sql OUT NOCOPY VARCHAR2
97: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
98: IS
99: BEGIN
100: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
101: , P_SQL_STATEMENT => x_PMV_Sql
102: , P_SELECT_LIST =>
103: 'FACT.COST "PJI_REP_MSR_1"
104: ,FACT.COST "PJI_REP_MSR_19"

Line 158: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

154: l_Err_Message VARCHAR2(3200);
155: l_PMV_Sql VARCHAR2(3200);
156: BEGIN
157:
158: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
159: , P_SELECT_LIST =>
160: ' FACT.PROJECT_ID "PJI_REP_MSR_18"
161: , FACT.PROJECT_NAME "VIEWBY"
162: , FACT.PROJECT_NUMBER "PJI_REP_MSR_2"

Line 211: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

207: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
208: IS
209: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
210: BEGIN
211: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
212: , P_SELECT_LIST =>
213: ' FACT.COST "PJI_REP_MSR_1"
214: , FACT.COST "PJI_REP_MSR_19"
215: , FACT.CT_COST "PJI_REP_MSR_2"

Line 337: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

333: ** parameters passed by PMV and populate all the
334: ** temporary tables.
335: */
336:
337: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
338: , P_VIEW_BY => p_View_BY);
339:
340: PJI_PMV_ENGINE.Convert_Organization(p_TOP_ORGANIZATION_ID => p_Organization
341: , p_VIEW_BY => p_View_BY

Line 340: PJI_PMV_ENGINE.Convert_Organization(p_TOP_ORGANIZATION_ID => p_Organization

336:
337: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
338: , P_VIEW_BY => p_View_BY);
339:
340: PJI_PMV_ENGINE.Convert_Organization(p_TOP_ORGANIZATION_ID => p_Organization
341: , p_VIEW_BY => p_View_BY
342: , p_Top_Organization_Name => l_Top_Organization_Name);
343:
344: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

Line 344: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

340: PJI_PMV_ENGINE.Convert_Organization(p_TOP_ORGANIZATION_ID => p_Organization
341: , p_VIEW_BY => p_View_BY
342: , p_Top_Organization_Name => l_Top_Organization_Name);
343:
344: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
345: , P_PERIOD_TYPE => p_Period_Type
346: , P_VIEW_BY => p_View_By
347: , P_PARSE_PRIOR => NULL
348: , P_REPORT_TYPE => 'DBI'

Line 357: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification

353: /*
354: ** -- Conditionally Execute ORG, CLASS, EXPENDITURE_TYPE, WORK_TYPE Processing --------------------------------+
355: */
356:
357: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
358: (p_Classifications, p_Class_Codes, p_View_BY);
359:
360: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
361: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

Line 360: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type

356:
357: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
358: (p_Classifications, p_Class_Codes, p_View_BY);
359:
360: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
361: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
362:
363: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
364: (p_Work_Type, p_View_BY);

Line 363: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type

359:
360: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
361: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
362:
363: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
364: (p_Work_Type, p_View_BY);
365:
366: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
367:

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

362:
363: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type
364: (p_Work_Type, p_View_BY);
365:
366: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
367:
368: /*
369: ** ORGANIZATION Processing: No parameter other than Organization is specified
370: */

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

2173: ** Place a call to all the parse API's which parse the
2174: ** parameters passed by PMV and populate all the
2175: ** temporary tables.
2176: */
2177: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2178: 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);
2179: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date => p_As_Of_Date,
2180: p_Period_Type => p_Period_Type,
2181: p_View_BY => p_View_BY,

Line 2178: 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);

2174: ** parameters passed by PMV and populate all the
2175: ** temporary tables.
2176: */
2177: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2178: 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);
2179: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date => p_As_Of_Date,
2180: p_Period_Type => p_Period_Type,
2181: p_View_BY => p_View_BY,
2182: p_Parse_Prior => 'Y',

Line 2179: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date => p_As_Of_Date,

2175: ** temporary tables.
2176: */
2177: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
2178: 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);
2179: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date => p_As_Of_Date,
2180: p_Period_Type => p_Period_Type,
2181: p_View_BY => p_View_BY,
2182: p_Parse_Prior => 'Y',
2183: p_Report_Type => p_Report_Type,

Line 2189: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification

2185: p_Parse_ITD => NULL,
2186: p_Full_Period_Flag => 'Y');
2187:
2188:
2189: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
2190: (p_Classifications, p_Class_Codes, p_View_BY);
2191:
2192: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2193: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

Line 2192: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type

2188:
2189: l_Convert_Classification := PJI_PMV_ENGINE.Convert_Classification
2190: (p_Classifications, p_Class_Codes, p_View_BY);
2191:
2192: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2193: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2194: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2195:
2196: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

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

2190: (p_Classifications, p_Class_Codes, p_View_BY);
2191:
2192: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2193: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2194: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2195:
2196: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
2197: /*
2198: ** ORGANIZATION Processing: No parameter other than Organization is specified

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

2192: l_Convert_Expenditure_Type := PJI_PMV_ENGINE.Convert_Expenditure_Type
2193: (p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
2194: l_Convert_Work_Type := PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
2195:
2196: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
2197: /*
2198: ** ORGANIZATION Processing: No parameter other than Organization is specified
2199: */
2200:

Line 3320: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit

3316: WHEN NO_DATA_FOUND THEN
3317: G_Report_Cost_Type:='RC';
3318: END;
3319:
3320: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3321: , P_VIEW_BY => p_View_BY
3322: );
3323:
3324: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

Line 3324: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

3320: PJI_PMV_ENGINE.Convert_Operating_Unit(P_OPERATING_UNIT_IDS => p_Operating_Unit
3321: , P_VIEW_BY => p_View_BY
3322: );
3323:
3324: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3325: , P_VIEW_BY => p_View_BY
3326: );
3327:
3328: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

Line 3328: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date

3324: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3325: , P_VIEW_BY => p_View_BY
3326: );
3327:
3328: PJI_PMV_ENGINE.Convert_Time(P_AS_OF_DATE => p_As_of_Date
3329: , P_PERIOD_TYPE => p_Period_Type
3330: , P_VIEW_BY => p_View_By
3331: , P_PARSE_PRIOR => NULL
3332: , P_PARSE_ITD => NULL

Line 3337: PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);

3333: , P_FULL_PERIOD_FLAG => 'Y'
3334: );
3335:
3336: l_Convert_Classification :=
3337: PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3338: l_Convert_Expenditure_Type :=
3339: PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3340: l_Convert_Work_Type :=
3341: PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);

Line 3339: PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);

3335:
3336: l_Convert_Classification :=
3337: PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3338: l_Convert_Expenditure_Type :=
3339: PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3340: l_Convert_Work_Type :=
3341: PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3342:
3343: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

Line 3341: PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);

3337: PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY);
3338: l_Convert_Expenditure_Type :=
3339: PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3340: l_Convert_Work_Type :=
3341: PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3342:
3343: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3344:
3345: IF p_Project_IDS IS NULL THEN

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

3339: PJI_PMV_ENGINE.Convert_Expenditure_Type(p_Expenditure_Category, p_Expenditure_Type, p_View_BY);
3340: l_Convert_Work_Type :=
3341: PJI_PMV_ENGINE.Convert_Work_Type(p_Work_Type, p_View_BY);
3342:
3343: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
3344:
3345: IF p_Project_IDS IS NULL THEN
3346:
3347: /*

Line 3399: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS

3395: AND pjm.class_category = '$PROJECT_TYPE$CONTRACT';
3396: END IF;
3397: END;
3398: ELSE
3399: PJI_PMV_ENGINE.Convert_Project(P_PROJECT_IDS=>p_Project_IDS
3400: , P_VIEW_BY =>p_View_BY);
3401: END IF;
3402: /*
3403: ** ORG Processing ---------------------------------------------------+