DBA Data[Home] [Help]

APPS.PJI_PMV_COST dependencies on BIS_QUERY_ATTRIBUTES

Line 14: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

10: */
11:
12: PROCEDURE GET_SQL_PJI_REP_PC10(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
13: , x_PMV_Sql OUT NOCOPY VARCHAR2
14: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
15: IS
16: l_Err_Message VARCHAR2(3200);
17: l_PMV_Sql VARCHAR2(3200);
18: BEGIN

Line 97: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

93: */
94:
95: PROCEDURE Get_SQL_PJI_REP_PC11 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
96: , x_PMV_Sql OUT NOCOPY VARCHAR2
97: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
98: IS
99: BEGIN
100: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
101: , P_SQL_STATEMENT => x_PMV_Sql

Line 152: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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);
155: l_PMV_Sql VARCHAR2(3200);
156: BEGIN

Line 207: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

203:
204:
205: PROCEDURE Get_SQL_PJI_REP_PC12(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
206: , x_PMV_Sql OUT NOCOPY VARCHAR2
207: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
208: IS
209: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
210: BEGIN
211: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

Line 209: l_PMV_Rec BIS_QUERY_ATTRIBUTES;

205: PROCEDURE Get_SQL_PJI_REP_PC12(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
206: , x_PMV_Sql OUT NOCOPY VARCHAR2
207: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
208: IS
209: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
210: BEGIN
211: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
212: , P_SELECT_LIST =>
213: ' FACT.COST "PJI_REP_MSR_1"