8: -- Parameters :
9: -- IN :
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
18: -- Default = G_MISS_RTG_REVISION_REC
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
18: -- Default = G_MISS_RTG_REVISION_REC
19: -- OUT :
20: -- x_return_status VARCHAR2(1)
34: -- Parameters :
35: -- IN :
36: -- p_api_version NUMBER Required
37: -- p_init_msg_list VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_api_version NUMBER Required
37: -- p_init_msg_list VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
44: -- Default = G_MISS_RTG_REVISION_REC
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
44: -- Default = G_MISS_RTG_REVISION_REC
45: -- OUT :
46: -- x_return_status VARCHAR2(1)
60: -- Parameters :
61: -- IN :
62: -- p_api_version NUMBER Required
63: -- p_init_msg_list VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
62: -- p_api_version NUMBER Required
63: -- p_init_msg_list VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
70: -- Default = G_MISS_RTG_REVISION_REC
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
70: -- Default = G_MISS_RTG_REVISION_REC
71: -- OUT :
72: -- x_return_status VARCHAR2(1)
87: -- Parameters :
88: -- IN :
89: -- p_api_version NUMBER Required
90: -- p_init_msg_list VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_api_version NUMBER Required
90: -- p_init_msg_list VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
97: -- Default = G_MISS_RTG_REVISION_REC
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
97: -- Default = G_MISS_RTG_REVISION_REC
98: -- OUT :
99: -- x_return_status VARCHAR2(1)
114: -- Parameters :
115: -- IN :
116: -- p_api_version NUMBER Required
117: -- p_init_msg_list VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_api_version NUMBER Required
117: -- p_init_msg_list VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
124: -- Default = G_MISS_RTG_REVISION_REC
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
124: -- Default = G_MISS_RTG_REVISION_REC
125: -- OUT :
126: -- x_return_status VARCHAR2(1)
134: -- Notes : Full validation includes AssignRtgRevision
135: --
136: -- End of comments
137: TYPE rtg_revision_rec_type is record(
138: inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
135: --
136: -- End of comments
137: TYPE rtg_revision_rec_type is record(
138: inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
136: -- End of comments
137: TYPE rtg_revision_rec_type is record(
138: inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
137: TYPE rtg_revision_rec_type is record(
138: inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
138: inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
139: inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
140: organization_id NUMBER := Fnd_Api.G_Miss_Num,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
141: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
142: process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
143: change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
144: ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
145: implementation_date DATE := Fnd_Api.G_Miss_Date,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
146: implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
147: effectivity_date DATE := Fnd_Api.G_Miss_Date,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
148: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
149: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
156: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
164: );
157: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
164: );
165:
158: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
164: );
165:
166: G_MISS_RTG_REVISION_REC rtg_revision_rec_type;
159: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
164: );
165:
166: G_MISS_RTG_REVISION_REC rtg_revision_rec_type;
167: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
167: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
168:
169: PROCEDURE AssignRtgRevision(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT VARCHAR2,
175: x_msg_count OUT NUMBER,
168:
169: PROCEDURE AssignRtgRevision(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT VARCHAR2,
175: x_msg_count OUT NUMBER,
176: x_msg_data OUT VARCHAR2,
169: PROCEDURE AssignRtgRevision(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT VARCHAR2,
175: x_msg_count OUT NUMBER,
176: x_msg_data OUT VARCHAR2,
177: p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
179: x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
180: );
181: PROCEDURE ValidateRtgRevision(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT VARCHAR2,
187: x_msg_count OUT NUMBER,
180: );
181: PROCEDURE ValidateRtgRevision(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT VARCHAR2,
187: x_msg_count OUT NUMBER,
188: x_msg_data OUT VARCHAR2,
181: PROCEDURE ValidateRtgRevision(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT VARCHAR2,
187: x_msg_count OUT NUMBER,
188: x_msg_data OUT VARCHAR2,
189: p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
191: x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
192: );
193: PROCEDURE CreateRtgRevision(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT VARCHAR2,
199: x_msg_count OUT NUMBER,
192: );
193: PROCEDURE CreateRtgRevision(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT VARCHAR2,
199: x_msg_count OUT NUMBER,
200: x_msg_data OUT VARCHAR2,
193: PROCEDURE CreateRtgRevision(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT VARCHAR2,
199: x_msg_count OUT NUMBER,
200: x_msg_data OUT VARCHAR2,
201: p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
203: x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
204: );
205: PROCEDURE UpdateRtgRevision(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: p_commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: x_return_status OUT VARCHAR2,
211: x_msg_count OUT NUMBER,
204: );
205: PROCEDURE UpdateRtgRevision(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: p_commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: x_return_status OUT VARCHAR2,
211: x_msg_count OUT NUMBER,
212: x_msg_data OUT VARCHAR2,
205: PROCEDURE UpdateRtgRevision(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: p_commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: x_return_status OUT VARCHAR2,
211: x_msg_count OUT NUMBER,
212: x_msg_data OUT VARCHAR2,
213: p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
215: x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
216: );
217: PROCEDURE DeleteRtgRevision(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT VARCHAR2,
223: x_msg_count OUT NUMBER,
216: );
217: PROCEDURE DeleteRtgRevision(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT VARCHAR2,
223: x_msg_count OUT NUMBER,
224: x_msg_data OUT VARCHAR2,
217: PROCEDURE DeleteRtgRevision(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT VARCHAR2,
223: x_msg_count OUT NUMBER,
224: x_msg_data OUT VARCHAR2,
225: p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=