10: */
11:
12: procedure GET_SQL_PJI_REP_PC6(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
64:
65:
66: procedure Get_SQL_PJI_REP_PC7 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL
67: , x_PMV_Sql out nocopy VARCHAR2
68: , x_PMV_Output out nocopy BIS_QUERY_ATTRIBUTES_TBL)
69: is
70: begin
71: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
72: , P_SQL_STATEMENT => x_PMV_Sql
111:
112:
113: PROCEDURE Get_SQL_PJI_REP_PC8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
114: , x_PMV_Sql OUT NOCOPY VARCHAR2
115: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
116: IS
117: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
118: BEGIN
119: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
170:
171:
172: PROCEDURE GET_SQL_PJI_REP_PC9(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
173: , x_PMV_Sql OUT NOCOPY VARCHAR2
174: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
175: IS
176: l_Err_Message VARCHAR2(3200);
177: l_PMV_Sql VARCHAR2(3200);
178: BEGIN