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

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

7: IS
8: l_Err_Message VARCHAR2(3200);
9: l_PMV_Sql VARCHAR2(3200);
10: BEGIN
11: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
12: P_SELECT_LIST =>'FACT.BACKLOG_NOT_STARTED "PJI_REP_MSR_1",
13: FACT.ACTIVE_BACKLOG "PJI_REP_MSR_2",
14: FACT.DORMANT_BACKLOG "PJI_REP_MSR_3",
15: FACT.TOTAL_ENDING_BACKLOG "PJI_REP_MSR_4",

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

49: IS
50: l_Err_Message VARCHAR2(3200);
51: l_PMV_Sql VARCHAR2(3200);
52: BEGIN
53: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl,
54: P_SELECT_LIST => 'FACT.BEGINNING_BACKLOG "PJI_REP_MSR_1",
55: FACT.ORIGINAL_BOOKINGS "PJI_REP_MSR_2",
56: FACT.ADDITIONAL_BOOKINGS "PJI_REP_MSR_3",
57: FACT.BOOKINGS_ADJUSTMENTS "PJI_REP_MSR_4",

Line 136: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);

132: ** Place a call to all the parse API's which parse the
133: ** parameters passed by PMV and populate all the
134: ** temporary tables.
135: */
136: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
137: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
138: P_VIEW_BY => p_View_BY,
139: p_Top_Organization_Name => l_Top_Organization_Name);
140: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL,'Y');

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

133: ** parameters passed by PMV and populate all the
134: ** temporary tables.
135: */
136: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
137: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
138: P_VIEW_BY => p_View_BY,
139: p_Top_Organization_Name => l_Top_Organization_Name);
140: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL,'Y');
141:

Line 140: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL,'Y');

136: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
137: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization,
138: P_VIEW_BY => p_View_BY,
139: p_Top_Organization_Name => l_Top_Organization_Name);
140: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL,'Y');
141:
142: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
143:
144: /*

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

138: P_VIEW_BY => p_View_BY,
139: p_Top_Organization_Name => l_Top_Organization_Name);
140: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL,'Y');
141:
142: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
143:
144: /*
145: ** Determine the fact tables you choose to run the database
146: ** query on ( this step is what we call manual query re-write).

Line 148: IF PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY) = 'N' THEN

144: /*
145: ** Determine the fact tables you choose to run the database
146: ** query on ( this step is what we call manual query re-write).
147: */
148: IF PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY) = 'N' THEN
149: /*
150: ** Code the SQL statement for all of the following conditions
151: ** 1. Current Year
152: ** 2. Prior Year

Line 814: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);

810: ** Place a call to all the parse API's which parse the
811: ** parameters passed by PMV and populate all the
812: ** temporary tables.
813: */
814: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
815: 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);
816: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL, 'Y');
817:
818: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);

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

811: ** parameters passed by PMV and populate all the
812: ** temporary tables.
813: */
814: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
815: 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);
816: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL, 'Y');
817:
818: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
819: /*

Line 816: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL, 'Y');

812: ** temporary tables.
813: */
814: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
815: 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);
816: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL, 'Y');
817:
818: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
819: /*
820: ** Determine the fact tables you choose to run the database

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

814: PJI_PMV_ENGINE.Convert_Operating_Unit(p_Operating_Unit, p_View_BY);
815: 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);
816: PJI_PMV_ENGINE.Convert_Time(p_As_Of_Date, p_Period_Type, p_View_By, 'Y', NULL, NULL, 'Y');
817:
818: l_curr_record_type_id:=PJI_PMV_ENGINE.Convert_Currency_Record_Type(p_Currency_Type);
819: /*
820: ** Determine the fact tables you choose to run the database
821: ** query on ( this step is what we call manual query re-write).
822: */

Line 823: IF PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY) = 'N' THEN

819: /*
820: ** Determine the fact tables you choose to run the database
821: ** query on ( this step is what we call manual query re-write).
822: */
823: IF PJI_PMV_ENGINE.Convert_Classification(p_Classifications, p_Class_Codes, p_View_BY) = 'N' THEN
824: /*
825: ** Code the SQL statement for all of the following conditions
826: ** 1. Current Year
827: ** 2. Prior Year