1 PACKAGE EAM_MATERIALISSUE_PVT AS
2 /* $Header: EAMMATTS.pls 120.1 2008/01/22 22:27:49 mashah 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
35
36 PROCEDURE process_mmtt(
37 p_api_version IN NUMBER := 1.0,
38 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39 p_commit IN VARCHAR2 := fnd_api.g_false,
40 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_trx_tmp_id IN NUMBER);
45
46 PROCEDURE insert_ser_trx(p_trx_tmp_id IN VARCHAR2,
47 p_serial_trx_tmp_id IN NUMBER,
48 p_trx_header_id IN NUMBER,
49 p_user_id IN NUMBER,
50 p_fm_ser_num IN VARCHAR2,
51 p_to_ser_num IN VARCHAR2,
52 p_item_id IN NUMBER,
53 p_org_id IN NUMBER,
54 x_err_code OUT NOCOPY NUMBER,
55 x_err_message OUT NOCOPY VARCHAR2) ;
56
57 PROCEDURE INSERT_REASON_REF_INTO_MMTT(l_reason_id IN Number :=NULL,
58 p_reference IN varchar2 :=NULL,
59 p_transaction_temp_id In Number) ;
60
61
62
63 PROCEDURE ENTER_REBUILD_DETAILS(p_rebuild_item_id IN Number ,
64 p_rebuild_job_name IN OUT NOCOPY Varchar2 ,
65 p_rebuild_activity_id IN Number:=null,
66 p_rebuild_serial_number IN varchar2 :=null,
67 P_transaction_temp_id IN Number,
68 p_organization_id IN Number );
69
70
71 -- Procedure to cancel allocations if a material is deleted
72 -- Author : amondal
73
74
75 PROCEDURE cancel_alloc_matl_del (p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77 p_commit IN VARCHAR2 := fnd_api.g_false,
78 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
79 p_wip_entity_id IN NUMBER,
80 p_operation_seq_num IN NUMBER,
81 p_inventory_item_id IN NUMBER,
82 p_wip_entity_type IN NUMBER,
83 p_repetitive_schedule_id IN NUMBER DEFAULT NULL,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER);
87
88 -- Procedure to cancel allocations if required quantity for a material is decreased
89 -- Procedure to create allocations if required quantity for a material is increased
90 -- Both cases are for Released Work Orders
91 -- Author : amondal
92
93 PROCEDURE comp_alloc_chng_qty(p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
95 p_commit IN VARCHAR2 := fnd_api.g_false,
96 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
97 p_wip_entity_id IN NUMBER,
98 p_organization_id IN NUMBER,
99 p_operation_seq_num IN NUMBER,
100 p_inventory_item_id IN NUMBER,
101 p_qty_required IN NUMBER,
102 p_supply_subinventory IN VARCHAR2 DEFAULT NULL, --12.1 source sub project
103 p_supply_locator_id IN NUMBER DEFAULT NULL, --12.1 source sub project
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER);
107
108
109 -- Procedure to create new allocations for a newly added material to a Released Work Order
110 -- Author : amondal
111
112 PROCEDURE comp_alloc_new_mat(p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
114 p_commit IN VARCHAR2 := fnd_api.g_false,
115 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
116 p_wip_entity_id IN NUMBER,
117 p_organization_id IN NUMBER,
118 p_operation_seq_num IN NUMBER,
119 p_inventory_item_id IN NUMBER,
120 p_qty_required IN NUMBER,
121 p_supply_subinventory IN VARCHAR2 DEFAULT NULL, --12.1 source sub project
122 p_supply_locator_id IN NUMBER DEFAULT NULL, --12.1 source sub project
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER);
126
127 -- Procedure to create allocations during Release of a work order
128 -- Procedure to cancel allocations during Cancel of a work order
129 -- author : amondal
130
131 PROCEDURE alloc_at_release_cancel (p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
133 p_commit IN VARCHAR2 := fnd_api.g_false,
134 p_validation_level IN NUMBER:= fnd_api.g_valid_level_full,
135 p_wip_entity_id IN NUMBER,
136 p_organization_id IN NUMBER,
137 p_status_type IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER);
141
142 FUNCTION get_tx_processor_mode(p_dummy IN boolean := false
143 )
144 return number;
145
146
147 END EAM_MATERIALISSUE_PVT;