APPS.BOM_FILTER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

| 2004/1/16	Ajay			Modified the method to only update  |
|					the row with flag.		    |
|                                                                           |
+==========================================================================*/

	G_PARAM_LIST PARAM_LIST;

Line: 30

		UPDATE BOM_EXPLOSIONS_ALL
		   SET HGRID_FLAG=NULL
		 WHERE HGRID_FLAG='Y'
	           AND group_id = p_GroupId
	           AND plan_level <> 0;

Line: 36

	--	 Update all the resultant rows to HGRID_FLAG='Y'
	--	 Code to handle if the SORT_ORDER array is empty.
		 IF p_ParamSortOrder IS NOT NULL AND p_ParamSortOrder.COUNT <> 0 THEN
		 FORALL j IN p_ParamSortOrder.FIRST .. p_ParamSortOrder.LAST
			UPDATE BOM_EXPLOSIONS_ALL SET hgrid_flag='Y' WHERE SORT_ORDER=p_ParamSortOrder(j) AND GROUP_ID=p_GroupId;

Line: 69

	  G_PARAM_LIST.delete;

Line: 124

      sort_order_t.delete;

Line: 133

		, 'SELECT st_order
		     FROM ( ' || p_filterQuery ||
		  '       ) order by st_order'
		, DBMS_SQL.NATIVE
		);

Line: 144

		,  'SELECT ST_ORDER sort_order '               ||
		   'BULK COLLECT INTO ' || ':'||G_PARAM_LIST.COUNT+1 ||
		   '  FROM '                                   ||
		   '  ( '                                      ||
		   p_FilterQuery                               ||
		   '   )  '
		, DBMS_SQL.NATIVE
		);