PACKAGE: APPS.BOM_FILTER

Source

1 PACKAGE BOM_FILTER AUTHID CURRENT_USER AS
2 /* $Header: BOMXRECS.pls 120.1 2005/09/28 04:48:02 earumuga noship $ */
3 /*==========================================================================+
4 |   Copyright (c) 2003 Oracle Corporation Belmont, California, USA          |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMXRECS.pls                                               |
9 | DESCRIPTION  : Procedure explores and marks the parent items in 	    |
10 |		 BOM_EXPLOSION_TEMP table.
11 | Parameters   :	p_ParamSortOrder  Sort Order Array	            |
12 |			p_GroupId	  Explosion Group ID		    |
13 |			x_ResultSortOrder Resultant Sort Order Array 	    |
14 |									    |
15 | Revision								    |
16 | 2003/10/22	Ajay			creation			    |
17 | 2004/1/16	Ajay			Modified the method to only update  |
18 |					the row with flag.		    |
19 |                                                                           |
20 +==========================================================================*/
21 
22    TYPE PARAM_LIST IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
23 
24    --sort_order_t sort_order;
25    sort_order_t DBMS_SQL.VARCHAR2_TABLE;
26 
27    PROCEDURE applyFilter (p_ParamSortOrder DBMS_SQL.VARCHAR2_TABLE, p_GroupId VARCHAR2);
28 
29    PROCEDURE addBindParameter(p_bind_parameter VARCHAR2);
30 
31    PROCEDURE clearBindParameter;
32 
33    PROCEDURE applyFilter( p_FilterQuery IN VARCHAR2
34                         , p_GroupId     IN NUMBER
35                         , p_TemplateId  IN NUMBER
36                          );
37 
38 END BOM_FILTER;