[Home] [Help]
PACKAGE: APPS.CSI_WIP_TRXS_PKG
Source
1 package csi_wip_trxs_pkg AS
2 /* $Header: csipiwps.pls 120.6.12010000.1 2008/07/25 08:11:35 appldev ship $ */
3
4 g_pkg_name varchar2(30) := 'csi_wip_trxs_pkg';
5 g_api_name varchar2(80) := 'csi_wip_trxs_pkg';
6
7 TYPE txn_ref IS RECORD (
8 transaction_id number := fnd_api.g_miss_num,
9 transaction_date date := fnd_api.g_miss_date,
10 creation_date date := fnd_api.g_miss_date,
11 transaction_type_id number := fnd_api.g_miss_num,
12 transaction_source_type_id number := fnd_api.g_miss_num,
13 transaction_action_id number := fnd_api.g_miss_num,
14 inventory_item_id number := fnd_api.g_miss_num,
15 organization_id number := fnd_api.g_miss_num,
16 primary_quantity number := fnd_api.g_miss_num,
17 master_organization_id number := fnd_api.g_miss_num,
18 item varchar2(40) := fnd_api.g_miss_char,
19 primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20 srl_control_code number := fnd_api.g_miss_num,
21 lot_control_code number := fnd_api.g_miss_num,
22 rev_control_code number := fnd_api.g_miss_num,
23 loc_control_code number := fnd_api.g_miss_num,
24 ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25 eam_item_type number := fnd_api.g_miss_num,
26 bom_item_type number := fnd_api.g_miss_num,
27 wip_entity_id number := fnd_api.g_miss_num,
28 wip_entity_name varchar2(30) := fnd_api.g_miss_char,
29 wip_entity_type number := fnd_api.g_miss_num,
30 wip_job_type number := fnd_api.g_miss_num,
31 wip_status_type number := fnd_api.g_miss_num,
32 wip_assembly_item_id number := fnd_api.g_miss_num,
33 wip_start_quantity number := fnd_api.g_miss_num,
34 wip_completed_quantity number := fnd_api.g_miss_num,
35 wip_maint_source_code number := fnd_api.g_miss_num,
36 wip_source_line_id number := fnd_api.g_miss_num,
37 wip_source_code varchar2(30) := fnd_api.g_miss_char,
38 wip_maint_obj_type number := fnd_api.g_miss_num,
39 wip_maint_obj_id number := fnd_api.g_miss_num);
40
41 TYPE mmt_rec IS RECORD (
42 inventory_item_id number := fnd_api.g_miss_num,
43 organization_id number := fnd_api.g_miss_num,
44 subinventory_code varchar2(10) := fnd_api.g_miss_char,
45 revision varchar2(3) := fnd_api.g_miss_char,
46 transaction_source_id number := fnd_api.g_miss_num,
47 transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48 transaction_date date := fnd_api.g_miss_date,
49 transaction_quantity number := fnd_api.g_miss_num,
50 transaction_uom varchar2(3) := fnd_api.g_miss_char,
51 locator_id number := fnd_api.g_miss_num,
52 serial_number varchar2(30) := fnd_api.g_miss_char,
53 lot_number varchar2(80) := fnd_api.g_miss_char,
54 subinv_location_id number := fnd_api.g_miss_num,
55 hr_location_id number := fnd_api.g_miss_num,
56 mmt_primary_quantity number := fnd_api.g_miss_num,
57 lot_primary_quantity number := fnd_api.g_miss_num,
58 instance_quantity number := fnd_api.g_miss_num);
59
60 TYPE mmt_tbl IS TABLE OF mmt_rec INDEX BY binary_integer;
61
62 TYPE requirements_rec IS RECORD(
63 wip_entity_id number,
64 inventory_item_id number,
65 organization_Id number,
66 required_quantity number,
67 issued_quantity number,
68 quantity_per_assy number);
69
70 TYPE requirements_tbl IS TABLE OF requirements_rec INDEX by binary_integer;
71
72 TYPE issues_rec IS RECORD (
73 instance_id number,
74 inventory_item_id number,
75 organization_id number,
76 subinventory_code varchar2(30),
77 locator_id number,
78 item_revision varchar2(3),
79 lot_number varchar2(80),
80 serial_number varchar2(30),
81 quantity number,
82 owner_party_id number);
83
84 TYPE issues_tbl IS TABLE of issues_rec INDEX by binary_integer;
85
86 TYPE assy_comp_map_rec IS RECORD (
87 assy_instance_id number,
88 comp_instance_id number,
89 comp_quantity number);
90
91 TYPE assy_comp_map_tbl IS TABLE of assy_comp_map_rec INDEX by binary_integer;
92
93 PROCEDURE wip_comp_issue(
94 p_transaction_id IN number,
95 p_message_id IN number,
96 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
97 x_return_status OUT nocopy varchar2);
98
99 PROCEDURE wip_comp_receipt(
100 p_transaction_id IN number,
101 p_message_id IN number,
102 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
103 x_return_status OUT nocopy varchar2);
104
105 PROCEDURE wip_assy_completion(
106 p_transaction_id IN number,
107 p_message_id IN number,
108 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
109 x_return_status OUT nocopy varchar2);
110
111
112 PROCEDURE wip_byproduct_completion(
113 p_transaction_id IN number,
114 p_message_id IN number,
115 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
116 x_return_status OUT nocopy varchar2);
117
118 PROCEDURE wip_byproduct_return(
119 p_transaction_id IN number,
120 p_message_id IN number,
121 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
122 x_return_status OUT nocopy varchar2);
123
124
125
126 PROCEDURE wip_assy_return(
127 p_transaction_id IN number,
128 p_message_id IN number,
129 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
130 x_return_status OUT nocopy varchar2);
131
132 PROCEDURE wip_neg_comp_return(
133 p_transaction_id IN number,
134 p_message_id IN number,
135 px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
136 x_return_status OUT nocopy varchar2);
137
138 PROCEDURE process_manual_rltns(
139 p_wip_entity_id IN number,
140 x_return_status OUT nocopy varchar2,
141 x_error_message OUT nocopy varchar2);
142
143 PROCEDURE eam_wip_completion(
144 p_wip_entity_id IN number,
145 p_organization_id IN number,
146 px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
147 x_return_status OUT nocopy varchar2);
148
149 PROCEDURE eam_rebuildable_return(
150 p_wip_entity_id IN number,
151 p_organization_id IN number,
152 p_instance_id IN number,
153 px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
154 x_return_status OUT nocopy varchar2);
155
156 END csi_wip_trxs_pkg;