PACKAGE: APPS.INVIDIT2

Source

1 PACKAGE INVIDIT2 AUTHID CURRENT_USER AS
2 /* $Header: INVIDI2S.pls 115.8 2003/03/15 22:09:04 anakas ship $ */
3 
4 PROCEDURE Table_Inserts
5 (
6    X_event                       VARCHAR2
7 ,  X_item_id                     NUMBER
8 ,  X_org_id                      NUMBER
9 ,  X_master_org_id               NUMBER
10 ,  X_status_code                 VARCHAR2    DEFAULT  NULL
11 ,  X_inventory_item_flag         VARCHAR2
12 ,  X_purchasing_item_flag        VARCHAR2
13 ,  X_internal_order_flag         VARCHAR2
14 ,  X_mrp_planning_code           NUMBER
15 ,  X_serviceable_product_flag    VARCHAR2
16 ,  X_costing_enabled_flag        VARCHAR2
17 ,  X_eng_item_flag               VARCHAR2
18 ,  X_customer_order_flag         VARCHAR2
19 ,  X_eam_item_type               NUMBER
20 ,  X_contract_item_type_code     VARCHAR2
21 ,  p_Folder_Category_Set_id      IN   NUMBER
22 ,  p_Folder_Item_Category_id     IN   NUMBER
23 ,  X_allowed_unit_code           NUMBER      DEFAULT  0
24 ,  X_primary_uom                 VARCHAR2    DEFAULT  NULL
25 ,  X_primary_uom_code            VARCHAR2    DEFAULT  NULL
26 ,  X_primary_uom_class           VARCHAR2    DEFAULT  NULL
27 ,  X_inv_install                 NUMBER      DEFAULT  0
28 ,  X_last_updated_by             NUMBER      DEFAULT  0
29 ,  X_last_update_login           NUMBER      DEFAULT  0
30 ,  X_item_catalog_group_id       NUMBER
31 ,  P_Default_Move_Order_Sub_Inv  VARCHAR2 -- Item Transaction Defaults for 11.5.9
32 ,  P_Default_Receiving_Sub_Inv   VARCHAR2
33 ,  P_Default_Shipping_Sub_Inv    VARCHAR2
34 ,  P_Lifecycle_Id                NUMBER      DEFAULT  NULL
35 ,  P_Current_Phase_Id            NUMBER      DEFAULT  NULL
36 
37 );
38 
39 PROCEDURE Insert_Pending_Status( X_event	      varchar2,
40 				 X_item_id	      number,
41 				 X_org_id	      number,
42 				 X_master_org_id      number,
43 				 X_status	      varchar2,
44 				 X_Lifecycle_Id       number default null,
45 				 X_current_phase_Id   number default null);
46 
47 
48 PROCEDURE Insert_Revision(X_event       varchar2,
49                           X_item_id     number,
50                           X_org_id      number,
51 			  X_last_updated_by	number,
52 			  X_last_update_login	number
53                          );
54 
55 
56 PROCEDURE Insert_Categories
57 (
58    X_event                       VARCHAR2
59 ,  X_item_id                     NUMBER
60 ,  X_org_id                      NUMBER
61 ,  X_master_org_id               NUMBER
62 ,  X_inventory_item_flag         VARCHAR2
63 ,  X_purchasing_item_flag        VARCHAR2
64 ,  X_internal_order_flag         VARCHAR2
65 ,  X_mrp_planning_code           NUMBER
66 ,  X_serviceable_product_flag    VARCHAR2
67 ,  X_costing_enabled_flag        VARCHAR2
68 ,  X_eng_item_flag               VARCHAR2
69 ,  X_customer_order_flag         VARCHAR2
70 ,  X_eam_item_type               NUMBER
71 ,  X_contract_item_type_code     VARCHAR2
72 ,  p_Folder_Category_Set_id      IN   NUMBER
73 ,  p_Folder_Item_Category_id     IN   NUMBER
74 ,  X_last_updated_by             NUMBER
75 );
76 
77 
78 PROCEDURE Insert_Costing_Category(X_item_id     number,
79                                   X_org_id      number
80                                  );
81 
82 
83 PROCEDURE Insert_Cost_Row(X_item_id     number,
84                           X_org_id      number,
85                           X_inv_install number,
86 			  X_last_updated_by	number
87                          );
88 
89 PROCEDURE Insert_Cost_Details(X_item_id         number,
90                               X_org_id          number,
91                               X_inv_install     number,
92                               X_last_updated_by number,
93                               X_cst_item_type   number
94                              );
95 
96 
97 PROCEDURE Insert_Uom_Conversion(X_item_id               number,
98                                 X_allowed_unit_code     number,
99                                 X_primary_uom           varchar2,
100                                 X_primary_uom_code      varchar2,
101                                 X_primary_uom_class     varchar2
102                                 );
103 
104 PROCEDURE Delete_Categories(X_item_id   number,
105                             X_org_id    number
106                            );
107 
108 PROCEDURE Match_Catalog_Descr_Elements(X_item_id	number,
109 				       X_catalog_group_id  number
110 				      );
111 
112 
113 -- Procedure to insert Item Transaction Default SubInventories
114 
115 PROCEDURE Insert_Default_SubInventories ( X_Event       VARCHAR2
116 					, X_item_id    NUMBER
117 					, X_org_id     NUMBER
118 					, P_Default_Move_Order_Sub_Inv  VARCHAR2
119 					, P_Default_Receiving_Sub_Inv   VARCHAR2
120 					, P_Default_Shipping_Sub_Inv    VARCHAR2
121 					);
122 
123 END INVIDIT2;