APPS.PJI_PMV_PROFITABILITY dependencies on PJI_REP_PPDTL

Line 283: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPDTL'

279: , FACT.PJI_REP_TOTAL_4 "PJI_REP_TOTAL_10" '
280: , P_SQL_STATEMENT => x_PMV_Sql
281: , P_PMV_OUTPUT => x_PMV_Output
282: , p_Region_Code => 'PJI_REP_PP9'
283: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPDTL'
284: , p_PLSQL_Driver_Params => ' <>'||
285: ', <>'||
286: ', <>'||
287: ', <>'||

Line 333: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPDTL'

329: , FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_5" '
330: , P_SQL_STATEMENT => x_PMV_Sql
331: , P_PMV_OUTPUT => x_PMV_Output
332: , p_Region_Code =>'PJI_REP_PP10'
333: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPDTL'
334: , p_PLSQL_Driver_Params => ' <>'||
335: ', <>'||
336: ', <>'||
337: ', <>'||

Line 3122: /* Name: PLSQLDriver_PJI_REP_PPDTL

3118:
3119:
3120:
3121:
3122: /* Name: PLSQLDriver_PJI_REP_PPDTL
3123: ** Type: Function
3124: **
3125: ** Description: This function receives PM Viewer runtime query parameters
3126: ** and RETURNS a PL/SQL table for the PM Viewer report.

Line 3149: ** PJI_REP_PPDTL_TBL (table of db object PJI_REP_PPDTL)

3145: ** Called subprograms:
3146: ** Various PJI_PMV_ENGINE.Convert APIs
3147: **
3148: ** Called objects:
3149: ** PJI_REP_PPDTL_TBL (table of db object PJI_REP_PPDTL)
3150: **
3151: ** History:
3152: ** 03-JUN-2002 jwhite Created.
3153: */

Line 3155: FUNCTION PLSQLDriver_PJI_REP_PPDTL(

3151: ** History:
3152: ** 03-JUN-2002 jwhite Created.
3153: */
3154:
3155: FUNCTION PLSQLDriver_PJI_REP_PPDTL(
3156: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
3157: , p_Organization IN VARCHAR2
3158: , p_Currency_Type IN VARCHAR2
3159: , p_As_of_Date IN NUMBER

Line 3172: ) RETURN PJI_REP_PPDTL_TBL

3168: , p_Revenue_Category IN VARCHAR2 DEFAULT NULL
3169: , p_Revenue_Type IN VARCHAR2 DEFAULT NULL
3170: , p_Work_Type IN VARCHAR2 DEFAULT NULL
3171:
3172: ) RETURN PJI_REP_PPDTL_TBL
3173: IS
3174:
3175: PRAGMA AUTONOMOUS_TRANSACTION;
3176:

Line 3180: l_detail_tab PJI_REP_PPDTL_TBL := PJI_REP_PPDTL_TBL();

3176:
3177: /*
3178: ** PL/SQL Declaration
3179: */
3180: l_detail_tab PJI_REP_PPDTL_TBL := PJI_REP_PPDTL_TBL();
3181:
3182: l_Total_Revenue NUMBER := 0;
3183: l_Total_Cost NUMBER := 0;
3184: l_Total_Bgt_Revenue NUMBER := 0;

Line 3312: SELECT PJI_REP_PPDTL(PROJECT_ID

3308: THEN
3309:
3310:
3311:
3312: SELECT PJI_REP_PPDTL(PROJECT_ID
3313: , NULL
3314: , NULL
3315: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3316: , NULL

Line 3376: SELECT PJI_REP_PPDTL(PROJECT_ID

3372: and (l_Convert_Work_Type = 'N')
3373:
3374: THEN
3375:
3376: SELECT PJI_REP_PPDTL(PROJECT_ID
3377: , NULL
3378: , NULL
3379: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3380: , NULL

Line 3436: SELECT PJI_REP_PPDTL(PROJECT_ID

3432: and (l_Convert_Work_Type = 'N')
3433: THEN
3434:
3435:
3436: SELECT PJI_REP_PPDTL(PROJECT_ID
3437: , NULL
3438: , NULL
3439: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3440: , NULL

Line 3498: SELECT PJI_REP_PPDTL(PROJECT_ID

3494: and (l_Convert_Event_Revenue_Type = 'N')
3495: THEN
3496:
3497:
3498: SELECT PJI_REP_PPDTL(PROJECT_ID
3499: , NULL
3500: , NULL
3501: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3502: , NULL

Line 3556: SELECT PJI_REP_PPDTL(PROJECT_ID

3552: THEN
3553:
3554:
3555:
3556: SELECT PJI_REP_PPDTL(PROJECT_ID
3557: , NULL
3558: , NULL
3559: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3560: , NULL

Line 3617: SELECT PJI_REP_PPDTL(PROJECT_ID

3613: THEN
3614:
3615:
3616:
3617: SELECT PJI_REP_PPDTL(PROJECT_ID
3618: , NULL
3619: , NULL
3620: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3621: , NULL

Line 3681: SELECT PJI_REP_PPDTL(PROJECT_ID

3677: THEN
3678:
3679:
3680:
3681: SELECT PJI_REP_PPDTL(PROJECT_ID
3682: , NULL
3683: , NULL
3684: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3685: , NULL

Line 3737: SELECT PJI_REP_PPDTL(PROJECT_ID

3733:
3734: ELSE
3735:
3736:
3737: SELECT PJI_REP_PPDTL(PROJECT_ID
3738: , NULL
3739: , NULL
3740: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3741: , NULL

Line 3912: END PLSQLDriver_PJI_REP_PPDTL;

3908:
3909: RETURN l_detail_tab;
3910:
3911:
3912: END PLSQLDriver_PJI_REP_PPDTL;
3913:
3914:
3915:
3916: