1 PACKAGE INVIDIT1 AS
2 /* $Header: INVIDI1S.pls 120.5 2008/01/09 20:24:52 mshirkol ship $ */
3
4
5 PROCEDURE Get_Startup_Info
6 (
7 X_org_id IN NUMBER
8 , X_mode IN VARCHAR2
9 , X_master_org_id OUT NOCOPY NUMBER
10 , X_master_org_name OUT NOCOPY VARCHAR2
11 , X_master_org_code OUT NOCOPY VARCHAR2
12 , X_master_chart_of_accounts OUT NOCOPY number
13 , X_updateable_item OUT NOCOPY varchar2
14 , X_default_status OUT NOCOPY varchar2
15 , x_default_uom_b OUT NOCOPY VARCHAR2
16 , x_default_uom OUT NOCOPY VARCHAR2
17 , x_default_uom_code OUT NOCOPY VARCHAR2
18 , x_default_uom_class OUT NOCOPY VARCHAR2
19 , x_time_uom_class OUT NOCOPY VARCHAR2
20 , x_default_lot_status_id OUT NOCOPY NUMBER
21 , x_default_lot_status OUT NOCOPY VARCHAR2
22 , x_default_serial_status_id OUT NOCOPY NUMBER
23 , x_default_serial_status OUT NOCOPY VARCHAR2
24 , x_Item_Category_Set_id OUT NOCOPY NUMBER
25 , x_Item_Category_Structure_id OUT NOCOPY NUMBER
26 , x_Item_Category_Validate_Flag OUT NOCOPY VARCHAR2--Bug:3578024
27 , x_Item_Category_Set_Ctrl_level OUT NOCOPY VARCHAR2--Bug:3723668
28 , x_Default_Template_id OUT NOCOPY NUMBER
29 , x_Default_Template_Name OUT NOCOPY VARCHAR2
30 , X_icgd_option OUT NOCOPY varchar2
31 , X_allow_item_desc_update_flag OUT NOCOPY varchar2
32 , X_rfq_required_flag OUT NOCOPY varchar2
33 , X_receiving_flag OUT NOCOPY varchar2
34 , X_taxable_flag OUT NOCOPY varchar2
35 , X_org_locator_control OUT NOCOPY number
36 , X_org_expense_account OUT NOCOPY number
37 , X_org_encumbrance_account OUT NOCOPY number
38 , X_org_cost_of_sales_account OUT NOCOPY number
39 , X_org_sales_account OUT NOCOPY number
40 , X_serial_generation OUT NOCOPY number
41 , X_lot_generation OUT NOCOPY number
42 , X_cost_method OUT NOCOPY number
43 , X_category_flex_structure OUT NOCOPY number
44 , X_bom_enabled_status OUT NOCOPY number
45 , X_purchasable_status OUT NOCOPY number
46 , X_transactable_status OUT NOCOPY number
47 , X_stockable_status OUT NOCOPY number
48 , X_wip_status OUT NOCOPY number
49 , X_cust_ord_status OUT NOCOPY number
50 , X_int_ord_status OUT NOCOPY number
51 , X_invoiceable_status OUT NOCOPY number
52 , X_order_by_segments OUT NOCOPY varchar2
53 , X_product_family_templ_id OUT NOCOPY number
54 , X_encumbrance_reversal_flag OUT NOCOPY NUMBER --* Added for Bug #3818342
55 /* Start Bug 3713912 */
56 , X_recipe_enabled_status OUT NOCOPY number,
57 X_process_exec_enabled_status OUT NOCOPY number
58 /* End Bug 3713912 */
59 /* Adding attributes for R12 */
60 , X_tp_org OUT NOCOPY VARCHAR2
61 );
62
63
64 PROCEDURE Get_Installs(X_inv_install OUT NOCOPY number,
65 X_po_install OUT NOCOPY number,
66 X_ar_install OUT NOCOPY number,
67 X_oe_install OUT NOCOPY number,
68 X_bom_install OUT NOCOPY number,
69 X_eng_install OUT NOCOPY number,
70 X_cs_install OUT NOCOPY number,
71 X_mrp_install OUT NOCOPY number,
72 X_wip_install OUT NOCOPY number,
73 X_fa_install OUT NOCOPY number,
74 X_pjm_unit_eff_enabled OUT NOCOPY VARCHAR2
75 );
76
77
78 PROCEDURE Populate_Fields
79 (
80 X_org_id IN NUMBER
81 , X_item_id IN NUMBER
82 , X_buyer_id IN NUMBER,
83 X_hazard_class_id IN NUMBER,
84 X_un_number_id IN NUMBER,
85 X_picking_rule_id IN NUMBER,
86 X_atp_rule_id IN NUMBER,
87 X_payment_terms_id IN NUMBER,
88 X_accounting_rule_id IN NUMBER,
89 X_invoicing_rule_id IN NUMBER,
90 X_default_shipping_org IN NUMBER,
91 X_source_organization_id IN NUMBER,
92 X_weight_uom_code IN VARCHAR2,
93 X_volume_uom_code IN VARCHAR2,
94 X_item_type IN VARCHAR2,
95 X_container_type IN VARCHAR2,
96 X_conversion IN NUMBER,
97 X_buyer OUT NOCOPY varchar2,
98 X_hazard_class OUT NOCOPY varchar2,
99 X_un_number OUT NOCOPY varchar2,
100 X_un_description OUT NOCOPY varchar2,
101 X_picking_rule OUT NOCOPY varchar2,
102 X_atp_rule OUT NOCOPY varchar2,
103 X_payment_terms OUT NOCOPY varchar2,
104 X_accounting_rule OUT NOCOPY varchar2,
105 X_invoicing_rule OUT NOCOPY varchar2,
106 X_default_shipping_org_dsp OUT NOCOPY varchar2,
107 X_source_organization OUT NOCOPY varchar2,
108 X_source_org_name OUT NOCOPY varchar2,
109 X_weight_uom OUT NOCOPY varchar2,
110 X_volume_uom OUT NOCOPY varchar2,
111 X_item_type_dsp OUT NOCOPY varchar2,
112 X_container_type_dsp OUT NOCOPY varchar2,
113 X_conversion_dsp OUT NOCOPY varchar2,
114 X_service_duration_per_code IN VARCHAR2
115 , X_service_duration_period OUT NOCOPY VARCHAR2
116 , X_coverage_schedule_id IN number
117 , X_coverage_schedule OUT NOCOPY varchar2
118 , p_primary_uom_code IN VARCHAR2
119 , x_primary_uom OUT NOCOPY VARCHAR2
120 , x_uom_class OUT NOCOPY VARCHAR2
121 , p_dimension_uom_code IN VARCHAR2
122 , p_default_lot_status_id IN NUMBER
123 , p_default_serial_status_id IN NUMBER
124 , x_dimension_uom OUT NOCOPY VARCHAR2
125 , x_default_lot_status OUT NOCOPY VARCHAR2
126 , x_default_serial_status OUT NOCOPY VARCHAR2
127 , p_eam_activity_type_code IN VARCHAR2
128 , p_eam_activity_cause_code IN VARCHAR2
129 , p_eam_act_shutdown_status IN VARCHAR2
130 , x_eam_activity_type OUT NOCOPY VARCHAR2
131 , x_eam_activity_cause OUT NOCOPY VARCHAR2
132 , x_eam_act_shutdown_status_dsp OUT NOCOPY VARCHAR2
133 , p_secondary_uom_code IN VARCHAR2
134 , x_secondary_uom OUT NOCOPY VARCHAR2
135 --Jalaj Srivastava Bug 5017588
136 , x_secondary_uom_class OUT NOCOPY VARCHAR2
137 , p_Folder_Category_Set_id IN NUMBER
138 , x_Folder_Item_Category_id OUT NOCOPY NUMBER
139 , x_Folder_Item_Category OUT NOCOPY VARCHAR2
140 --Added as part of 11.5.9 ENH
141 , p_eam_activity_source_code IN VARCHAR2
142 , x_eam_activity_source OUT NOCOPY VARCHAR2
143 -- Item Transaction Defaults for 11.5.9
144 , X_Default_Move_Order_Sub_Inv OUT NOCOPY VARCHAR2
145 , X_Default_Receiving_Sub_Inv OUT NOCOPY VARCHAR2
146 , X_Default_Shipping_Sub_Inv OUT NOCOPY VARCHAR2
147 , X_charge_periodicity_code IN VARCHAR2
148 , X_charge_unit_of_measure OUT NOCOPY VARCHAR2
149 , X_inv_item_status_code IN VARCHAR2
150 , X_inv_item_status_code_tl OUT NOCOPY VARCHAR2
151 , p_default_material_status_id IN NUMBER
152 , x_default_material_status OUT NOCOPY VARCHAR2
153 );
154
155
156 FUNCTION Validate_Source_Org(X_org_id number,
157 X_item_id number,
158 X_new_item_id number,
159 X_source_org number,
160 X_mrp_plan number,
161 X_source_sub varchar2
162 ) return number;
163
164
165 --2463543 :Below is used in Item Search Form. Exclusively Built for INVIVCSU
166
167 PROCEDURE Item_Search_Execute_Query
168 (p_grp_handle_id IN NUMBER,
169 p_org_id IN NUMBER DEFAULT NULL,
170 p_item_mask IN VARCHAR2 DEFAULT NULL,
171 p_item_description IN VARCHAR2 DEFAULT NULL,
172 p_base_item_id IN NUMBER DEFAULT NULL,
173 p_status IN VARCHAR2 DEFAULT NULL,
174 p_catalog_grp_id IN NUMBER DEFAULT NULL,
175 p_catalog_complete IN VARCHAR2 DEFAULT NULL,
176 p_manufacturer_id IN NUMBER DEFAULT NULL,
177 p_mfg_part_num IN VARCHAR2 DEFAULT NULL,
178 p_vendor_id IN NUMBER DEFAULT NULL,
179 p_default_assignment IN VARCHAR2 DEFAULT NULL,
180 p_vendor_product_num IN VARCHAR2 DEFAULT NULL,
181 p_contract IN VARCHAR2 DEFAULT NULL,
182 p_blanket_agreement IN VARCHAR2 DEFAULT NULL,
183 p_xref_type IN dbms_sql.Varchar2_Table,
184 p_xref_val IN dbms_sql.Varchar2_Table,
185 p_relationship_type IN dbms_sql.Number_Table,
186 p_related_item IN dbms_sql.Number_Table,
187 p_category_set IN dbms_sql.Number_Table,
188 p_category_id IN dbms_sql.Number_Table,
189 p_element_name IN dbms_sql.Varchar2_Table,
190 p_element_val IN dbms_sql.Varchar2_Table);
191
192 END INVIDIT1;