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_PROFITABILITY dependencies on PJI_REP_PP3

Line 132: PROCEDURE GET_SQL_PJI_REP_PP3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

128: ', NULL'
129: );
130: END GET_SQL_PJI_REP_PP2;
131:
132: PROCEDURE GET_SQL_PJI_REP_PP3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
133: , x_PMV_Sql OUT NOCOPY VARCHAR2
134: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
135: IS
136: l_Err_Message VARCHAR2(3200);

Line 168: , p_Region_Code => 'PJI_REP_PP3'

164: , FACT.PJI_REP_URL1 "PJI_REP_URL1"
165: , FACT.PJI_REP_URL2 "PJI_REP_URL2" '
166: , P_SQL_STATEMENT => x_PMV_Sql
167: , P_PMV_OUTPUT => x_PMV_Output
168: , p_Region_Code => 'PJI_REP_PP3'
169: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PP3'
170: , p_PLSQL_Driver_Params => ' <>'||
171: ', <>'||
172: ', <>'||

Line 169: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PP3'

165: , FACT.PJI_REP_URL2 "PJI_REP_URL2" '
166: , P_SQL_STATEMENT => x_PMV_Sql
167: , P_PMV_OUTPUT => x_PMV_Output
168: , p_Region_Code => 'PJI_REP_PP3'
169: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PP3'
170: , p_PLSQL_Driver_Params => ' <>'||
171: ', <>'||
172: ', <>'||
173: ', <>'||

Line 184: END GET_SQL_PJI_REP_PP3;

180: ', <>'||
181: ', <>'||
182: ', NULL'
183: );
184: END GET_SQL_PJI_REP_PP3;
185:
186:
187: PROCEDURE GET_SQL_PJI_REP_PP4(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
188: , x_PMV_Sql OUT NOCOPY VARCHAR2

Line 356: /* Name: PLSQLDriver_PJI_REP_PP3

352: ** -- PLSQL DRIVERS
353: */ -------------------------------------------------------------+
354:
355:
356: /* Name: PLSQLDriver_PJI_REP_PP3
357: ** Type: Function
358: **
359: ** Description: This function receives PM Viewer runtime query parameters
360: ** and RETURNS a PL/SQL table for the PM Viewer report.

Line 377: ** PJI_REP_PP3_TBL (table of db object PJI_REP_PP3)

373: ** Called subprograms:
374: ** Various PJI_PMV_ENGINE.Convert APIs
375: **
376: ** Called objects:
377: ** PJI_REP_PP3_TBL (table of db object PJI_REP_PP3)
378: **
379: ** History:
380: ** 21-MAY-2002 jwhite Created.
381: **

Line 390: FUNCTION PLSQLDriver_PJI_REP_PP3(

386: ** P_REPORT_TYPE => 'DBI'
387: **
388: */
389:
390: FUNCTION PLSQLDriver_PJI_REP_PP3(
391: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
392: , p_Organization IN VARCHAR2
393: , p_Currency_Type IN VARCHAR2
394: , p_As_of_Date IN NUMBER

Line 406: ) RETURN PJI_REP_PP3_TBL

402: , p_Revenue_Category IN VARCHAR2 DEFAULT NULL
403: , p_Revenue_Type IN VARCHAR2 DEFAULT NULL
404: , p_Work_Type IN VARCHAR2 DEFAULT NULL
405:
406: ) RETURN PJI_REP_PP3_TBL
407: IS
408:
409: PRAGMA AUTONOMOUS_TRANSACTION;
410:

Line 443: l_phase_tab PJI_REP_PP3_TBL := PJI_REP_PP3_TBL();

439:
440: /*
441: ** PL/SQL Declaration
442: */
443: l_phase_tab PJI_REP_PP3_TBL := PJI_REP_PP3_TBL();
444:
445:
446:
447: BEGIN

Line 551: SELECT PJI_REP_PP3(PHASE_CODE

547: and (l_Convert_Work_Type = 'N')
548: THEN
549:
550:
551: SELECT PJI_REP_PP3(PHASE_CODE
552: ,AMOUNT_TYPE_CODE
553: ,AMOUNT_TYPE_LABEL
554: , SUM( P_ACTUAL )
555: , NULL

Line 827: SELECT PJI_REP_PP3(PHASE_CODE

823: and (l_Convert_Work_Type = 'N')
824:
825: THEN
826:
827: SELECT PJI_REP_PP3(PHASE_CODE
828: ,AMOUNT_TYPE_CODE
829: ,AMOUNT_TYPE_LABEL
830: , SUM( P_ACTUAL )
831: , NULL

Line 1111: SELECT PJI_REP_PP3(PHASE_CODE

1107: ELSIF (l_Convert_Classification = 'N')
1108: and (l_Convert_Work_Type = 'N')
1109: THEN
1110:
1111: SELECT PJI_REP_PP3(PHASE_CODE
1112: ,AMOUNT_TYPE_CODE
1113: ,AMOUNT_TYPE_LABEL
1114: , SUM( P_ACTUAL )
1115: , NULL

Line 1392: SELECT PJI_REP_PP3(PHASE_CODE

1388: ELSIF (l_Convert_Classification = 'N')
1389: and (l_Convert_Event_Revenue_Type = 'N')
1390: THEN
1391:
1392: SELECT PJI_REP_PP3(PHASE_CODE
1393: ,AMOUNT_TYPE_CODE
1394: ,AMOUNT_TYPE_LABEL
1395: , SUM( P_ACTUAL )
1396: , NULL

Line 1664: SELECT PJI_REP_PP3(PHASE_CODE

1660:
1661: ELSIF (l_Convert_Work_Type = 'N')
1662: THEN
1663:
1664: SELECT PJI_REP_PP3(PHASE_CODE
1665: ,AMOUNT_TYPE_CODE
1666: ,AMOUNT_TYPE_LABEL
1667: , SUM( P_ACTUAL )
1668: , NULL

Line 1957: SELECT PJI_REP_PP3(PHASE_CODE

1953:
1954: ELSIF (l_Convert_Classification = 'N')
1955: THEN
1956:
1957: SELECT PJI_REP_PP3(PHASE_CODE
1958: ,AMOUNT_TYPE_CODE
1959: ,AMOUNT_TYPE_LABEL
1960: , SUM( P_ACTUAL )
1961: , NULL

Line 2246: SELECT PJI_REP_PP3(PHASE_CODE

2242:
2243: ELSIF (l_Convert_Event_Revenue_Type = 'N')
2244: THEN
2245:
2246: SELECT PJI_REP_PP3(PHASE_CODE
2247: ,AMOUNT_TYPE_CODE
2248: ,AMOUNT_TYPE_LABEL
2249: , SUM( P_ACTUAL )
2250: , NULL

Line 2527: SELECT PJI_REP_PP3(PHASE_CODE

2523: /* ----------------------------------- Case 8 truth table ------------------------------------- */
2524:
2525: ELSE
2526:
2527: SELECT PJI_REP_PP3(PHASE_CODE
2528: ,AMOUNT_TYPE_CODE
2529: ,AMOUNT_TYPE_LABEL
2530: , SUM( P_ACTUAL )
2531: , NULL

Line 2975: l_phase_tab(4):=PJI_REP_PP3(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

2971: */
2972: l_phase_tab.extend;
2973:
2974:
2975: l_phase_tab(4):=PJI_REP_PP3(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
2976: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
2977: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
2978:
2979: i := 4;

Line 3112: END PLSQLDriver_PJI_REP_PP3;

3108:
3109: RETURN l_phase_tab;
3110:
3111:
3112: END PLSQLDriver_PJI_REP_PP3;
3113:
3114:
3115:
3116: