1 PACKAGE CS_InstalledBase_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvibs.pls 115.22 2003/01/28 19:57:01 rmamidip ship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare global variables
6 -- ---------------------------------------------------------
7 -- Commented out as a part of the restricting the usage of the globals
8 -- G_MISS_CP_REC CS_InstalledBase_PUB.CP_Prod_Rec_Type;
9
10 --------------------------------------------------------------------------
11
12 PROCEDURE Initialize_Desc_Flex
13 (
14 p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
15 l_desc_flex OUT CS_InstalledBase_PUB.DFF_Rec_Type
16 );
17
18 PROCEDURE Initialize_Price_Attribs
19 (
20 p_price_attribs IN CS_InstalledBase_PUB.PRICE_ATT_Rec_Type,
21 l_price_attribs OUT CS_InstalledBase_PUB.PRICE_ATT_Rec_Type
22 );
23
24 PROCEDURE Cascade_To_Child_Entities
25 (
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
29 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
30 x_return_status OUT VARCHAR2,
31 x_msg_count OUT NUMBER,
32 x_msg_data OUT VARCHAR2,
33 p_cp_id IN NUMBER,
34 p_new_cp_id IN NUMBER
35 );
36
37
38 PROCEDURE Create_Base_Product
39 (
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
44 x_return_status OUT VARCHAR2,
45 x_msg_count OUT NUMBER,
46 x_msg_data OUT VARCHAR2,
47 p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
48 p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
49 p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
50 p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
51 p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52 p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
54 x_cp_id OUT NUMBER,
55 x_object_version_number OUT NUMBER
56 );
57
58
59 PROCEDURE Create_Revision
60 (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
65 x_return_status OUT VARCHAR2,
66 x_msg_count OUT NUMBER,
67 x_msg_data OUT VARCHAR2,
68 p_cp_id IN NUMBER,
69 p_rev_inv_item_id IN NUMBER,
70 p_order_info IN CS_InstalledBase_PUB.OrderInfo_Rec_Type,
71 --p_net_amount IN NUMBER,
72 --p_currency_code IN VARCHAR2,
73 p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
74 p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
75 p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
76 p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
77 x_cp_rev_id OUT NUMBER,
78 x_curr_rev_of_cp_updtd OUT VARCHAR2,
79 x_object_version_number OUT NUMBER
80 );
81
82
83 PROCEDURE Update_Revision
84 (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
89 x_return_status OUT VARCHAR2,
90 x_msg_count OUT NUMBER,
91 x_msg_data OUT VARCHAR2,
92 p_cp_rev_id IN NUMBER,
93 p_object_version_number IN NUMBER,
94 p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
95 p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
96 p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
97 x_object_version_number OUT NUMBER
98 );
99
100 PROCEDURE Record_Shipment_Info
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
106 x_return_status OUT VARCHAR2,
107 x_msg_count OUT NUMBER,
108 x_msg_data OUT VARCHAR2,
109 p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
110 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
111 x_new_cp_id OUT NUMBER,
112 p_savepoint_rec_lvl IN NUMBER DEFAULT 1
113 );
114
115
116 -- This API is called Replace_Product in the Public API.
117
118 PROCEDURE Upgrade_Product
119 (
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
124 x_return_status OUT VARCHAR2,
125 x_msg_count OUT NUMBER,
126 x_msg_data OUT VARCHAR2,
127 p_cp_id IN NUMBER,
128 p_old_cp_status_id IN NUMBER,
129 p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
130 p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131 p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132 x_new_cp_id OUT NUMBER,
133 p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134 p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
135 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136 p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
137 );
138
139
140 PROCEDURE Update_Product
141 (
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
144 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
146 x_return_status OUT VARCHAR2,
147 x_msg_count OUT NUMBER,
148 x_msg_data OUT VARCHAR2,
149 p_cp_id IN NUMBER,
150 p_as_of_date IN DATE DEFAULT SYSDATE,
151 p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
152 p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
153 p_comments IN VARCHAR2 DEFAULT NULL,
154 p_split_cp_id IN NUMBER DEFAULT NULL,
155 p_split_reason_code IN VARCHAR2 DEFAULT NULL,
156 p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157 p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
158 p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
159 p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
160 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
161 p_savepoint_rec_lvl IN NUMBER DEFAULT 1
162 );
163
164
165 PROCEDURE Specify_Contact
166 (
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170 p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
171 x_return_status OUT VARCHAR2,
172 x_msg_count OUT NUMBER,
173 x_msg_data OUT VARCHAR2,
174 p_contact_rec IN CS_InstalledBase_PUB.CP_Contact_Rec_Type,
175 x_cs_contact_id OUT NUMBER,
176 x_object_version_number OUT NUMBER
177 );
178
179 PROCEDURE Update_CP_Status(ERRBUF OUT VARCHAR2, RETCODE OUT NUMBER);
180
181 END CS_InstalledBase_PVT;