2: /* $Header: PJIRR02B.pls 120.2 2005/12/07 20:53:36 appldev ship $ */
3:
4: PROCEDURE Get_SQL_PJI_REP_UAP1(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5: , x_PMV_Sql OUT NOCOPY VARCHAR2
6: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7: IS
8: BEGIN
9:
10: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
57:
58:
59: PROCEDURE Get_SQL_PJI_REP_U1(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
60: , x_PMV_Sql OUT NOCOPY VARCHAR2
61: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
62: IS
63: BEGIN
64:
65: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
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
121:
122: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
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
161: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
162: IS
163: BEGIN
164:
165: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
212:
213:
214: PROCEDURE Get_SQL_PJI_REP_U4(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
215: , x_PMV_Sql OUT NOCOPY VARCHAR2
216: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
217: IS
218: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
219: BEGIN
220:
214: PROCEDURE Get_SQL_PJI_REP_U4(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
215: , x_PMV_Sql OUT NOCOPY VARCHAR2
216: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
217: IS
218: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
219: BEGIN
220:
221: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
222: ,P_SELECT_LIST =>
280:
281:
282: PROCEDURE Get_SQL_PJI_REP_U5(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
283: , x_PMV_Sql OUT NOCOPY VARCHAR2
284: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
285: IS
286: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
287: BEGIN
288:
282: PROCEDURE Get_SQL_PJI_REP_U5(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
283: , x_PMV_Sql OUT NOCOPY VARCHAR2
284: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
285: IS
286: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
287: BEGIN
288:
289: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
290: ,P_SELECT_LIST =>
5712: *****************************************************************************/
5713:
5714: PROCEDURE Get_SQL_PJI_REP_U6(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5715: , x_PMV_Sql OUT NOCOPY VARCHAR2
5716: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
5717: IS
5718: BEGIN
5719:
5720: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
6342: *
6343: *****************************************************************************/
6344: PROCEDURE Get_SQL_PJI_REP_U7(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6345: , x_PMV_Sql OUT NOCOPY VARCHAR2
6346: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6347: IS
6348: BEGIN
6349:
6350: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
7013: *****************************************************************************/
7014:
7015: PROCEDURE Get_SQL_PJI_REP_U8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
7016: , x_PMV_Sql OUT NOCOPY VARCHAR2
7017: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7018: IS
7019: BEGIN
7020:
7021: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl