1 PACKAGE csi_process_txn_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivptxs.pls 120.2.12020000.2 2012/11/09 08:59:44 mvaradam ship $ */
3
4 g_pkg_name VARCHAR2(30) := 'csi_process_txn_pvt';
5
6 TYPE item_attr_rec IS RECORD(
7 SRC_SERIAL_CONTROL_FLAG VARCHAR2(1) := 'N',
8 DST_SERIAL_CONTROL_FLAG VARCHAR2(1) := 'N',
9 LOT_CONTROL_FLAG VARCHAR2(1) := 'N',
10 LOCATOR_CONTROL_FLAG VARCHAR2(1) := 'N',
11 REVISION_CONTROL_FLAG VARCHAR2(1) := 'N',
12 IB_TRACKABLE_FLAG VARCHAR2(1) := 'N',
13 SHIPPABLE_FLAG VARCHAR2(1) := 'N',
14 BOM_ITEM_TYPE VARCHAR2(30) := fnd_api.g_miss_char,
15 STOCKABLE_FLAG VARCHAR2(1) := 'N');
16 -- Bug 10415554
17 PROCEDURE get_serial_tagging_control (
18 p_inventory_item_id IN NUMBER,
19 p_organization_id IN NUMBER,
20 p_mtl_transaction_id IN NUMBER,
21 p_serial_tagged OUT NOCOPY VARCHAR2,
22 p_inv_txn_typeid_from_cs IN NUMBER DEFAULT -1);
23
24
25 PROCEDURE get_sub_type_rec(
26 p_txn_type_id IN number,
27 p_sub_type_id IN number,
28 x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
29 x_return_status OUT NOCOPY varchar2);
30
31
32 PROCEDURE sub_type_validations(
33 p_sub_type_rec IN csi_txn_sub_types%rowtype,
34 p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
35 p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
36 x_return_status OUT NOCOPY varchar2);
37
38
39 PROCEDURE validate_dest_location_rec(
40 p_in_out_flag IN varchar2,
41 p_dest_location_rec IN OUT NOCOPY csi_process_txn_grp.dest_location_rec,
42 x_return_status OUT NOCOPY varchar2);
43
44 -- Bug 10415554
45 PROCEDURE get_item_attributes(
46 p_transaction_id IN number,-- Added for bug#14835893
47 p_in_out_flag IN varchar2,
48 p_sub_type_rec IN csi_txn_sub_types%rowtype,
49 p_inventory_item_id IN number,
50 p_organization_id IN number,
51 p_mtl_transaction_id IN NUMBER,
52 x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
53 x_return_status OUT NOCOPY varchar2,
54 p_inv_txn_typeid_from_cs IN NUMBER DEFAULT -1);
55
56
57 PROCEDURE get_src_instance_id(
58 p_in_out_flag IN varchar2,
59 p_sub_type_rec IN csi_txn_sub_types%rowtype,
60 p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
61 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
62 p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
63 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
64 x_instance_id OUT NOCOPY number,
65 x_return_status OUT NOCOPY varchar2);
66
67 PROCEDURE get_dest_instance_id(
68 p_in_out_flag IN varchar2,
69 p_sub_type_rec IN csi_txn_sub_types%rowtype,
70 p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
71 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72 p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
73 x_instance_id OUT NOCOPY number,
74 x_return_status OUT NOCOPY varchar2);
75
76 PROCEDURE process_ib(
77 p_in_out_flag IN varchar2,
78 p_sub_type_rec IN csi_txn_sub_types%rowtype,
79 p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
80 p_instance_index IN binary_integer,
81 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
82 p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
83 p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
84 p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
85 p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
86 p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
87 p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
88 p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
89 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
90 px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
91 x_return_status OUT NOCOPY varchar2);
92
93
94 PROCEDURE process_relation(
95 p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
96 p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
97 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
98 x_return_status OUT NOCOPY varchar2);
99
100 -- Moved the check and break routine from rma receipt pub to avoid circular dependancy introduced in that routine for bug 2373109 and also to not load rma receipt for Non RMA txns . shegde. Bug 2443204
101
102 PROCEDURE check_and_break_relation(
103 p_instance_id IN number,
104 p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
105 x_return_status OUT NOCOPY varchar2);
106
107 --code modification start for 3681856--
108 -- exposing the unexpire instance routine for usability
109 -- added new param p_call_contracts,to decide whether to notify contracts API while un-expiring
110
111 PROCEDURE unexpire_instance(
112 p_instance_id IN number,
113 p_call_contracts IN varchar2 := fnd_api.g_true,
114 p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
115 x_return_status OUT nocopy varchar2);
116
117 END csi_process_txn_pvt;