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_PC13

Line 150: PROCEDURE GET_SQL_PJI_REP_PC13(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

146: ** Contract Project Cost Detail
147: */
148:
149:
150: PROCEDURE GET_SQL_PJI_REP_PC13(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
151: , x_PMV_Sql OUT NOCOPY VARCHAR2
152: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
153: IS
154: l_Err_Message VARCHAR2(3200);

Line 183: , p_Region_Code => 'PJI_REP_PC13'

179: , FACT.PJI_REP_TOTAL_5 "PJI_REP_TOTAL_5"
180: , FACT.PJI_REP_TOTAL_6 "PJI_REP_TOTAL_6" '
181: , P_SQL_STATEMENT => x_PMV_Sql
182: , P_PMV_OUTPUT => x_PMV_Output
183: , p_Region_Code => 'PJI_REP_PC13'
184: , p_PLSQL_Driver => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC13'
185: , p_PLSQL_Driver_Params => ' <>'||
186: ', <>'||
187: ', <>'||

Line 184: , p_PLSQL_Driver => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC13'

180: , FACT.PJI_REP_TOTAL_6 "PJI_REP_TOTAL_6" '
181: , P_SQL_STATEMENT => x_PMV_Sql
182: , P_PMV_OUTPUT => x_PMV_Output
183: , p_Region_Code => 'PJI_REP_PC13'
184: , p_PLSQL_Driver => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC13'
185: , p_PLSQL_Driver_Params => ' <>'||
186: ', <>'||
187: ', <>'||
188: ', <>'||

Line 198: END GET_SQL_PJI_REP_PC13;

194: ', <> '||
195: ', <> '||
196: ', <> '
197: );
198: END GET_SQL_PJI_REP_PC13;
199:
200: /*
201: ** Capital Project Cost Cumulative Trend
202: */

Line 3274: FUNCTION PLSQLDriver_PJI_REP_PC13(

3270: **********************************************************************************
3271: */
3272:
3273:
3274: FUNCTION PLSQLDriver_PJI_REP_PC13(
3275: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
3276: , p_Organization IN VARCHAR2
3277: , p_Currency_Type IN VARCHAR2
3278: , p_As_of_Date IN NUMBER

Line 3287: ) RETURN PJI_REP_PC13_TBL

3283: , p_Project_IDS IN VARCHAR2 DEFAULT NULL
3284: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
3285: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
3286: , p_Work_Type IN VARCHAR2 DEFAULT NULL
3287: ) RETURN PJI_REP_PC13_TBL
3288: IS
3289:
3290: PRAGMA AUTONOMOUS_TRANSACTION;
3291:

Line 3295: l_detail_tab PJI_REP_PC13_TBL := PJI_REP_PC13_TBL();

3291:
3292: /*
3293: ** PL/SQL Declaration
3294: */
3295: l_detail_tab PJI_REP_PC13_TBL := PJI_REP_PC13_TBL();
3296:
3297: l_Cost NUMBER := 0;
3298: l_Bill_Cost NUMBER := 0;
3299: l_Bill_Cost_Prcnt_Of_Cost NUMBER := 0;

Line 3409: SELECT PJI_REP_PC13 (PROJECT_ID

3405: IF (l_Convert_Classification = 'N')
3406: and (l_Convert_Expenditure_Type = 'N')
3407: and (l_Convert_Work_Type = 'N')
3408: THEN
3409: SELECT PJI_REP_PC13 (PROJECT_ID
3410: , NULL
3411: , NULL
3412: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3413: , NULL

Line 3466: SELECT PJI_REP_PC13 (PROJECT_ID

3462: ELSIF (l_Convert_Classification = 'Y')
3463: and (l_Convert_Expenditure_Type = 'N')
3464: and (l_Convert_Work_Type = 'N')
3465: THEN
3466: SELECT PJI_REP_PC13 (PROJECT_ID
3467: , NULL
3468: , NULL
3469: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3470: , NULL

Line 3526: SELECT PJI_REP_PC13 (PROJECT_ID

3522: ELSIF (l_Convert_Classification = 'N')
3523: and (l_Convert_Expenditure_Type = 'Y')
3524: and (l_Convert_Work_Type = 'N')
3525: THEN
3526: SELECT PJI_REP_PC13 (PROJECT_ID
3527: , NULL
3528: , NULL
3529: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3530: , NULL

Line 3585: SELECT PJI_REP_PC13 (PROJECT_ID

3581: and (l_Convert_Expenditure_Type = 'N')
3582: and (l_Convert_Work_Type = 'Y')
3583: THEN
3584:
3585: SELECT PJI_REP_PC13 (PROJECT_ID
3586: , NULL
3587: , NULL
3588: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3589: , NULL

Line 3644: SELECT PJI_REP_PC13 (PROJECT_ID

3640: and (l_Convert_Expenditure_Type = 'Y')
3641: and (l_Convert_Work_Type = 'N')
3642: THEN
3643:
3644: SELECT PJI_REP_PC13 (PROJECT_ID
3645: , NULL
3646: , NULL
3647: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3648: , NULL

Line 3703: SELECT PJI_REP_PC13 (PROJECT_ID

3699: and (l_Convert_Expenditure_Type = 'Y')
3700: and (l_Convert_Work_Type = 'Y')
3701: THEN
3702:
3703: SELECT PJI_REP_PC13 (PROJECT_ID
3704: , NULL
3705: , NULL
3706: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3707: , NULL

Line 3762: THEN SELECT PJI_REP_PC13 (PROJECT_ID

3758:
3759: ELSIF (l_Convert_Classification = 'Y')
3760: and (l_Convert_Expenditure_Type = 'N')
3761: and (l_Convert_Work_Type = 'Y')
3762: THEN SELECT PJI_REP_PC13 (PROJECT_ID
3763: , NULL
3764: , NULL
3765: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3766: , NULL

Line 3812: SELECT PJI_REP_PC13 (PROJECT_ID

3808: GROUP BY PROJECT_ID,ORGANIZATION_ID;
3809:
3810: ELSE
3811:
3812: SELECT PJI_REP_PC13 (PROJECT_ID
3813: , NULL
3814: , NULL
3815: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3816: , NULL

Line 3947: END PLSQLDriver_PJI_REP_PC13;

3943:
3944: RETURN l_detail_tab;
3945:
3946:
3947: END PLSQLDriver_PJI_REP_PC13;
3948:
3949:
3950: END PJI_PMV_COST;