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_CAPITAL_COST dependencies on PJI_REP_PC7

Line 66: procedure Get_SQL_PJI_REP_PC7 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL

62: *******************************
63: */
64:
65:
66: procedure Get_SQL_PJI_REP_PC7 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL
67: , x_PMV_Sql out nocopy VARCHAR2
68: , x_PMV_Output out nocopy BIS_QUERY_ATTRIBUTES_TBL)
69: is
70: begin

Line 92: , P_REGION_CODE => 'PJI_REP_PC7'

88: , FACT.CT_EXPENSE "PJI_REP_MSR_11"
89: , FACT.CT_EXPENSE "PJI_REP_MSR_25"
90: , FACT.EXPENSE_CHANGE_PRCNT "PJI_REP_MSR_12" '
91: , P_PMV_OUTPUT => x_PMV_Output
92: , P_REGION_CODE => 'PJI_REP_PC7'
93: , P_PLSQL_DRIVER => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC7'
94: , P_PLSQL_DRIVER_PARAMS => ' <>'||
95: ', <>'||
96: ', <>'||

Line 93: , P_PLSQL_DRIVER => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC7'

89: , FACT.CT_EXPENSE "PJI_REP_MSR_25"
90: , FACT.EXPENSE_CHANGE_PRCNT "PJI_REP_MSR_12" '
91: , P_PMV_OUTPUT => x_PMV_Output
92: , P_REGION_CODE => 'PJI_REP_PC7'
93: , P_PLSQL_DRIVER => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC7'
94: , P_PLSQL_DRIVER_PARAMS => ' <>'||
95: ', <>'||
96: ', <>'||
97: ', <>'||

Line 106: end Get_SQL_PJI_REP_PC7;

102: ', NULL'||
103: ', NULL'||
104: ', NULL'||
105: ', NULL');
106: end Get_SQL_PJI_REP_PC7;
107:
108: /*
109: ** Capital Project Cost Cumulative Trend
110: */

Line 142: , P_PLSQL_DRIVER => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC7'

138: , FACT.EXPENSE_CHANGE_PRCNT "PJI_REP_MSR_12" '
139: , P_SQL_STATEMENT => x_PMV_Sql
140: , P_PMV_OUTPUT => x_PMV_Output
141: , P_REGION_CODE => 'PJI_REP_PC8'
142: , P_PLSQL_DRIVER => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC7'
143: , P_PLSQL_DRIVER_PARAMS => ' <>'||
144: ', <>'||
145: ', <>'||
146: ', <>'||

Line 2179: function PLSQLDriver_PJI_REP_PC7(

2175: ** Capital Cost Trend Report and Capital Cost Cumulative Trend Report
2176: */
2177:
2178:
2179: function PLSQLDriver_PJI_REP_PC7(
2180: p_Operating_Unit IN VARCHAR2 default null
2181: , p_Organization IN VARCHAR2
2182: , p_Currency_Type IN VARCHAR2
2183: , p_As_Of_Date IN NUMBER

Line 2192: )return PJI_REP_PC7_TBL

2188: , p_Report_Type IN VARCHAR2 default null
2189: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
2190: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
2191: , p_Work_Type IN VARCHAR2 DEFAULT NULL
2192: )return PJI_REP_PC7_TBL
2193: is
2194: pragma autonomous_transaction;
2195:
2196: l_Project_Cost_Trend_Tab PJI_REP_PC7_TBL:=PJI_REP_PC7_TBL();

Line 2196: l_Project_Cost_Trend_Tab PJI_REP_PC7_TBL:=PJI_REP_PC7_TBL();

2192: )return PJI_REP_PC7_TBL
2193: is
2194: pragma autonomous_transaction;
2195:
2196: l_Project_Cost_Trend_Tab PJI_REP_PC7_TBL:=PJI_REP_PC7_TBL();
2197:
2198: l_Parse_Class_Codes VARCHAR2(1);
2199: l_Report_Cost_Type VARCHAR2(2);
2200:

Line 2264: select PJI_REP_PC7(

2260: IF (l_Convert_Classification ='N')
2261: AND (l_Convert_Expenditure_Type = 'N')
2262: AND (l_Convert_Work_Type = 'N')
2263: THEN
2264: select PJI_REP_PC7(
2265: TIME_ID
2266: , SUM ( COST )
2267: , SUM ( CT_COST )
2268: , SUM ( COST_CHANGE_PRCNT )

Line 2385: select PJI_REP_PC7(

2381: (l_Convert_Classification ='Y')
2382: AND (l_Convert_Expenditure_Type = 'N')
2383: AND (l_Convert_Work_Type = 'N')
2384: THEN
2385: select PJI_REP_PC7(
2386: TIME_ID
2387: , SUM ( COST )
2388: , SUM ( CT_COST )
2389: , SUM ( COST_CHANGE_PRCNT )

Line 2509: select PJI_REP_PC7(

2505: (l_Convert_Classification ='N')
2506: AND (l_Convert_Expenditure_Type = 'Y')
2507: AND (l_Convert_Work_Type = 'N')
2508: THEN
2509: select PJI_REP_PC7(
2510: TIME_ID
2511: , SUM ( COST )
2512: , SUM ( CT_COST )
2513: , SUM ( COST_CHANGE_PRCNT )

Line 2636: select PJI_REP_PC7(

2632: (l_Convert_Classification ='N')
2633: AND (l_Convert_Expenditure_Type = 'N')
2634: AND (l_Convert_Work_Type = 'Y')
2635: THEN
2636: select PJI_REP_PC7(
2637: TIME_ID
2638: , SUM ( COST )
2639: , SUM ( CT_COST )
2640: , SUM ( COST_CHANGE_PRCNT )

Line 2760: select PJI_REP_PC7(

2756: (l_Convert_Classification ='Y')
2757: AND (l_Convert_Expenditure_Type = 'Y')
2758: AND (l_Convert_Work_Type = 'N')
2759: THEN
2760: select PJI_REP_PC7(
2761: TIME_ID
2762: , SUM ( COST )
2763: , SUM ( CT_COST )
2764: , SUM ( COST_CHANGE_PRCNT )

Line 2891: select PJI_REP_PC7(

2887: (l_Convert_Classification ='N')
2888: AND (l_Convert_Expenditure_Type = 'Y')
2889: AND (l_Convert_Work_Type = 'Y')
2890: THEN
2891: select PJI_REP_PC7(
2892: TIME_ID
2893: , SUM ( COST )
2894: , SUM ( CT_COST )
2895: , SUM ( COST_CHANGE_PRCNT )

Line 3021: select PJI_REP_PC7(

3017: (l_Convert_Classification ='Y')
3018: AND (l_Convert_Expenditure_Type = 'N')
3019: AND (l_Convert_Work_Type = 'Y')
3020: THEN
3021: select PJI_REP_PC7(
3022: TIME_ID
3023: , SUM ( COST )
3024: , SUM ( CT_COST )
3025: , SUM ( COST_CHANGE_PRCNT )

Line 3146: select PJI_REP_PC7(

3142: ** and Work Type is specified
3143: */
3144:
3145: ELSE
3146: select PJI_REP_PC7(
3147: TIME_ID
3148: , SUM ( COST )
3149: , SUM ( CT_COST )
3150: , SUM ( COST_CHANGE_PRCNT )

Line 3338: END PLSQLDriver_PJI_REP_PC7;

3334: end if;
3335: END LOOP;
3336: COMMIT;
3337: RETURN l_Project_Cost_Trend_Tab;
3338: END PLSQLDriver_PJI_REP_PC7;
3339:
3340:
3341: /*
3342: ** Projects Capital Cost Detail Report