APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U2

Line 116: PROCEDURE Get_SQL_PJI_REP_U2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

112: '<>');
113: END Get_SQL_PJI_REP_U1;
114:
115:
116: PROCEDURE Get_SQL_PJI_REP_U2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
117: , x_PMV_Sql OUT NOCOPY VARCHAR2
118: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
119: IS
120: BEGIN

Line 149: P_REGION_CODE => 'PJI_REP_U2',

145: FACT.ACT_UTIL_PERCENT "PJI_REP_MSR_25",
146: FACT.SCH_UTIL_PERCENT "PJI_REP_MSR_26" '
147: ,P_SQL_STATEMENT => x_PMV_Sql
148: ,P_PMV_OUTPUT => x_PMV_Output,
149: P_REGION_CODE => 'PJI_REP_U2',
150: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U2',
151: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
152: '<>, ' ||
153: '<>, ' ||

Line 156: END Get_SQL_PJI_REP_U2;

152: '<>, ' ||
153: '<>, ' ||
154: '<>, ' ||
155: '<>');
156: END Get_SQL_PJI_REP_U2;
157:
158:
159: PROCEDURE Get_SQL_PJI_REP_U3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
160: , x_PMV_Sql OUT NOCOPY VARCHAR2

Line 1925: ) RETURN PJI_REP_U2_TBL

1921: p_organization IN VARCHAR2,
1922: p_as_of_date IN NUMBER,
1923: p_period_type IN VARCHAR2,
1924: p_view_by IN VARCHAR2
1925: ) RETURN PJI_REP_U2_TBL
1926: IS
1927: PRAGMA AUTONOMOUS_TRANSACTION;
1928: l_u2_tbl PJI_REP_U2_TBL:=PJI_REP_U2_TBL();
1929: l_denominator VARCHAR2(25);

Line 1928: l_u2_tbl PJI_REP_U2_TBL:=PJI_REP_U2_TBL();

1924: p_view_by IN VARCHAR2
1925: ) RETURN PJI_REP_U2_TBL
1926: IS
1927: PRAGMA AUTONOMOUS_TRANSACTION;
1928: l_u2_tbl PJI_REP_U2_TBL:=PJI_REP_U2_TBL();
1929: l_denominator VARCHAR2(25);
1930: l_labor_unit VARCHAR2(40);
1931: l_Top_Org_Index NUMBER;
1932: l_Top_Organization_Name VARCHAR2(240);

Line 1964: SELECT PJI_REP_U2(org_id,

1960: EXCEPTION WHEN OTHERS THEN
1961: l_labor_unit := null;
1962: END;
1963:
1964: SELECT PJI_REP_U2(org_id,
1965: organization_id,
1966: time_id,
1967: time_key,
1968: sum(actual_capacity_hours),