1 PACKAGE INVIDIT3 AUTHID CURRENT_USER AS
2 /* $Header: INVIDI3S.pls 120.7.12020000.2 2012/07/13 08:22:43 swuppala ship $ */
3
4 G_inv_item_id NUMBER;
5
6 PROCEDURE Table_Queries(
7 p_org_id IN NUMBER,
8 p_item_id IN NUMBER,
9 p_master_org IN NUMBER,
10 p_primary_uom_code IN VARCHAR2,
11 p_catalog_group_id IN NUMBER,
12 p_calling_routine IN VARCHAR2, -- Values are INVIDITM,IOI.
13 x_onhand_lot IN OUT NOCOPY NUMBER,
14 x_onhand_serial IN OUT NOCOPY NUMBER,
15 x_onhand_shelf IN OUT NOCOPY NUMBER,
16 x_onhand_rev IN OUT NOCOPY NUMBER,
17 x_onhand_loc IN OUT NOCOPY NUMBER,
18 x_onhand_all IN OUT NOCOPY NUMBER,
19 x_onhand_trackable IN OUT NOCOPY NUMBER,
20 x_wip_repetitive_item IN OUT NOCOPY NUMBER,
21 x_rsv_exists IN OUT NOCOPY NUMBER,
22 x_so_rsv IN OUT NOCOPY NUMBER,
23 x_so_ship IN OUT NOCOPY NUMBER,
24 x_so_txn IN OUT NOCOPY NUMBER,
25 x_demand_exists IN OUT NOCOPY NUMBER,
26 x_uom_conv IN OUT NOCOPY NUMBER,
27 x_comp_atp IN OUT NOCOPY NUMBER,
28 x_bom_exists IN OUT NOCOPY NUMBER,
29 x_cost_txn IN OUT NOCOPY NUMBER,
30 x_bom_item IN OUT NOCOPY NUMBER,
31 x_mrp_schedule IN OUT NOCOPY NUMBER,
32 x_null_elem_exists IN OUT NOCOPY NUMBER,
33 x_so_open_exists IN OUT NOCOPY NUMBER,
34 x_fte_vechicle_exists IN OUT NOCOPY NUMBER,
35 x_pendadj_lot IN OUT NOCOPY NUMBER,
36 x_pendadj_rev IN OUT NOCOPY NUMBER,
37 x_pendadj_loc IN OUT NOCOPY NUMBER,
38 x_so_ato IN OUT NOCOPY NUMBER,
39 x_vmiorconsign_enabled IN OUT NOCOPY NUMBER,
40 x_consign_enabled IN OUT NOCOPY NUMBER,
41 x_process_enabled IN OUT NOCOPY NUMBER,
42 x_onhand_tracking_qty_ind IN OUT NOCOPY NUMBER,
43 x_pendadj_tracking_qty_ind IN OUT NOCOPY NUMBER,
44 x_onhand_primary_uom IN OUT NOCOPY NUMBER,
45 x_pendadj_primary_uom IN OUT NOCOPY NUMBER,
46 x_onhand_secondary_uom IN OUT NOCOPY NUMBER,
47 x_pendadj_secondary_uom IN OUT NOCOPY NUMBER,
48 x_onhand_sec_default_ind IN OUT NOCOPY NUMBER,
49 x_pendadj_sec_default_ind IN OUT NOCOPY NUMBER,
50 x_onhand_deviation_high IN OUT NOCOPY NUMBER,
51 x_pendadj_deviation_high IN OUT NOCOPY NUMBER,
52 x_onhand_deviation_low IN OUT NOCOPY NUMBER,
53 x_pendadj_deviation_low IN OUT NOCOPY NUMBER,
54 x_onhand_child_lot IN OUT NOCOPY NUMBER,
55 x_pendadj_child_lot IN OUT NOCOPY NUMBER,
56 x_onhand_lot_divisible IN OUT NOCOPY NUMBER,
57 x_pendadj_lot_divisible IN OUT NOCOPY NUMBER,
58 x_onhand_grade IN OUT NOCOPY NUMBER,
59 x_pendadj_grade IN OUT NOCOPY NUMBER,
60 x_intr_ship_lot IN OUT NOCOPY NUMBER,
61 x_intr_ship_serial IN OUT NOCOPY NUMBER,
62 X_revision_control OUT NOCOPY number, -- Bug 6501149
63 X_stockable OUT NOCOPY number, -- Bug 6501149
64 X_lot_control OUT NOCOPY number, -- Bug 6501149
65 X_serial_control OUT NOCOPY number, -- Bug 6501149
66 X_open_shipment_lot IN OUT NOCOPY number, -- Bug 9043779
67 X_open_shipment_serial IN OUT NOCOPY number -- Bug 9043779
68 );
69
70 -- Added for 11.5.10
71 PROCEDURE VMI_Table_Queries(
72 p_org_id IN NUMBER
73 , p_item_id IN NUMBER
74 , x_vmiorconsign_enabled OUT NOCOPY NUMBER
75 , x_consign_enabled OUT NOCOPY NUMBER);
76
77 FUNCTION Get_inv_item_id RETURN NUMBER;
78
79 PROCEDURE Set_inv_item_id(item_id number);
80
81 FUNCTION Is_Catalog_Group_Valid(
82 old_catalog_group_id VARCHAR2,
83 new_catalog_group_id VARCHAR2,
84 item_id NUMBER) RETURN VARCHAR2;--Bug: 3171098
85
86 FUNCTION CHECK_NPR_CATALOG(p_catalog_group_id NUMBER) RETURN BOOLEAN;
87
88 FUNCTION CHECK_ITEM_APPROVED(p_inventory_item_id NUMBER
89 ,p_organization_id NUMBER) RETURN BOOLEAN;
90
91 --Added for Bug: 4569555
92 PROCEDURE CSI_Table_Queries (
93 p_inventory_item_id IN NUMBER
94 ,p_organization_id IN NUMBER
95 ,x_ib_ret_status OUT NOCOPY VARCHAR2
96 ,x_ib_msg OUT NOCOPY VARCHAR2);
97
98 END INVIDIT3;