APPS.BIS_PMV_APPROVALS_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 19: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;

Line 104: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 179: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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);

Line 282: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

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;