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_REP_PC11

Line 95: PROCEDURE Get_SQL_PJI_REP_PC11 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

91: /*
92: ** Contract Projects Cost Trend
93: */
94:
95: PROCEDURE Get_SQL_PJI_REP_PC11 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
96: , x_PMV_Sql OUT NOCOPY VARCHAR2
97: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
98: IS
99: BEGIN

Line 128: , P_REGION_CODE => 'PJI_REP_PC11'

124: ,FACT.NON_BILL_COST "PJI_REP_MSR_16"
125: ,FACT.ct_NON_BILL_COST "PJI_REP_MSR_17"
126: ,FACT.NON_BILL_COST_CHANGE_PRCNT "PJI_REP_MSR_18"'
127: , P_PMV_OUTPUT => x_PMV_Output
128: , P_REGION_CODE => 'PJI_REP_PC11'
129: , P_PLSQL_DRIVER => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC11'
130: , P_PLSQL_DRIVER_PARAMS => ' <>'||
131: ', <>'||
132: ', <>'||

Line 129: , P_PLSQL_DRIVER => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC11'

125: ,FACT.ct_NON_BILL_COST "PJI_REP_MSR_17"
126: ,FACT.NON_BILL_COST_CHANGE_PRCNT "PJI_REP_MSR_18"'
127: , P_PMV_OUTPUT => x_PMV_Output
128: , P_REGION_CODE => 'PJI_REP_PC11'
129: , P_PLSQL_DRIVER => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC11'
130: , P_PLSQL_DRIVER_PARAMS => ' <>'||
131: ', <>'||
132: ', <>'||
133: ', <>'||

Line 142: END Get_SQL_PJI_REP_PC11;

138: ', <> '||
139: ', <> '||
140: ', <> ');
141:
142: END Get_SQL_PJI_REP_PC11;
143:
144:
145: /*
146: ** Contract Project Cost Detail

Line 240: , P_PLSQL_DRIVER => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC11'

236: , FACT.NON_BILL_COST_CHANGE_PRCNT "PJI_REP_MSR_18"'
237: , P_SQL_STATEMENT => x_PMV_Sql
238: , P_PMV_OUTPUT => x_PMV_Output
239: , P_REGION_CODE => 'PJI_REP_PC12'
240: , P_PLSQL_DRIVER => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC11'
241: , P_PLSQL_DRIVER_PARAMS => ' <>'||
242: ', <>'||
243: ', <>'||
244: ', <>'||

Line 2109: FUNCTION PLSQLDriver_PJI_REP_PC11(

2105: /*
2106: ** Contract Projects Trend Report and Contract Cumulative Trend Report
2107: */
2108:
2109: FUNCTION PLSQLDriver_PJI_REP_PC11(
2110: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
2111: , p_Organization IN VARCHAR2
2112: , p_Currency_Type IN VARCHAR2
2113: , p_As_Of_Date IN NUMBER

Line 2122: )RETURN PJI_REP_PC11_TBL

2118: , p_Report_Type IN VARCHAR2 DEFAULT NULL
2119: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
2120: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
2121: , p_Work_Type IN VARCHAR2 DEFAULT NULL
2122: )RETURN PJI_REP_PC11_TBL
2123: IS
2124: PRAGMA AUTONOMOUS_TRANSACTION;
2125:
2126: l_Project_Cost_Trend_Tab PJI_REP_PC11_TBL:=PJI_REP_PC11_TBL();

Line 2126: l_Project_Cost_Trend_Tab PJI_REP_PC11_TBL:=PJI_REP_PC11_TBL();

2122: )RETURN PJI_REP_PC11_TBL
2123: IS
2124: PRAGMA AUTONOMOUS_TRANSACTION;
2125:
2126: l_Project_Cost_Trend_Tab PJI_REP_PC11_TBL:=PJI_REP_PC11_TBL();
2127:
2128: l_Parse_Class_Codes VARCHAR2(1);
2129: l_Report_Cost_Type VARCHAR2(2);
2130:

Line 2205: SELECT PJI_REP_PC11(

2201: IF (l_Convert_Classification ='N')
2202: AND (l_Convert_Expenditure_Type = 'N')
2203: AND (l_Convert_Work_Type = 'N')
2204: THEN
2205: SELECT PJI_REP_PC11(
2206: TIME_ID
2207: , SUM( COST )
2208: , SUM( CT_COST )
2209: , NULL

Line 2319: SELECT PJI_REP_PC11(

2315: (l_Convert_Classification ='Y')
2316: AND (l_Convert_Expenditure_Type = 'N')
2317: AND (l_Convert_Work_Type = 'N')
2318: THEN
2319: SELECT PJI_REP_PC11(
2320: TIME_ID
2321: , SUM( COST )
2322: , SUM( CT_COST )
2323: , NULL

Line 2437: SELECT PJI_REP_PC11(

2433: AND (l_Convert_Expenditure_Type = 'Y')
2434: AND (l_Convert_Work_Type = 'N')
2435: THEN
2436:
2437: SELECT PJI_REP_PC11(
2438: TIME_ID
2439: , SUM( COST )
2440: , SUM( CT_COST )
2441: , NULL

Line 2553: SELECT PJI_REP_PC11(

2549: AND (l_Convert_Expenditure_Type = 'N')
2550: AND (l_Convert_Work_Type = 'Y')
2551: THEN
2552:
2553: SELECT PJI_REP_PC11(
2554: TIME_ID
2555: , SUM( COST )
2556: , SUM( CT_COST )
2557: , NULL

Line 2668: SELECT PJI_REP_PC11(

2664: (l_Convert_Classification ='Y')
2665: AND (l_Convert_Expenditure_Type = 'Y')
2666: AND (l_Convert_Work_Type = 'N')
2667: THEN
2668: SELECT PJI_REP_PC11(
2669: TIME_ID
2670: , SUM( COST )
2671: , SUM( CT_COST )
2672: , NULL

Line 2788: SELECT PJI_REP_PC11(

2784: (l_Convert_Classification ='N')
2785: AND (l_Convert_Expenditure_Type = 'Y')
2786: AND (l_Convert_Work_Type = 'Y')
2787: THEN
2788: SELECT PJI_REP_PC11(
2789: TIME_ID
2790: , SUM( COST )
2791: , SUM( CT_COST )
2792: , NULL

Line 2908: SELECT PJI_REP_PC11(

2904: (l_Convert_Classification ='Y')
2905: AND (l_Convert_Expenditure_Type = 'N')
2906: AND (l_Convert_Work_Type = 'Y')
2907: THEN
2908: SELECT PJI_REP_PC11(
2909: TIME_ID
2910: , SUM( COST )
2911: , SUM( CT_COST )
2912: , NULL

Line 3023: SELECT PJI_REP_PC11(

3019: ** and Work Type is specified
3020: */
3021:
3022: ELSE
3023: SELECT PJI_REP_PC11(
3024: TIME_ID
3025: , SUM( COST )
3026: , SUM( CT_COST )
3027: , NULL

Line 3258: END PLSQLDriver_PJI_REP_PC11;

3254:
3255: COMMIT;
3256: RETURN l_Project_Cost_Trend_Tab;
3257:
3258: END PLSQLDriver_PJI_REP_PC11;
3259:
3260:
3261:
3262: /*********************************************************************************