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

Line 17: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,

13: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
14: IS
15: l_Err_Message VARCHAR2(3200);
16: BEGIN
17: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
18: P_SELECT_LIST => 'FACT.ORIGINAL_FUNDINGS_COUNT "PJI_REP_MSR_1",
19: FACT.ADDITIONAL_FUNDINGS_COUNT "PJI_REP_MSR_2",
20: FACT.TOTAL_BOOKINGS_COUNT "PJI_REP_MSR_7",
21: FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_3",

Line 71: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,

67: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
68: IS
69: l_Err_Message VARCHAR2(3200);
70: BEGIN
71: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
72: P_SELECT_LIST =>'FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_1",
73: FACT.PRIOR_ORIG_FUNDINGS_AMOUNT "PJI_REP_MSR_2",
74: FACT.ORIG_FUND_CHANGE_PERCENT "PJI_REP_MSR_3",
75: FACT.TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_4",

Line 108: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,

104: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
105: IS
106: l_Err_Message VARCHAR2(3200);
107: BEGIN
108: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
109: P_SELECT_LIST => 'FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_1",
110: FACT.ORIGINAL_FUNDINGS_COUNT "PJI_REP_MSR_2",
111: FACT.ORIGINAL_AVG_BOOKINGS "PJI_REP_MSR_3",
112: FACT.ADDITIONAL_FUNDINGS_AMOUNT "PJI_REP_MSR_4",

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

185: ** Place a call to all the parse API's which parse the
186: ** parameters passed by PMV and populate all the
187: ** temporary tables.
188: */
189: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
190: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
191: p_View_BY=>p_View_BY,
192: p_Top_Organization_Name => l_Top_Organization_Name);
193: 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=>NULL, p_Comparator=>NULL, p_Parse_ITD=>NULL);

Line 190: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,

186: ** parameters passed by PMV and populate all the
187: ** temporary tables.
188: */
189: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
190: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
191: p_View_BY=>p_View_BY,
192: p_Top_Organization_Name => l_Top_Organization_Name);
193: 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=>NULL, p_Comparator=>NULL, p_Parse_ITD=>NULL);
194:

Line 193: 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=>NULL, p_Comparator=>NULL, p_Parse_ITD=>NULL);

189: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
190: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
191: p_View_BY=>p_View_BY,
192: p_Top_Organization_Name => l_Top_Organization_Name);
193: 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=>NULL, p_Comparator=>NULL, p_Parse_ITD=>NULL);
194:
195: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
196:
197: /*

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

191: p_View_BY=>p_View_BY,
192: p_Top_Organization_Name => l_Top_Organization_Name);
193: 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=>NULL, p_Comparator=>NULL, p_Parse_ITD=>NULL);
194:
195: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
196:
197: /*
198: ** Determine the fact tables you choose to run the database
199: ** query on ( this step is what we call manual query re-write).

Line 202: IF PJI_PMV_ENGINE.Convert_Classification(p_Classification_ID=>p_Classifications, p_Class_Code_IDS=>p_Class_Codes, p_View_BY=>p_View_BY) = 'N' THEN

198: ** Determine the fact tables you choose to run the database
199: ** query on ( this step is what we call manual query re-write).
200: */
201:
202: IF PJI_PMV_ENGINE.Convert_Classification(p_Classification_ID=>p_Classifications, p_Class_Code_IDS=>p_Class_Codes, p_View_BY=>p_View_BY) = 'N' THEN
203:
204: /*
205: ** Code the SQL statement for all of the following conditions
206: ** 1. Current Year