APPS.BOM_FILTER dependencies on BOM_FILTER

Line 1: PACKAGE BODY BOM_FILTER AS

1: PACKAGE BODY BOM_FILTER AS
2: /* $Header: BOMXRECB.pls 120.1 2005/06/01 19:04:52 appldev $ */
3: /*==========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 74: l_comps_in_filter BINARY_INTEGER := bom_filter.sort_order_t.COUNT;

70: END;
71:
72: PROCEDURE enableParents
73: AS
74: l_comps_in_filter BINARY_INTEGER := bom_filter.sort_order_t.COUNT;
75: l_sort_order VARCHAR2(2000);
76: l_st date := sysdate;
77: l_cnt number;
78: BEGIN

Line 84: l_sort_order := bom_filter.sort_order_t(comps);

80: LOOP
81: --
82: -- split the sort_order to get all the parents
83: --
84: l_sort_order := bom_filter.sort_order_t(comps);
85: l_cnt := floor(length(l_sort_order)/Bom_Common_Definitions.G_Bom_SortCode_Width) - 1;
86:
87: FOR ind IN 1..l_cnt
88: LOOP

Line 89: --bom_filter.sort_order_t.extend;

85: l_cnt := floor(length(l_sort_order)/Bom_Common_Definitions.G_Bom_SortCode_Width) - 1;
86:
87: FOR ind IN 1..l_cnt
88: LOOP
89: --bom_filter.sort_order_t.extend;
90: bom_filter.sort_order_t(bom_filter.sort_order_t.COUNT+1) :=
91: substr(l_sort_order,1,(ind*Bom_Common_Definitions.G_Bom_SortCode_Width));
92: END LOOP;
93: END LOOP;

Line 90: bom_filter.sort_order_t(bom_filter.sort_order_t.COUNT+1) :=

86:
87: FOR ind IN 1..l_cnt
88: LOOP
89: --bom_filter.sort_order_t.extend;
90: bom_filter.sort_order_t(bom_filter.sort_order_t.COUNT+1) :=
91: substr(l_sort_order,1,(ind*Bom_Common_Definitions.G_Bom_SortCode_Width));
92: END LOOP;
93: END LOOP;
94:

Line 140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);

136: , DBMS_SQL.NATIVE
137: );
138:
139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);
140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);
141: /*
142: DBMS_SQL.PARSE
143: ( filter_cursor
144: , 'SELECT ST_ORDER sort_order ' ||

Line 169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);

165: LOOP
166: -- fetch a row
167: rows_processed := dbms_sql.fetch_rows(filter_cursor);
168: -- fetch columns from the row
169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);
170: EXIT WHEN rows_processed <> 1000;
171:
172: END LOOP;
173: DBMS_SQL.CLOSE_CURSOR(filter_cursor);

Line 175: applyFilter(bom_filter.sort_order_t, p_GroupId);

171:
172: END LOOP;
173: DBMS_SQL.CLOSE_CURSOR(filter_cursor);
174: enableParents;
175: applyFilter(bom_filter.sort_order_t, p_GroupId);
176: EXCEPTION
177: WHEN OTHERS THEN
178: IF (DBMS_SQL.IS_OPEN(filter_cursor))
179: THEN

Line 186: END bom_filter;

182: RAISE;
183: END applyFilter;
184: /* Procedure Apply filter Ends */
185:
186: END bom_filter;