1 PACKAGE csi_process_txn_pvt AS
2 /* $Header: csivptxs.pls 120.0.12000000.1 2007/01/16 15:40:33 appldev 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
17
18 PROCEDURE get_sub_type_rec(
19 p_txn_type_id IN number,
20 p_sub_type_id IN number,
21 x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
22 x_return_status OUT NOCOPY varchar2);
23
24
25 PROCEDURE sub_type_validations(
26 p_sub_type_rec IN csi_txn_sub_types%rowtype,
27 p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
28 p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
29 x_return_status OUT NOCOPY varchar2);
30
31
32 PROCEDURE validate_dest_location_rec(
33 p_in_out_flag IN varchar2,
34 p_dest_location_rec IN OUT NOCOPY csi_process_txn_grp.dest_location_rec,
35 x_return_status OUT NOCOPY varchar2);
36
37
38 PROCEDURE get_item_attributes(
39 p_in_out_flag IN varchar2,
40 p_sub_type_rec IN csi_txn_sub_types%rowtype,
41 p_inventory_item_id IN number,
42 p_organization_id IN number,
43 x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
44 x_return_status OUT NOCOPY varchar2);
45
46
47 PROCEDURE get_src_instance_id(
48 p_in_out_flag IN varchar2,
49 p_sub_type_rec IN csi_txn_sub_types%rowtype,
50 p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
51 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
52 p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
53 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
54 x_instance_id OUT NOCOPY number,
55 x_return_status OUT NOCOPY varchar2);
56
57 PROCEDURE get_dest_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 x_instance_id OUT NOCOPY number,
64 x_return_status OUT NOCOPY varchar2);
65
66 PROCEDURE process_ib(
67 p_in_out_flag IN varchar2,
68 p_sub_type_rec IN csi_txn_sub_types%rowtype,
69 p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
70 p_instance_index IN binary_integer,
71 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72 p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73 p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74 p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75 p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76 p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77 p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78 p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
79 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
80 px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
81 x_return_status OUT NOCOPY varchar2);
82
83
84 PROCEDURE process_relation(
85 p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
86 p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
87 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
88 x_return_status OUT NOCOPY varchar2);
89
90 -- 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
91
92 PROCEDURE check_and_break_relation(
93 p_instance_id IN number,
94 p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
95 x_return_status OUT NOCOPY varchar2);
96
97 --code modification start for 3681856--
98 -- exposing the unexpire instance routine for usability
99 -- added new param p_call_contracts,to decide whether to notify contracts API while un-expiring
100
101 PROCEDURE unexpire_instance(
102 p_instance_id IN number,
103 p_call_contracts IN varchar2 := fnd_api.g_true,
104 p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
105 x_return_status OUT nocopy varchar2);
106
107 END csi_process_txn_pvt;