[Home] [Help]
15: -- 12/02/05 nkishore Initial creation --
16: ----------------------------------------------------------------------------
17: PROCEDURE APPROVALS_SQL (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
18: ,x_custom_sql OUT NOCOPY VARCHAR2
19: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
20: l_sql varchar2(5000);
21: l_exp_url varchar2(1000);
22: l_req_url varchar2(1000);
23: l_custom_rec BIS_QUERY_ATTRIBUTES;
19: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
20: l_sql varchar2(5000);
21: l_exp_url varchar2(1000);
22: l_req_url varchar2(1000);
23: l_custom_rec BIS_QUERY_ATTRIBUTES;
24: l_bind_ctr NUMBER;
25: l_code_table BISVIEWER.t_char;
26: l_meaning_table BISVIEWER.t_char;
27: l_type_where VARCHAR2(1000);
100: FETCH getApprovalTypes BULK COLLECT INTO l_code_table, l_meaning_table;
101: CLOSE getApprovalTypes;
102:
103: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
104: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
105: l_bind_ctr := 1;
106: l_first := true;
107:
108: IF l_msg_types IS NOT NULL AND l_msg_types.COUNT >0 THEN
175: END APPROVALS_SQL;
176:
177: PROCEDURE APPROVALS_DETAIL_SQL (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
178: ,x_custom_sql OUT NOCOPY VARCHAR2
179: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
180: l_sql varchar2(5000);
181: l_drill_url varchar2(1000);
182: l_status varchar2(30);
183: l_msg_type varchar2(80);
183: l_msg_type varchar2(80);
184: l_status_where varchar2(250);
185: l_type_where varchar2(250);
186: l_orderby VARCHAR2(250);
187: l_custom_rec BIS_QUERY_ATTRIBUTES;
188: l_bind_ctr NUMBER;
189: l_code_table BISVIEWER.t_char;
190: l_types VARCHAR2(250);
191: l_select_clause VARCHAR2(2000);
278: l_sql := l_sql || l_orderby;
279: x_custom_sql := l_sql;
280:
281: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
282: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
283:
284: l_bind_ctr := 1;
285: l_custom_rec.attribute_name := ':msg_type';
286: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;