1 PACKAGE EAM_MATERIALISSUE_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMMATTS.pls 120.1.12010000.2 2009/10/06 08:35:34 vchidura ship $*/
3 -- g_pkg_name CONSTANT VARCHAR2(30):= 'eam_materialissue_pvt';
4 procedure Fork_Logic( p_api_version IN NUMBER := 1.0,
5 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6 p_commit IN VARCHAR2 := fnd_api.g_false,
7 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
8 x_return_status OUT NOCOPY VARCHAR2 ,
9 x_msg_count OUT NOCOPY NUMBER,
10 x_msg_data OUT NOCOPY VARCHAR2,
11
12 p_wip_entity_type IN NUMBER,
13 p_organization_id IN NUMBER,
14 p_wip_entity_id IN NUMBER,
15 p_operation_seq_num IN NUMBER := null,
16 p_inventory_item_id IN NUMBER := null,
17 p_revision IN VARCHAR2 := null,
18 p_requested_quantity IN NUMBER := null,
19 p_source_subinventory IN VARCHAR2 := null,
20 p_source_locator IN VARCHAR2 := null,
21 p_lot_number IN VARCHAR2 := null,
22 p_fm_serial IN VARCHAR2 := null,
23 p_to_serial IN VARCHAR2 := null,
24 p_reasons IN VARCHAR2 :=null,
25 p_reference IN VARCHAR2 :=null,
26 p_date IN date := sysdate,
27 p_rebuild_item_id IN Number :=null,
28 p_rebuild_item_name IN varchar2 := null,
29 p_rebuild_serial_number IN Varchar2 :=null,
30 p_rebuild_job_name IN OUT NOCOPY Varchar2 ,
31 p_rebuild_activity_id IN Number :=null,
32 p_rebuild_activity_name IN varchar2 := null,
33 p_user_id IN Number := null,
34 p_inventory_item IN varchar2 := null, --Added for bug 8661513
35 p_locator_name IN varchar2 := null); --Added for bug 8661513
36
37
38 PROCEDURE process_mmtt(
39 p_api_version IN NUMBER := 1.0,
40 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
41 p_commit IN VARCHAR2 := fnd_api.g_false,
42 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_trx_tmp_id IN NUMBER);
47
48 PROCEDURE insert_ser_trx(p_trx_tmp_id IN VARCHAR2,
49 p_serial_trx_tmp_id IN NUMBER,
50 p_trx_header_id IN NUMBER,
51 p_user_id IN NUMBER,
52 p_fm_ser_num IN VARCHAR2,
53 p_to_ser_num IN VARCHAR2,
54 p_item_id IN NUMBER,
55 p_org_id IN NUMBER,
56 x_err_code OUT NOCOPY NUMBER,
57 x_err_message OUT NOCOPY VARCHAR2) ;
58
59 PROCEDURE INSERT_REASON_REF_INTO_MMTT(l_reason_id IN Number :=NULL,
60 p_reference IN varchar2 :=NULL,
61 p_transaction_temp_id In Number) ;
62
63
64
65 PROCEDURE ENTER_REBUILD_DETAILS(p_rebuild_item_id IN Number ,
66 p_rebuild_job_name IN OUT NOCOPY Varchar2 ,
67 p_rebuild_activity_id IN Number:=null,
68 p_rebuild_serial_number IN varchar2 :=null,
69 P_transaction_temp_id IN Number,
70 p_organization_id IN Number );
71
72
73 -- Procedure to cancel allocations if a material is deleted
74 -- Author : amondal
75
76
77 PROCEDURE cancel_alloc_matl_del (p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
79 p_commit IN VARCHAR2 := fnd_api.g_false,
80 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
81 p_wip_entity_id IN NUMBER,
82 p_operation_seq_num IN NUMBER,
83 p_inventory_item_id IN NUMBER,
84 p_wip_entity_type IN NUMBER,
85 p_repetitive_schedule_id IN NUMBER DEFAULT NULL,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER);
89
90 -- Procedure to cancel allocations if required quantity for a material is decreased
91 -- Procedure to create allocations if required quantity for a material is increased
92 -- Both cases are for Released Work Orders
93 -- Author : amondal
94
95 PROCEDURE comp_alloc_chng_qty(p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97 p_commit IN VARCHAR2 := fnd_api.g_false,
98 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
99 p_wip_entity_id IN NUMBER,
100 p_organization_id IN NUMBER,
101 p_operation_seq_num IN NUMBER,
102 p_inventory_item_id IN NUMBER,
103 p_qty_required IN NUMBER,
104 p_supply_subinventory IN VARCHAR2 DEFAULT NULL, --12.1 source sub project
105 p_supply_locator_id IN NUMBER DEFAULT NULL, --12.1 source sub project
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER);
109
110
111 -- Procedure to create new allocations for a newly added material to a Released Work Order
112 -- Author : amondal
113
114 PROCEDURE comp_alloc_new_mat(p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
116 p_commit IN VARCHAR2 := fnd_api.g_false,
117 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
118 p_wip_entity_id IN NUMBER,
119 p_organization_id IN NUMBER,
120 p_operation_seq_num IN NUMBER,
121 p_inventory_item_id IN NUMBER,
122 p_qty_required IN NUMBER,
123 p_supply_subinventory IN VARCHAR2 DEFAULT NULL, --12.1 source sub project
124 p_supply_locator_id IN NUMBER DEFAULT NULL, --12.1 source sub project
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER);
128
129 -- Procedure to create allocations during Release of a work order
130 -- Procedure to cancel allocations during Cancel of a work order
131 -- author : amondal
132
133 PROCEDURE alloc_at_release_cancel (p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
135 p_commit IN VARCHAR2 := fnd_api.g_false,
136 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
137 p_wip_entity_id IN NUMBER,
138 p_organization_id IN NUMBER,
139 p_status_type IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER);
143
144 FUNCTION get_tx_processor_mode(p_dummy IN boolean := false
145 )
146 return number;
147
148
149 END EAM_MATERIALISSUE_PVT;