[Home] [Help]
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;