47: , FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_16" '
48: , P_SQL_STATEMENT => x_PMV_Sql
49: , P_PMV_OUTPUT => x_PMV_Output
50: , p_Region_Code => 'PJI_REP_PP1'
51: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPSUM'
52: , p_PLSQL_Driver_Params => ' <
53: ', <
54: ', <
55: ', <
110: , FACT.PJI_REP_TOTAL_17 "PJI_REP_TOTAL_16" '
111: , P_SQL_STATEMENT => x_PMV_Sql
112: , P_PMV_OUTPUT => x_PMV_Output
113: , p_Region_Code => 'PJI_REP_PP2'
114: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPSUM'
115: , p_PLSQL_Driver_Params => ' <
116: ', <
117: ', <
118: ', <
216: , FACT.PJI_REP_TOTAL_21 "PJI_REP_TOTAL_10" '
217: , P_SQL_STATEMENT => x_PMV_Sql
218: , P_PMV_OUTPUT => x_PMV_Output
219: , p_Region_Code => 'PJI_REP_PP4'
220: , p_PLSQL_Driver => 'PJI_PMV_PROFITABILITY.PLSQLDriver_PJI_REP_PPSUM'
221: , p_PLSQL_Driver_Params => ' <
222: ', <
223: ', <
224: ', <
3913:
3914:
3915:
3916:
3917: /* Name: PLSQLDriver_PJI_REP_PPSUM
3918: ** Type: Function
3919: **
3920: ** Description: This function receives PM Viewer runtime query parameters
3921: ** and RETURNS a PL/SQL table for the PM Viewer report.
3932: ** Called subprograms:
3933: ** Various PJI_PMV_ENGINE.Convert APIs
3934: **
3935: ** Called objects:
3936: ** PJI_REP_PPSUM_TBL (table of db object PJI_REP_PPSUM)
3937: **
3938: ** History:
3939: ** 06-JUN-2002 jwhite Created.
3940: */
3938: ** History:
3939: ** 06-JUN-2002 jwhite Created.
3940: */
3941:
3942: FUNCTION PLSQLDriver_PJI_REP_PPSUM(
3943: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
3944: , p_Organization IN VARCHAR2
3945: , p_Currency_Type IN VARCHAR2
3946: , p_As_of_Date IN NUMBER
3955: , p_Revenue_Category IN VARCHAR2 DEFAULT NULL
3956: , p_Revenue_Type IN VARCHAR2 DEFAULT NULL
3957: , p_Work_Type IN VARCHAR2 DEFAULT NULL
3958:
3959: ) RETURN PJI_REP_PPSUM_TBL
3960: IS
3961:
3962: PRAGMA AUTONOMOUS_TRANSACTION;
3963:
4000: l_curr_record_type_id NUMBER:= 1;
4001: /*
4002: ** -- PL/SQL Declaration
4003: */
4004: l_lines_tab PJI_REP_PPSUM_TBL := PJI_REP_PPSUM_TBL();
4005:
4006:
4007: BEGIN
4008: BEGIN
4100: and (l_Convert_Work_Type = 'N')
4101: THEN
4102:
4103:
4104: SELECT PJI_REP_PPSUM(ORG_ID
4105: , ORGANIZATION_ID
4106: , PROJECT_CLASS_ID
4107: , EXPENDITURE_CATEGORY
4108: , EXPENDITURE_TYPE_ID
4293: and (l_Convert_Work_Type = 'N')
4294:
4295: THEN
4296:
4297: SELECT PJI_REP_PPSUM(ORG_ID
4298: , ORGANIZATION_ID
4299: , PROJECT_CLASS_ID
4300: , EXPENDITURE_CATEGORY
4301: , EXPENDITURE_TYPE_ID
4504: ELSIF (l_Convert_Classification = 'N')
4505: and (l_Convert_Work_Type = 'N')
4506: THEN
4507:
4508: SELECT PJI_REP_PPSUM(ORG_ID
4509: , ORGANIZATION_ID
4510: , PROJECT_CLASS_ID
4511: , EXPENDITURE_CATEGORY
4512: , EXPENDITURE_TYPE_ID
4707: and (l_Convert_Expenditure_Type = 'N')
4708: and (l_Convert_Event_Revenue_Type = 'N')
4709: THEN
4710:
4711: SELECT PJI_REP_PPSUM(ORG_ID
4712: , ORGANIZATION_ID
4713: , PROJECT_CLASS_ID
4714: , EXPENDITURE_CATEGORY
4715: , EXPENDITURE_TYPE_ID
4905:
4906: ELSIF (l_Convert_Work_Type = 'N')
4907: THEN
4908:
4909: SELECT PJI_REP_PPSUM(ORG_ID
4910: , ORGANIZATION_ID
4911: , PROJECT_CLASS_ID
4912: , EXPENDITURE_CATEGORY
4913: , EXPENDITURE_TYPE_ID
5132:
5133: ELSIF (l_Convert_Classification = 'N')
5134: THEN
5135:
5136: SELECT PJI_REP_PPSUM(ORG_ID
5137: , ORGANIZATION_ID
5138: , PROJECT_CLASS_ID
5139: , EXPENDITURE_CATEGORY
5140: , EXPENDITURE_TYPE_ID
5361: ELSIF (l_Convert_Expenditure_Type = 'N')
5362: and (l_Convert_Event_Revenue_Type = 'N')
5363: THEN
5364:
5365: SELECT PJI_REP_PPSUM(ORG_ID
5366: , ORGANIZATION_ID
5367: , PROJECT_CLASS_ID
5368: , EXPENDITURE_CATEGORY
5369: , EXPENDITURE_TYPE_ID
5585: /* ----------------------------------- Case 8 truth table ------------------------------------- */
5586:
5587: ELSE
5588:
5589: SELECT PJI_REP_PPSUM(ORG_ID
5590: , ORGANIZATION_ID
5591: , PROJECT_CLASS_ID
5592: , EXPENDITURE_CATEGORY
5593: , EXPENDITURE_TYPE_ID
6242:
6243: RETURN l_lines_tab;
6244:
6245:
6246: END PLSQLDriver_PJI_REP_PPSUM;
6247:
6248: END PJI_PMV_PROFITABILITY;
6249: