1 PACKAGE CSF_IB AS
2 /* $Header: csfibass.pls 120.1 2006/01/31 14:25:48 ibalint noship $ */
3
4 -- case 1:
5 -- part is going to be stand alone, create a new CPID using the item.
6 -- return the CPID number
7
8 PROCEDURE create_base_product1(
9 p_api_version IN NUMBER,
10 x_return_status OUT NOCOPY varchar2,
11 x_msg_count OUT NOCOPY number,
12 x_msg_data OUT NOCOPY varchar2,
13 x_cp_id OUT NOCOPY number,
14 x_object_version_number OUT NOCOPY number,
15 p_customer_id IN NUMBER,
16 p_inv_item_id IN number,
17 p_cp_status_id in number,
18 p_quantity in number,
19 p_uom_code in varchar2,
20 p_currency_code in varchar2,
21 p_delivered_flag in varchar2 default null,
22 p_installation_date in date default null,
23 p_serial_number in varchar2 default null,
24 p_shipped_date in date default null);
25
26 --case 2:
27 -- part is inserted as a child in a tree.
28 -- create a new CPID using the item. Set its parent
29 -- column to point to the value parent_cp_id.
30
31 PROCEDURE create_base_product2(
32 p_api_version IN NUMBER,
33 x_return_status OUT NOCOPY varchar2,
34 x_msg_count OUT NOCOPY number,
35 x_msg_data OUT NOCOPY varchar2,
36 x_cp_id OUT NOCOPY number,
37 x_object_version_number OUT NOCOPY number,
38 p_customer_id IN NUMBER,
39 p_inv_item_id IN number,
40 p_cp_status_id in number,
41 p_quantity in number,
42 p_uom_code in varchar2,
43 p_currency_code in varchar2,
44 p_config_parent_cp_id in number,
45 p_delivered_flag in varchar2 default null,
46 p_installation_date in date default null,
47 p_serial_number in varchar2 default null,
48 p_shipped_date in date default null);
49
50 -- case 3:
51 -- part is replacing a node in a tree. Create a new CPID
52 -- using the item, set its parents to point to parent of
53 -- the replaced cpid, and make all the cild of the replaced
54 -- cpid to the newly created record.
55
56 Procedure replace_product(
57 p_api_version in number,
58 x_return_status OUT NOCOPY varchar2,
59 x_msg_count OUT NOCOPY number,
60 x_msg_data OUT NOCOPY varchar2,
61 x_new_cp_id OUT NOCOPY number,
62 p_customer_id IN NUMBER,
63 p_inv_item_id IN number,
64 p_cp_status_id in number,
65 p_old_cp_status_id in number,
66 p_quantity in number,
67 p_uom_code in varchar2,
68 p_currency_code in varchar2,
69 p_cp_id in number,
70 p_qty_mismatch_ok in Varchar2 default null,
71 p_config_parent_cp_id in number,
72 p_serial_number in varchar2 default null,
73 p_shipped_date in date default null);
74
75 -- This procedure is used to update a Installed Base Product
76 Procedure Update_Product(
77 p_api_version in number,
78 x_return_status OUT NOCOPY varchar2,
79 x_msg_count OUT NOCOPY number,
80 x_msg_data OUT NOCOPY varchar2,
81 p_cp_id in number,
82 p_customer_id IN NUMBER,
83 p_inv_item_id IN number,
84 p_quantity in number,
85 p_uom_code in varchar2,
86 p_cp_status_id in number,
87 p_config_parent_cp_id IN Number,
88 p_serial_number in varchar2 default null,
89 p_shipped_date in date default null) ;
90
91 Procedure Update_install_base (
92 p_api_version in number,
93 p_init_msg_list in varchar2 := fnd_api.g_false,
94 p_commit in varchar2 := fnd_api.g_false,
95 p_validation_level in number := fnd_api.g_valid_level_full,
96 x_return_status OUT NOCOPY varchar2,
97 x_msg_count OUT NOCOPY number,
98 x_msg_data OUT NOCOPY varchar2,
99 x_new_instance_id OUT NOCOPY number,
100 p_in_out_flag in varchar2,
101 p_transaction_type_id in number,
102 p_txn_sub_type_id in number,
103 p_instance_id in number,
104 p_inventory_item_id in number,
105 p_inv_organization_id in number,
106 p_inv_subinventory_name in varchar2,
107 p_inv_locator_id in number,
108 p_quantity in number,
109 p_inv_master_organization_id in number,
110 p_mfg_serial_number_flag in varchar2,
111 p_serial_number in varchar2,
112 p_lot_number in varchar2,
113 p_revision in varchar2,
114 p_unit_of_measure in varchar2,
115 p_party_id in number,
116 p_party_account_id in number,
117 p_party_site_id in number,
118 p_parent_instance_id in number default null,
119 p_instance_status_id in number := 9.99E125, --fnd_api.g_miss_num); --added for bug 3192060
120 p_item_operational_status_code in varchar2
121 );
122
123
124
125 END csf_IB;