eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_COMPETITOR_PRODUCT_PVT dependencies on FND_API

Line 62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,

58:
59: --===================================================================
60: TYPE comp_prod_rec_type IS RECORD
61: (
62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,

Line 63: object_version_number NUMBER := FND_API.G_MISS_NUM,

59: --===================================================================
60: TYPE comp_prod_rec_type IS RECORD
61: (
62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,

Line 64: last_update_date DATE := FND_API.G_MISS_DATE,

60: TYPE comp_prod_rec_type IS RECORD
61: (
62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 65: last_updated_by NUMBER := FND_API.G_MISS_NUM,

61: (
62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,

Line 66: creation_date DATE := FND_API.G_MISS_DATE,

62: competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 67: created_by NUMBER := FND_API.G_MISS_NUM,

63: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,

Line 68: last_update_login NUMBER := FND_API.G_MISS_NUM,

64: last_update_date DATE := FND_API.G_MISS_DATE,
65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

Line 69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,

65: last_updated_by NUMBER := FND_API.G_MISS_NUM,
66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,

Line 70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

66: creation_date DATE := FND_API.G_MISS_DATE,
67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 71: interest_type_id NUMBER := FND_API.G_MISS_NUM,

67: created_by NUMBER := FND_API.G_MISS_NUM,
68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

68: last_update_login NUMBER := FND_API.G_MISS_NUM,
69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 73: organization_id NUMBER := FND_API.G_MISS_NUM,

69: competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,

70: competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,

71: interest_type_id NUMBER := FND_API.G_MISS_NUM,
72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,

Line 76: --security_group_id NUMBER := FND_API.G_MISS_NUM,

72: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,

Line 77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

73: organization_id NUMBER := FND_API.G_MISS_NUM,
74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,

Line 78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

74: comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,
82: category_set_id NUMBER := FND_API.G_MISS_NUM,

Line 79: start_date DATE := FND_API.G_MISS_DATE,

75: original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,
82: category_set_id NUMBER := FND_API.G_MISS_NUM,
83: context VARCHAR2(30),

Line 80: end_date DATE := FND_API.G_MISS_DATE,

76: --security_group_id NUMBER := FND_API.G_MISS_NUM,
77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,
82: category_set_id NUMBER := FND_API.G_MISS_NUM,
83: context VARCHAR2(30),
84: attribute1 VARCHAR2(150),

Line 81: category_id NUMBER := FND_API.G_MISS_NUM,

77: competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,
82: category_set_id NUMBER := FND_API.G_MISS_NUM,
83: context VARCHAR2(30),
84: attribute1 VARCHAR2(150),
85: attribute2 VARCHAR2(150),

Line 82: category_set_id NUMBER := FND_API.G_MISS_NUM,

78: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79: start_date DATE := FND_API.G_MISS_DATE,
80: end_date DATE := FND_API.G_MISS_DATE,
81: category_id NUMBER := FND_API.G_MISS_NUM,
82: category_set_id NUMBER := FND_API.G_MISS_NUM,
83: context VARCHAR2(30),
84: attribute1 VARCHAR2(150),
85: attribute2 VARCHAR2(150),
86: attribute3 VARCHAR2(150),

Line 116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

112: -- Parameters
113: --
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_comp_prod_rec IN comp_prod_rec_type Required
120: --

Line 117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

113: --
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_comp_prod_rec IN comp_prod_rec_type Required
120: --
121: -- OUT

Line 118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_comp_prod_rec IN comp_prod_rec_type Required
120: --
121: -- OUT
122: -- x_return_status OUT VARCHAR2

Line 135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

131: --
132:
133: PROCEDURE Create_Comp_Product(
134: p_api_version_number IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138:
139: x_return_status OUT NOCOPY VARCHAR2,

Line 136: p_commit IN VARCHAR2 := FND_API.G_FALSE,

132:
133: PROCEDURE Create_Comp_Product(
134: p_api_version_number IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138:
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,

Line 137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

133: PROCEDURE Create_Comp_Product(
134: p_api_version_number IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138:
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,

Line 160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

156: -- Parameters
157: --
158: -- IN
159: -- p_api_version_number IN NUMBER Required
160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
163: -- p_comp_prod_rec IN comp_prod_rec_type Required
164: --

Line 161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

157: --
158: -- IN
159: -- p_api_version_number IN NUMBER Required
160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
163: -- p_comp_prod_rec IN comp_prod_rec_type Required
164: --
165: -- OUT

Line 162: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

158: -- IN
159: -- p_api_version_number IN NUMBER Required
160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
163: -- p_comp_prod_rec IN comp_prod_rec_type Required
164: --
165: -- OUT
166: -- x_return_status OUT VARCHAR2

Line 179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

175: --
176:
177: PROCEDURE Update_Comp_Product(
178: p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182:
183: x_return_status OUT NOCOPY VARCHAR2,

Line 180: p_commit IN VARCHAR2 := FND_API.G_FALSE,

176:
177: PROCEDURE Update_Comp_Product(
178: p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182:
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,

Line 181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

177: PROCEDURE Update_Comp_Product(
178: p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182:
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,

Line 204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

200: -- Parameters
201: --
202: -- IN
203: -- p_api_version_number IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207: -- p_COMPETITOR_PRODUCT_ID IN NUMBER
208: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 205: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

201: --
202: -- IN
203: -- p_api_version_number IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207: -- p_COMPETITOR_PRODUCT_ID IN NUMBER
208: -- p_object_version_number IN NUMBER Optional Default = NULL
209: --

Line 206: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

202: -- IN
203: -- p_api_version_number IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207: -- p_COMPETITOR_PRODUCT_ID IN NUMBER
208: -- p_object_version_number IN NUMBER Optional Default = NULL
209: --
210: -- OUT

Line 224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

220: --
221:
222: PROCEDURE Delete_Comp_Product(
223: p_api_version_number IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,

Line 225: p_commit IN VARCHAR2 := FND_API.G_FALSE,

221:
222: PROCEDURE Delete_Comp_Product(
223: p_api_version_number IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,

Line 226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

222: PROCEDURE Delete_Comp_Product(
223: p_api_version_number IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_competitor_product_id IN NUMBER,

Line 247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

243: -- Parameters
244: --
245: -- IN
246: -- p_api_version_number IN NUMBER Required
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
248: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_comp_prod_rec IN comp_prod_rec_type Required
251: --

Line 248: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

244: --
245: -- IN
246: -- p_api_version_number IN NUMBER Required
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
248: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_comp_prod_rec IN comp_prod_rec_type Required
251: --
252: -- OUT

Line 249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

245: -- IN
246: -- p_api_version_number IN NUMBER Required
247: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
248: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
249: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250: -- p_comp_prod_rec IN comp_prod_rec_type Required
251: --
252: -- OUT
253: -- x_return_status OUT VARCHAR2

Line 266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

262: --
263:
264: PROCEDURE Lock_Comp_Product(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267:
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,

Line 290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

286: -- End of Comments
287:
288: PROCEDURE Validate_comp_prod(
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
293: p_comp_prod_rec IN comp_prod_rec_type,
294: x_return_status OUT NOCOPY VARCHAR2,

Line 291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

287:
288: PROCEDURE Validate_comp_prod(
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
293: p_comp_prod_rec IN comp_prod_rec_type,
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,