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

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

14: IS
15: l_Err_Message VARCHAR2(3200);
16: l_PMV_Sql VARCHAR2(3200);
17: BEGIN
18: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
19: P_SELECT_LIST =>
20: 'FACT.TOTAL_BOOKINGS "PJI_REP_MSR_1",
21: FACT.BOOKINGS_CHANGE "PJI_REP_MSR_2",
22: FACT.TOTAL_ENDING_BACKLOG "PJI_REP_MSR_3",

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

73: IS
74: l_Err_Message VARCHAR2(3200);
75: l_PMV_Sql VARCHAR2(3200);
76: BEGIN
77: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
78: P_SELECT_LIST => 'FACT.PROJECT_ID "PJI_REP_MSR_28",
79: FACT.PROJECT_NAME "VIEWBY",
80: FACT.PROJECT_NUMBER "PJI_REP_MSR_2",
81: FACT.URL_PARAMETERS01 "PJI_REP_MSR_27",

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

142: IS
143: l_Err_Message VARCHAR2(3200);
144: l_PMV_Sql VARCHAR2(3200);
145: BEGIN
146: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
147: P_SELECT_LIST => 'FACT.BACKLOG "PJI_REP_MSR_1",
148: FACT.ORIGINAL_BOOKINGS "PJI_REP_MSR_2",
149: FACT.ADDITIONAL_BOOKINGS "PJI_REP_MSR_3",
150: FACT.BOOKINGS_ADJUSTMENTS "PJI_REP_MSR_4",

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

191: IS
192: l_Err_Message VARCHAR2(3200);
193: l_PMV_Sql VARCHAR2(3200);
194: BEGIN
195: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
196: P_SELECT_LIST => 'FACT.PROJECT_ID "PJI_REP_MSR_18",
197: FACT.PROJECT_NAME "VIEWBY",
198: FACT.PROJECT_NUMBER "PJI_REP_MSR_2",
199: FACT.URL_PARAMETERS01 "PJI_REP_MSR_20",

Line 302: l_BTB_C_As_Of_Date :=PJI_PMV_ENGINE.Convert_AS_OF_DATE(p_As_Of_Date, p_Period_Type, p_Comparator_Type);

298: ** Call the Convert_AS_OF_DATE api to derive the
299: ** as of date as per comparator type selected
300: ** in the pmv report.
301: */
302: l_BTB_C_As_Of_Date :=PJI_PMV_ENGINE.Convert_AS_OF_DATE(p_As_Of_Date, p_Period_Type, p_Comparator_Type);
303: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
304:
305: /*
306: ** Place a call to all the parse API's which parse the

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

299: ** as of date as per comparator type selected
300: ** in the pmv report.
301: */
302: l_BTB_C_As_Of_Date :=PJI_PMV_ENGINE.Convert_AS_OF_DATE(p_As_Of_Date, p_Period_Type, p_Comparator_Type);
303: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
304:
305: /*
306: ** Place a call to all the parse API's which parse the
307: ** parameters passed by PMV and populate all the

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

306: ** Place a call to all the parse API's which parse the
307: ** parameters passed by PMV and populate all the
308: ** temporary tables.
309: */
310: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
311: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
312: p_View_BY=>p_View_BY,
313: p_Top_Organization_Name =>l_Top_Organization_Name);
314: 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=>'N', p_Report_Type=>'DBI', p_Comparator=>p_Comparator_Type, p_Parse_ITD=>'Y');

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

307: ** parameters passed by PMV and populate all the
308: ** temporary tables.
309: */
310: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
311: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
312: p_View_BY=>p_View_BY,
313: p_Top_Organization_Name =>l_Top_Organization_Name);
314: 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=>'N', p_Report_Type=>'DBI', p_Comparator=>p_Comparator_Type, p_Parse_ITD=>'Y');
315:

Line 314: 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=>'N', p_Report_Type=>'DBI', p_Comparator=>p_Comparator_Type, p_Parse_ITD=>'Y');

310: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit_IDS=>p_Operating_Unit, p_View_BY=>p_View_BY);
311: PJI_PMV_ENGINE.Convert_Organization(p_Top_Organization_ID=>p_Organization,
312: p_View_BY=>p_View_BY,
313: p_Top_Organization_Name =>l_Top_Organization_Name);
314: 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=>'N', p_Report_Type=>'DBI', p_Comparator=>p_Comparator_Type, p_Parse_ITD=>'Y');
315:
316: /*
317: ** Determine the lag days between book to bill based on
318: ** PJI setup.

Line 342: 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

338: ** Determine the fact tables you choose to run the database
339: ** query on ( this step is what we call manual query re-write).
340: */
341:
342: 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
343:
344: /*
345: ** Code the SQL statement for all of the following conditions
346: ** 1. Current Year

Line 1264: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (

1260: ** PLACE A CALL TO ALL THE PARSE API'S WHICH PARSE THE
1261: ** PARAMETERS PASSED BY PMV AND POPULATE ALL THE
1262: ** TEMPORARY TABLES.
1263: */
1264: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (
1265: P_OPERATING_UNIT_IDS=> P_OPERATING_UNIT,
1266: P_VIEW_BY=> P_VIEW_BY
1267: );
1268: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (

Line 1268: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (

1264: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (
1265: P_OPERATING_UNIT_IDS=> P_OPERATING_UNIT,
1266: P_VIEW_BY=> P_VIEW_BY
1267: );
1268: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (
1269: P_TOP_ORGANIZATION_ID=> P_ORGANIZATION,
1270: P_VIEW_BY=> P_VIEW_BY
1271: );
1272: PJI_PMV_ENGINE.CONVERT_TIME (

Line 1272: PJI_PMV_ENGINE.CONVERT_TIME (

1268: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (
1269: P_TOP_ORGANIZATION_ID=> P_ORGANIZATION,
1270: P_VIEW_BY=> P_VIEW_BY
1271: );
1272: PJI_PMV_ENGINE.CONVERT_TIME (
1273: P_AS_OF_DATE=> P_AS_OF_DATE,
1274: P_PERIOD_TYPE=> P_PERIOD_TYPE,
1275: P_VIEW_BY=> P_VIEW_BY,
1276: P_PARSE_PRIOR=> 'N',

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

1279: P_PARSE_ITD=> 'Y'
1280: );
1281:
1282:
1283: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
1284:
1285:
1286: /*
1287: ** DETERMINE THE FACT TABLES YOU CHOOSE TO RUN THE DATABASE

Line 1291: IF PJI_PMV_ENGINE.CONVERT_CLASSIFICATION (

1287: ** DETERMINE THE FACT TABLES YOU CHOOSE TO RUN THE DATABASE
1288: ** QUERY ON ( THIS STEP IS WHAT WE CALL MANUAL QUERY RE-WRITE).
1289: */
1290:
1291: IF PJI_PMV_ENGINE.CONVERT_CLASSIFICATION (
1292: P_CLASSIFICATIONS,
1293: P_CLASS_CODES,
1294: P_VIEW_BY
1295: ) = 'N'

Line 1945: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

1941: ** TEMPORARY TABLES.
1942: */
1943:
1944:
1945: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1946: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
1947: P_VIEW_BY => p_View_BY,
1948: p_Top_Organization_Name => l_Top_Organization_Name);
1949: PJI_PMV_ENGINE.CONVERT_TIME (

Line 1946: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,

1942: */
1943:
1944:
1945: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1946: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
1947: P_VIEW_BY => p_View_BY,
1948: p_Top_Organization_Name => l_Top_Organization_Name);
1949: PJI_PMV_ENGINE.CONVERT_TIME (
1950: P_AS_OF_DATE,

Line 1949: PJI_PMV_ENGINE.CONVERT_TIME (

1945: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1946: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
1947: P_VIEW_BY => p_View_BY,
1948: p_Top_Organization_Name => l_Top_Organization_Name);
1949: PJI_PMV_ENGINE.CONVERT_TIME (
1950: P_AS_OF_DATE,
1951: P_PERIOD_TYPE,
1952: P_VIEW_BY,
1953: 'Y',

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

1955: NULL,
1956: 'Y'
1957: );
1958:
1959: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
1960:
1961: /*
1962: ** DETERMINE THE FACT TABLES YOU CHOOSE TO RUN THE DATABASE
1963: ** QUERY ON ( THIS STEP IS WHAT WE CALL MANUAL QUERY RE-WRITE).

Line 1965: IF PJI_PMV_ENGINE.CONVERT_CLASSIFICATION (

1961: /*
1962: ** DETERMINE THE FACT TABLES YOU CHOOSE TO RUN THE DATABASE
1963: ** QUERY ON ( THIS STEP IS WHAT WE CALL MANUAL QUERY RE-WRITE).
1964: */
1965: IF PJI_PMV_ENGINE.CONVERT_CLASSIFICATION (
1966: P_CLASSIFICATIONS,
1967: P_CLASS_CODES,
1968: P_VIEW_BY
1969: ) = 'N'