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_AC_BOOKINGS

Line 152: )RETURN PJI_AC_BOOKINGS_TBL

148: , p_Period_Type IN VARCHAR2
149: , p_View_BY IN VARCHAR2
150: , p_Classifications IN VARCHAR2 DEFAULT NULL
151: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
152: )RETURN PJI_AC_BOOKINGS_TBL
153: IS
154: PRAGMA AUTONOMOUS_TRANSACTION;
155: l_Total_AC_Bookings_Tab PJI_AC_BOOKINGS_TBL:=PJI_AC_BOOKINGS_TBL();
156: l_Top_Organization_Name VARCHAR2(240);

Line 155: l_Total_AC_Bookings_Tab PJI_AC_BOOKINGS_TBL:=PJI_AC_BOOKINGS_TBL();

151: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
152: )RETURN PJI_AC_BOOKINGS_TBL
153: IS
154: PRAGMA AUTONOMOUS_TRANSACTION;
155: l_Total_AC_Bookings_Tab PJI_AC_BOOKINGS_TBL:=PJI_AC_BOOKINGS_TBL();
156: l_Top_Organization_Name VARCHAR2(240);
157: l_Top_Org_Index NUMBER:=0;
158:
159: l_Orig_Fund_Count NUMBER:=0;

Line 213: SELECT PJI_AC_BOOKINGS(

209: ** Bulk-Collect the output into a pl/sql table to be returned to
210: ** pmv.
211: */
212:
213: SELECT PJI_AC_BOOKINGS(
214: ORG_ID
215: , ORGANIZATION_ID
216: , TIME_ID
217: , TIME_KEY

Line 457: SELECT PJI_AC_BOOKINGS( ORG_ID

453: ** 2. Prior Year
454: ** 3. SQL to generate rows with zero's for the view by dimension
455: */
456:
457: SELECT PJI_AC_BOOKINGS( ORG_ID
458: , ORGANIZATION_ID
459: , TIME_ID
460: , TIME_KEY
461: , PROJECT_CLASS_ID