51: -- Parameters :
52: --
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
52: --
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
60: -- x_return_status OUT VARCHAR2 Required
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
60: -- x_return_status OUT VARCHAR2 Required
61: -- x_msg_count OUT NUMBER Required
69: -- 24-Sep-2010 JKJain Initial Creation
70: -------------------------------------------------------------------
71: PROCEDURE Calc_Contract_Exp_Date (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
74: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
75: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
76: p_module_type IN VARCHAR2 := NULL,
77: p_warranty_contract_id_tbl IN warranty_contract_id_tbl_type,
70: -------------------------------------------------------------------
71: PROCEDURE Calc_Contract_Exp_Date (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
74: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
75: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
76: p_module_type IN VARCHAR2 := NULL,
77: p_warranty_contract_id_tbl IN warranty_contract_id_tbl_type,
78: x_return_status OUT NOCOPY VARCHAR2,
71: PROCEDURE Calc_Contract_Exp_Date (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
74: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
75: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
76: p_module_type IN VARCHAR2 := NULL,
77: p_warranty_contract_id_tbl IN warranty_contract_id_tbl_type,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
138: -- Parameters :
139: --
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: --
146: -- Standard OUT Parameters :
139: --
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: --
146: -- Standard OUT Parameters :
147: -- x_return_status OUT VARCHAR2 Required
140: -- Standard IN Parameters :
141: -- p_api_version IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145: --
146: -- Standard OUT Parameters :
147: -- x_return_status OUT VARCHAR2 Required
148: -- x_msg_count OUT NUMBER Required
156: -- 30-NOV-2010 JKJain Modified for the new requirements.
157: -------------------------------------------------------------------
158: PROCEDURE Disable_Templates_For_Vendor (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
161: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
162: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
163: p_module_type IN VARCHAR2 := NULL,
164: p_warranty_vendor_id_tbl IN warranty_vendor_id_tbl_type,
157: -------------------------------------------------------------------
158: PROCEDURE Disable_Templates_For_Vendor (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
161: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
162: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
163: p_module_type IN VARCHAR2 := NULL,
164: p_warranty_vendor_id_tbl IN warranty_vendor_id_tbl_type,
165: x_return_status OUT NOCOPY VARCHAR2,
158: PROCEDURE Disable_Templates_For_Vendor (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
161: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
162: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
163: p_module_type IN VARCHAR2 := NULL,
164: p_warranty_vendor_id_tbl IN warranty_vendor_id_tbl_type,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
179: -- Parameters :
180: --
181: -- Standard IN Parameters :
182: -- p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
186: --
187: -- Standard OUT Parameters :
180: --
181: -- Standard IN Parameters :
182: -- p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
186: --
187: -- Standard OUT Parameters :
188: -- x_return_status OUT VARCHAR2 Required
181: -- Standard IN Parameters :
182: -- p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
186: --
187: -- Standard OUT Parameters :
188: -- x_return_status OUT VARCHAR2 Required
189: -- x_msg_count OUT NUMBER Required
199: -- 15-Oct-2010 JKJain Initial Creation
200: -------------------------------------------------------------------
201: PROCEDURE Process_Attachments (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
204: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
205: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
206: p_module_type IN VARCHAR2 := NULL,
207: p_entity_name IN VARCHAR2,
200: -------------------------------------------------------------------
201: PROCEDURE Process_Attachments (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
204: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
205: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
206: p_module_type IN VARCHAR2 := NULL,
207: p_entity_name IN VARCHAR2,
208: p_pk1_value IN NUMBER,
201: PROCEDURE Process_Attachments (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
204: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
205: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
206: p_module_type IN VARCHAR2 := NULL,
207: p_entity_name IN VARCHAR2,
208: p_pk1_value IN NUMBER,
209: p_copy_from_entity IN VARCHAR2,
226: -- Parameters :
227: --
228: -- Standard IN Parameters :
229: -- p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
231: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
232: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
233: -- p_default IN VARCHAR2 Default FND_API.G_FALSE
234: -- p_module_type IN VARCHAR2 Default Null
227: --
228: -- Standard IN Parameters :
229: -- p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
231: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
232: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
233: -- p_default IN VARCHAR2 Default FND_API.G_FALSE
234: -- p_module_type IN VARCHAR2 Default Null
235: -- Standard OUT Parameters :
228: -- Standard IN Parameters :
229: -- p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
231: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
232: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
233: -- p_default IN VARCHAR2 Default FND_API.G_FALSE
234: -- p_module_type IN VARCHAR2 Default Null
235: -- Standard OUT Parameters :
236: -- x_return_status OUT VARCHAR2 Required
229: -- p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
231: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
232: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
233: -- p_default IN VARCHAR2 Default FND_API.G_FALSE
234: -- p_module_type IN VARCHAR2 Default Null
235: -- Standard OUT Parameters :
236: -- x_return_status OUT VARCHAR2 Required
237: -- x_msg_count OUT NUMBER Required
245: -------------------------------------------------------------------
246: PROCEDURE Insert_Turnover_Notes
247: (
248: p_api_version IN NUMBER := 1.0 ,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_default IN VARCHAR2 := FND_API.G_FALSE,
253: p_module_type IN VARCHAR2 := Null,
246: PROCEDURE Insert_Turnover_Notes
247: (
248: p_api_version IN NUMBER := 1.0 ,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_default IN VARCHAR2 := FND_API.G_FALSE,
253: p_module_type IN VARCHAR2 := Null,
254: x_return_status OUT NOCOPY VARCHAR2,
247: (
248: p_api_version IN NUMBER := 1.0 ,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_default IN VARCHAR2 := FND_API.G_FALSE,
253: p_module_type IN VARCHAR2 := Null,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
248: p_api_version IN NUMBER := 1.0 ,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_default IN VARCHAR2 := FND_API.G_FALSE,
253: p_module_type IN VARCHAR2 := Null,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,