PACKAGE: APPS.INV_DIAG_GRP

Source

1 PACKAGE  INV_DIAG_GRP AS
2 /* $Header: INVDGTPS.pls 120.0.12000000.1 2007/06/22 00:50:45 musinha noship $ */
3  TYPE item_info_rec_type is RECORD
4  (inventory_item_id         number
5  ,org_id                    number
6  ,serial_number_control_code number
7  ,lot_control_code           number
8  ,location_control_code      number
9  ,revision_qty_control_code  number
10  );
11 
12  TYPE item_tbl_type is table of  item_info_rec_type INDEX BY BINARY_INTEGER;
13  g_inv_diag_item_tbl 	item_tbl_type;
14 
15  TYPE order_info_rec_type is RECORD
16  (sales_order_id	number);
17 
18  TYPE order_info_tbl_type is table of  order_info_rec_type INDEX BY BINARY_INTEGER;
19  g_inv_diag_oe_tbl 	order_info_tbl_type;
20 
21  g_org_id number;
22 
23  g_grp_name varchar2(50):='';
24 
25  g_max_row number:=2000;
26 
27  FUNCTION CHECK_AVAIL(p_Inventory_item_id Number
28                      ,p_Organization_id  Number
29                      ,p_revision   Varchar2
30                      ,p_Subinventory_code Varchar2
31                      ,p_locator_id        Number
32                      ) return NUMBER;
33  FUNCTION CHECK_ONHAND(p_Inventory_item_id Number
34                      ,p_Organization_id  Number
35                      ,p_revision   Varchar2
36                      ,p_Subinventory_code Varchar2
37                      ,p_locator_id        Number
38                      ) return NUMBER;
39  FUNCTION check_responsibility (p_responsibility_name in FND_RESPONSIBILITY_TL.Responsibility_Name%type) return BOOLEAN;
40 
41 end;