20: --
21: -- Standard IN Parameters:
22: -- p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2(1) Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2(1) Optional
26: -- Default = FND_API.G_FALSE
27: --
28: -- Standard OUT Parameters:
22: -- p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2(1) Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2(1) Optional
26: -- Default = FND_API.G_FALSE
27: --
28: -- Standard OUT Parameters:
29: -- x_return_status OUT VARCHAR2(1)
30: -- x_msg_count OUT NUMBER
135: -- End of comments
136:
137: TYPE interaction_rec_type IS RECORD
138: (
139: interaction_id NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
136:
137: TYPE interaction_rec_type IS RECORD
138: (
139: interaction_id NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
137: TYPE interaction_rec_type IS RECORD
138: (
139: interaction_id NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
138: (
139: interaction_id NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
139: interaction_id NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
140: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
141: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
142: duration NUMBER := fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
143: end_date_time DATE :=fnd_api.g_miss_date,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
144: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
145: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
146: preview_time_amount NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
147: productive_time_amount NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
148: start_date_time DATE :=fnd_api.g_miss_date,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
149: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
150: handler_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
151: script_id NUMBER :=fnd_api.g_miss_num,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
152: outcome_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
153: result_id NUMBER :=fnd_api.g_miss_num,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
154: reason_id NUMBER :=fnd_api.g_miss_num,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
155: resource_id NUMBER :=fnd_api.g_miss_num,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
156: party_id NUMBER :=fnd_api.g_miss_num,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
157: parent_id NUMBER :=fnd_api.g_miss_num,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
158: object_id NUMBER :=fnd_api.g_miss_num,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
159: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
160: source_code_id NUMBER :=fnd_api.g_miss_num,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
161: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
162: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
163: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
164: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
165: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
166: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
167: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
168: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
169: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
170: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
178: touchpoint1_type VARCHAR2(30) := 'PARTY',
171: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
178: touchpoint1_type VARCHAR2(30) := 'PARTY',
179: touchpoint2_type VARCHAR2(30) := 'RS_EMPLOYEE',
172: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
178: touchpoint1_type VARCHAR2(30) := 'PARTY',
179: touchpoint2_type VARCHAR2(30) := 'RS_EMPLOYEE',
180: -- Bug# 1732336
173: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
174: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
175: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
176: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
178: touchpoint1_type VARCHAR2(30) := 'PARTY',
179: touchpoint2_type VARCHAR2(30) := 'RS_EMPLOYEE',
180: -- Bug# 1732336
181: method_code VARCHAR2(30) :=fnd_api.g_miss_char,
177: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
178: touchpoint1_type VARCHAR2(30) := 'PARTY',
179: touchpoint2_type VARCHAR2(30) := 'RS_EMPLOYEE',
180: -- Bug# 1732336
181: method_code VARCHAR2(30) :=fnd_api.g_miss_char,
182: -- Enh# 2940473
183: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
179: touchpoint2_type VARCHAR2(30) := 'RS_EMPLOYEE',
180: -- Bug# 1732336
181: method_code VARCHAR2(30) :=fnd_api.g_miss_char,
182: -- Enh# 2940473
183: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
180: -- Bug# 1732336
181: method_code VARCHAR2(30) :=fnd_api.g_miss_char,
182: -- Enh# 2940473
183: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
181: method_code VARCHAR2(30) :=fnd_api.g_miss_char,
182: -- Enh# 2940473
183: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
189: contact_rel_party_id NUMBER := fnd_api.g_miss_num,
182: -- Enh# 2940473
183: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
189: contact_rel_party_id NUMBER := fnd_api.g_miss_num,
190: contact_party_id NUMBER := fnd_api.g_miss_num
184: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
189: contact_rel_party_id NUMBER := fnd_api.g_miss_num,
190: contact_party_id NUMBER := fnd_api.g_miss_num
191: );
192:
185: bulk_batch_id NUMBER := fnd_api.g_miss_num,
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
189: contact_rel_party_id NUMBER := fnd_api.g_miss_num,
190: contact_party_id NUMBER := fnd_api.g_miss_num
191: );
192:
193: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
186: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
187: -- Enh# 1846960
188: primary_party_id NUMBER := fnd_api.g_miss_num,
189: contact_rel_party_id NUMBER := fnd_api.g_miss_num,
190: contact_party_id NUMBER := fnd_api.g_miss_num
191: );
192:
193: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
194:
193: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
194:
195: TYPE activity_rec_type IS RECORD
196: (
197: activity_id NUMBER := fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
194:
195: TYPE activity_rec_type IS RECORD
196: (
197: activity_id NUMBER := fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
195: TYPE activity_rec_type IS RECORD
196: (
197: activity_id NUMBER := fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
196: (
197: activity_id NUMBER := fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
197: activity_id NUMBER := fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
198: duration NUMBER :=fnd_api.g_miss_num,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
199: cust_account_id NUMBER := fnd_api.g_miss_num,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
200: cust_org_id NUMBER := fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
201: role VARCHAR2(240) := fnd_api.g_miss_char,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
202: end_date_time DATE :=fnd_api.g_miss_date,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
203: start_date_time DATE :=fnd_api.g_miss_date,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
204: task_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
205: doc_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
206: doc_ref VARCHAR2(30) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
207: doc_source_object_name VARCHAR2(80) :=fnd_api.g_miss_char,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
208: media_id NUMBER :=fnd_api.g_miss_num,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
209: action_item_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
210: interaction_id NUMBER :=fnd_api.g_miss_num,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
211: outcome_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
212: result_id NUMBER :=fnd_api.g_miss_num,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
213: reason_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
214: description VARCHAR2(1000) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
215: action_id NUMBER :=fnd_api.g_miss_num,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
216: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
217: object_id NUMBER :=fnd_api.g_miss_num,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
218: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
219: source_code_id NUMBER :=fnd_api.g_miss_num,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
220: source_code VARCHAR2(100) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
221: script_trans_id NUMBER :=fnd_api.g_miss_num,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
222: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
223: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
224: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
225: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
226: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
227: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
228: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
229: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
230: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
231: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
232: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
233: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
234: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
235: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
236: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
242: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
243: bulk_batch_id NUMBER := fnd_api.g_miss_num,
237: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char,
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
242: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
243: bulk_batch_id NUMBER := fnd_api.g_miss_num,
244: bulk_interaction_id NUMBER := fnd_api.g_miss_num
245: );
238: -- Removed by IAleshin 06/05/2002
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
242: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
243: bulk_batch_id NUMBER := fnd_api.g_miss_num,
244: bulk_interaction_id NUMBER := fnd_api.g_miss_num
245: );
246: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
239: -- ,resource_id NUMBER := fnd_api.g_miss_num
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
242: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
243: bulk_batch_id NUMBER := fnd_api.g_miss_num,
244: bulk_interaction_id NUMBER := fnd_api.g_miss_num
245: );
246: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
247:
240: -- Enh# 2940473
241: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
242: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
243: bulk_batch_id NUMBER := fnd_api.g_miss_num,
244: bulk_interaction_id NUMBER := fnd_api.g_miss_num
245: );
246: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
247:
248: FUNCTION INIT_ACTIVITY_REC RETURN activity_rec_type;
255: * An unexpected error is returned if the calling program version number
256: * is incompatible with the current API version number.
257: * @param p_init_msg_list This flag is used to indicate if the message stack
258: * should be initialized. The values that are valid for this parameter are:
259: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
260: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
261: * to the fnd_msg_pub.initialize to initialize the message stack. When
262: * set to 'False', it is the responsibility of the calling program to
263: * initialize the message stack. It is only required that this action be
256: * is incompatible with the current API version number.
257: * @param p_init_msg_list This flag is used to indicate if the message stack
258: * should be initialized. The values that are valid for this parameter are:
259: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
260: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
261: * to the fnd_msg_pub.initialize to initialize the message stack. When
262: * set to 'False', it is the responsibility of the calling program to
263: * initialize the message stack. It is only required that this action be
264: * performed once, even when more than one API is called.
263: * initialize the message stack. It is only required that this action be
264: * performed once, even when more than one API is called.
265: * @param p_commit This flag is used to indicate if changes made to the
266: * transaction should be committed on success. The values that are valid
267: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
268: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
269: * before returning to the calling program. When set to 'False', it is the
270: * responsibility of the calling program to commit the transaction.
271: * @param p_resp_appl_id This represents the unique application identifier.
264: * performed once, even when more than one API is called.
265: * @param p_commit This flag is used to indicate if changes made to the
266: * transaction should be committed on success. The values that are valid
267: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
268: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
269: * before returning to the calling program. When set to 'False', it is the
270: * responsibility of the calling program to commit the transaction.
271: * @param p_resp_appl_id This represents the unique application identifier.
272: * @param p_resp_id This is a unique identifier for the responsibility.
275: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
276: * table and identifies the login session.
277: * @param x_return_status This flag is used to indicate the return status
278: * of the API. The values that are valid for this parameter are:
279: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR,
280: * and FND_API.G_RET_STS_UNEXP_ERROR.If the FND_API.G_RET_STS_SUCCESS
281: * value is returned, the API call was successful. If the
282: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
283: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value
276: * table and identifies the login session.
277: * @param x_return_status This flag is used to indicate the return status
278: * of the API. The values that are valid for this parameter are:
279: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR,
280: * and FND_API.G_RET_STS_UNEXP_ERROR.If the FND_API.G_RET_STS_SUCCESS
281: * value is returned, the API call was successful. If the
282: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
283: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value
284: * is returned, an unexpected error has occurred and the calling program
278: * of the API. The values that are valid for this parameter are:
279: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR,
280: * and FND_API.G_RET_STS_UNEXP_ERROR.If the FND_API.G_RET_STS_SUCCESS
281: * value is returned, the API call was successful. If the
282: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
283: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value
284: * is returned, an unexpected error has occurred and the calling program
285: * cannot correct the error.
286: * @param x_msg_count This represents the count of error messages in the
279: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR,
280: * and FND_API.G_RET_STS_UNEXP_ERROR.If the FND_API.G_RET_STS_SUCCESS
281: * value is returned, the API call was successful. If the
282: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
283: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value
284: * is returned, an unexpected error has occurred and the calling program
285: * cannot correct the error.
286: * @param x_msg_count This represents the count of error messages in the
287: * message list.
296: */
297: PROCEDURE Create_Interaction
298: (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: p_resp_appl_id IN NUMBER DEFAULT NULL,
303: p_resp_id IN NUMBER DEFAULT NULL,
304: p_user_id IN NUMBER,
297: PROCEDURE Create_Interaction
298: (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: p_resp_appl_id IN NUMBER DEFAULT NULL,
303: p_resp_id IN NUMBER DEFAULT NULL,
304: p_user_id IN NUMBER,
305: p_login_id IN NUMBER DEFAULT NULL,
319: --
320: -- Standard IN Parameters:
321: -- p_api_version IN NUMBER Required
322: -- p_init_msg_list IN VARCHAR2(1) Optional
323: -- Default = FND_API.G_FALSE
324: -- p_commit IN VARCHAR2(1) Optional
325: -- Default = FND_API.G_FALSE
326: --
327: -- Standard OUT Parameters:
321: -- p_api_version IN NUMBER Required
322: -- p_init_msg_list IN VARCHAR2(1) Optional
323: -- Default = FND_API.G_FALSE
324: -- p_commit IN VARCHAR2(1) Optional
325: -- Default = FND_API.G_FALSE
326: --
327: -- Standard OUT Parameters:
328: -- x_return_status OUT VARCHAR2(1)
329: -- x_msg_count OUT NUMBER
374: -- End of comments
375:
376: TYPE media_rec_type IS RECORD
377: (
378: media_id NUMBER :=fnd_api.g_miss_num,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
375:
376: TYPE media_rec_type IS RECORD
377: (
378: media_id NUMBER :=fnd_api.g_miss_num,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
376: TYPE media_rec_type IS RECORD
377: (
378: media_id NUMBER :=fnd_api.g_miss_num,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
377: (
378: media_id NUMBER :=fnd_api.g_miss_num,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
378: media_id NUMBER :=fnd_api.g_miss_num,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
379: source_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
380: direction VARCHAR2(240) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
381: duration NUMBER :=fnd_api.g_miss_num,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
382: end_date_time DATE :=fnd_api.g_miss_date,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
383: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
384: start_date_time DATE :=fnd_api.g_miss_date,
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
385: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
386: source_item_create_date_time DATE :=fnd_api.g_miss_date,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
387: source_item_id NUMBER :=fnd_api.g_miss_num,
388: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
389: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char,
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
390: media_abandon_flag VARCHAR2(1) :=fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
391: media_transferred_flag VARCHAR2(1) :=fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
392: -- added by IAleshin
393: server_group_id NUMBER :=fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
394: dnis VARCHAR2(30) :=fnd_api.g_miss_char,
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
401: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
402: -- Enh# 3022511
395: ani VARCHAR2(30) :=fnd_api.g_miss_char,
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
401: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
402: -- Enh# 3022511
403: address VARCHAR2(2000) := fnd_api.g_miss_char
396: classification VARCHAR2(64) :=fnd_api.g_miss_char,
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
401: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
402: -- Enh# 3022511
403: address VARCHAR2(2000) := fnd_api.g_miss_char
404: );
397: -- Enh# 2940473
398: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
401: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
402: -- Enh# 3022511
403: address VARCHAR2(2000) := fnd_api.g_miss_char
404: );
405: TYPE media_lc_rec_type IS RECORD
399: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
400: bulk_batch_id NUMBER := fnd_api.g_miss_num,
401: bulk_interaction_id NUMBER := fnd_api.g_miss_num,
402: -- Enh# 3022511
403: address VARCHAR2(2000) := fnd_api.g_miss_char
404: );
405: TYPE media_lc_rec_type IS RECORD
406: (
407: start_date_time DATE :=fnd_api.g_miss_date,
403: address VARCHAR2(2000) := fnd_api.g_miss_char
404: );
405: TYPE media_lc_rec_type IS RECORD
406: (
407: start_date_time DATE :=fnd_api.g_miss_date,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
404: );
405: TYPE media_lc_rec_type IS RECORD
406: (
407: start_date_time DATE :=fnd_api.g_miss_date,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
405: TYPE media_lc_rec_type IS RECORD
406: (
407: start_date_time DATE :=fnd_api.g_miss_date,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
406: (
407: start_date_time DATE :=fnd_api.g_miss_date,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
407: start_date_time DATE :=fnd_api.g_miss_date,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
408: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
409: type_id NUMBER :=fnd_api.g_miss_num,
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
410: duration NUMBER :=fnd_api.g_miss_num,
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
411: end_date_time DATE :=fnd_api.g_miss_date,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
412: milcs_id NUMBER :=fnd_api.g_miss_num,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
413: milcs_type_id NUMBER :=fnd_api.g_miss_num,
414: media_id NUMBER :=fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
421: bulk_batch_id NUMBER := fnd_api.g_miss_num,
415: handler_id NUMBER :=fnd_api.g_miss_num,
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
421: bulk_batch_id NUMBER := fnd_api.g_miss_num,
422: bulk_interaction_id NUMBER := fnd_api.g_miss_num
423: );
416: resource_id NUMBER :=fnd_api.g_miss_num, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
421: bulk_batch_id NUMBER := fnd_api.g_miss_num,
422: bulk_interaction_id NUMBER := fnd_api.g_miss_num
423: );
424:
417: milcs_code VARCHAR2(80) := fnd_api.g_miss_char, -- Added by Jim Baldo 30 November 2000 for bugdb 1501325
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
421: bulk_batch_id NUMBER := fnd_api.g_miss_num,
422: bulk_interaction_id NUMBER := fnd_api.g_miss_num
423: );
424:
425: TYPE mlcs_tbl_type IS TABLE OF media_lc_rec_type INDEX BY BINARY_INTEGER;
418: -- Enh# 2940473
419: bulk_writer_code VARCHAR2(240) := fnd_api.g_miss_char,
420: bulk_batch_type VARCHAR2(240) := fnd_api.g_miss_char,
421: bulk_batch_id NUMBER := fnd_api.g_miss_num,
422: bulk_interaction_id NUMBER := fnd_api.g_miss_num
423: );
424:
425: TYPE mlcs_tbl_type IS TABLE OF media_lc_rec_type INDEX BY BINARY_INTEGER;
426:
433: * An unexpected error is returned if the calling program version number
434: * is incompatible with the current API version number.
435: * @param p_init_msg_list This flag is used to indicate if the message stack
436: * should be initialized. The values that are valid for this parameter are:
437: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
438: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
439: * to the fnd_msg_pub.initialize to initialize the message stack. When
440: * set to 'False', it is the responsibility of the calling program to
441: * initialize the message stack. It is only required that this action be
434: * is incompatible with the current API version number.
435: * @param p_init_msg_list This flag is used to indicate if the message stack
436: * should be initialized. The values that are valid for this parameter are:
437: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
438: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
439: * to the fnd_msg_pub.initialize to initialize the message stack. When
440: * set to 'False', it is the responsibility of the calling program to
441: * initialize the message stack. It is only required that this action be
442: * performed once, even when more than one API is called.
441: * initialize the message stack. It is only required that this action be
442: * performed once, even when more than one API is called.
443: * @param p_commit This flag is used to indicate if changes made to the
444: * transaction should be committed on success. The values that are valid
445: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
446: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
447: * before returning to the calling program. When set to 'False', it is the
448: * responsibility of the calling program to commit the transaction.
449: * @param p_resp_appl_id This represents the unique application identifier.
442: * performed once, even when more than one API is called.
443: * @param p_commit This flag is used to indicate if changes made to the
444: * transaction should be committed on success. The values that are valid
445: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
446: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
447: * before returning to the calling program. When set to 'False', it is the
448: * responsibility of the calling program to commit the transaction.
449: * @param p_resp_appl_id This represents the unique application identifier.
450: * @param p_resp_id This is a unique identifier for the responsibility.
453: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
454: * table and identifies the login session.
455: * @param x_return_status This flag is used to indicate the return
456: * status of the API. The values that are valid for this parameter are:
457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
460: * value is returned, a validation or missing data error has occurred. If
461: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
454: * table and identifies the login session.
455: * @param x_return_status This flag is used to indicate the return
456: * status of the API. The values that are valid for this parameter are:
457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
460: * value is returned, a validation or missing data error has occurred. If
461: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
462: * has occurred and the calling program cannot correct the error.
455: * @param x_return_status This flag is used to indicate the return
456: * status of the API. The values that are valid for this parameter are:
457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
460: * value is returned, a validation or missing data error has occurred. If
461: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
462: * has occurred and the calling program cannot correct the error.
463: * @param x_msg_count This represents the count of error messages in the
457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
460: * value is returned, a validation or missing data error has occurred. If
461: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
462: * has occurred and the calling program cannot correct the error.
463: * @param x_msg_count This represents the count of error messages in the
464: * message list.
465: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
475: */
476: PROCEDURE Create_MediaItem
477: (
478: p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
481: p_resp_appl_id IN NUMBER DEFAULT NULL,
482: p_resp_id IN NUMBER DEFAULT NULL,
483: p_user_id IN NUMBER,
476: PROCEDURE Create_MediaItem
477: (
478: p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
481: p_resp_appl_id IN NUMBER DEFAULT NULL,
482: p_resp_id IN NUMBER DEFAULT NULL,
483: p_user_id IN NUMBER,
484: p_login_id IN NUMBER DEFAULT NULL,
496: * An unexpected error is returned if the calling program version number
497: * is incompatible with the current API version number.
498: * @param p_init_msg_list This flag is used to indicate if the message stack
499: * should be initialized. The values that are valid for this parameter are:
500: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
501: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
502: * to the fnd_msg_pub.initialize to initialize the message stack. When
503: * set to 'False', it is the responsibility of the calling program to
504: * initialize the message stack. It is only required that this action be
497: * is incompatible with the current API version number.
498: * @param p_init_msg_list This flag is used to indicate if the message stack
499: * should be initialized. The values that are valid for this parameter are:
500: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
501: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
502: * to the fnd_msg_pub.initialize to initialize the message stack. When
503: * set to 'False', it is the responsibility of the calling program to
504: * initialize the message stack. It is only required that this action be
505: * performed once, even when more than one API is called.
504: * initialize the message stack. It is only required that this action be
505: * performed once, even when more than one API is called.
506: * @param p_commit This flag is used to indicate if changes made to the
507: * transaction should be committed on success. The values that are valid
508: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
509: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
510: * before returning to the calling program. When set to 'False', it is the
511: * responsibility of the calling program to commit the transaction.
512: * @param p_resp_appl_id This represents the unique application identifier.
505: * performed once, even when more than one API is called.
506: * @param p_commit This flag is used to indicate if changes made to the
507: * transaction should be committed on success. The values that are valid
508: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
509: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
510: * before returning to the calling program. When set to 'False', it is the
511: * responsibility of the calling program to commit the transaction.
512: * @param p_resp_appl_id This represents the unique application identifier.
513: * @param p_resp_id This is a unique identifier for the responsibility.
516: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
517: * table and identifies the login session.
518: * @param x_return_status This flag is used to indicate the return
519: * status of the API. The values that are valid for this parameter are:
520: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
521: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
522: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
523: * value is returned, a validation or missing data error has occurred. If
524: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
517: * table and identifies the login session.
518: * @param x_return_status This flag is used to indicate the return
519: * status of the API. The values that are valid for this parameter are:
520: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
521: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
522: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
523: * value is returned, a validation or missing data error has occurred. If
524: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
525: * has occurred and the calling program cannot correct the error.
518: * @param x_return_status This flag is used to indicate the return
519: * status of the API. The values that are valid for this parameter are:
520: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
521: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
522: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
523: * value is returned, a validation or missing data error has occurred. If
524: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
525: * has occurred and the calling program cannot correct the error.
526: * @param x_msg_count This represents the count of error messages in the
520: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
521: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
522: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
523: * value is returned, a validation or missing data error has occurred. If
524: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
525: * has occurred and the calling program cannot correct the error.
526: * @param x_msg_count This represents the count of error messages in the
527: * message list.
528: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
537: */
538: PROCEDURE Create_MediaItem
539: (
540: p_api_version IN NUMBER,
541: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
542: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
543: p_resp_appl_id IN NUMBER DEFAULT NULL,
544: p_resp_id IN NUMBER DEFAULT NULL,
545: p_user_id IN NUMBER,
538: PROCEDURE Create_MediaItem
539: (
540: p_api_version IN NUMBER,
541: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
542: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
543: p_resp_appl_id IN NUMBER DEFAULT NULL,
544: p_resp_id IN NUMBER DEFAULT NULL,
545: p_user_id IN NUMBER,
546: p_login_id IN NUMBER DEFAULT NULL,
560: --
561: -- Standard IN Parameters:
562: -- p_api_version IN NUMBER Required
563: -- p_init_msg_list IN VARCHAR2(1) Optional
564: -- Default = FND_API.G_FALSE
565: -- p_commit IN VARCHAR2(1) Optional
566: -- Default = FND_API.G_FALSE
567: --
568: -- Standard OUT Parameters:
562: -- p_api_version IN NUMBER Required
563: -- p_init_msg_list IN VARCHAR2(1) Optional
564: -- Default = FND_API.G_FALSE
565: -- p_commit IN VARCHAR2(1) Optional
566: -- Default = FND_API.G_FALSE
567: --
568: -- Standard OUT Parameters:
569: -- x_return_status OUT VARCHAR2(1)
570: -- x_msg_count OUT NUMBER
617: * An unexpected error is returned if the calling program version number
618: * is incompatible with the current API version number.
619: * @param p_init_msg_list This flag is used to indicate if the message stack
620: * should be initialized. The values that are valid for this parameter are:
621: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
622: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
623: * to the fnd_msg_pub.initialize to initialize the message stack. When
624: * set to 'False', it is the responsibility of the calling program to
625: * initialize the message stack. It is only required that this action be
618: * is incompatible with the current API version number.
619: * @param p_init_msg_list This flag is used to indicate if the message stack
620: * should be initialized. The values that are valid for this parameter are:
621: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
622: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
623: * to the fnd_msg_pub.initialize to initialize the message stack. When
624: * set to 'False', it is the responsibility of the calling program to
625: * initialize the message stack. It is only required that this action be
626: * performed once, even when more than one API is called.
625: * initialize the message stack. It is only required that this action be
626: * performed once, even when more than one API is called.
627: * @param p_commit This flag is used to indicate if changes made to the
628: * transaction should be committed on success. The values that are valid
629: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
630: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
631: * before returning to the calling program. When set to 'False', it is the
632: * responsibility of the calling program to commit the transaction.
633: * @param p_resp_appl_id This represents the unique application identifier.
626: * performed once, even when more than one API is called.
627: * @param p_commit This flag is used to indicate if changes made to the
628: * transaction should be committed on success. The values that are valid
629: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
630: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
631: * before returning to the calling program. When set to 'False', it is the
632: * responsibility of the calling program to commit the transaction.
633: * @param p_resp_appl_id This represents the unique application identifier.
634: * @param p_resp_id This is a unique identifier for the responsibility.
637: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
638: * table and identifies the login session.
639: * @param x_return_status This flag is used to indicate the return status
640: * of the API. The values that are valid for this parameter are:
641: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
642: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
643: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
644: * value is returned, a validation or missing data error has occurred. If
645: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
638: * table and identifies the login session.
639: * @param x_return_status This flag is used to indicate the return status
640: * of the API. The values that are valid for this parameter are:
641: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
642: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
643: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
644: * value is returned, a validation or missing data error has occurred. If
645: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
646: * has occurred and the calling program cannot correct the error.
639: * @param x_return_status This flag is used to indicate the return status
640: * of the API. The values that are valid for this parameter are:
641: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
642: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
643: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
644: * value is returned, a validation or missing data error has occurred. If
645: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
646: * has occurred and the calling program cannot correct the error.
647: * @param x_msg_count This represents the count of error messages in the
641: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
642: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
643: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
644: * value is returned, a validation or missing data error has occurred. If
645: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
646: * has occurred and the calling program cannot correct the error.
647: * @param x_msg_count This represents the count of error messages in the
648: * message list.
649: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
655: */
656: PROCEDURE Create_MediaLifecycle
657: (
658: p_api_version IN NUMBER,
659: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
660: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
661: p_resp_appl_id IN NUMBER DEFAULT NULL,
662: p_resp_id IN NUMBER DEFAULT NULL,
663: p_user_id IN NUMBER,
656: PROCEDURE Create_MediaLifecycle
657: (
658: p_api_version IN NUMBER,
659: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
660: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
661: p_resp_appl_id IN NUMBER DEFAULT NULL,
662: p_resp_id IN NUMBER DEFAULT NULL,
663: p_user_id IN NUMBER,
664: p_login_id IN NUMBER DEFAULT NULL,
676: --
677: -- Standard IN Parameters:
678: -- p_api_version IN NUMBER Required
679: -- p_init_msg_list IN VARCHAR2(1) Optional
680: -- Default = FND_API.G_FALSE
681: --
682: -- Standard OUT Parameters:
683: -- x_return_status OUT VARCHAR2(1)
684: -- x_msg_count OUT NUMBER
727: * An unexpected error is returned if the calling program version number
728: * is incompatible with the current API version number.
729: * @param p_init_msg_list This flag is used to indicate if the message stack
730: * should be initialized. The values that are valid for this parameter are:
731: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
732: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
733: * to the fnd_msg_pub.initialize to initialize the message stack. When
734: * set to 'False', it is the responsibility of the calling program to
735: * initialize the message stack. It is only required that this action be
728: * is incompatible with the current API version number.
729: * @param p_init_msg_list This flag is used to indicate if the message stack
730: * should be initialized. The values that are valid for this parameter are:
731: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
732: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
733: * to the fnd_msg_pub.initialize to initialize the message stack. When
734: * set to 'False', it is the responsibility of the calling program to
735: * initialize the message stack. It is only required that this action be
736: * performed once, even when more than one API is called.
741: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
742: * table and identifies the login session.
743: * @param x_return_status This flag is used to indicate the return
744: * status of the API. The values that are valid for this parameter are:
745: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
746: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
747: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
748: * value is returned, a validation or missing data error has occurred.
749: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected
742: * table and identifies the login session.
743: * @param x_return_status This flag is used to indicate the return
744: * status of the API. The values that are valid for this parameter are:
745: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
746: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
747: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
748: * value is returned, a validation or missing data error has occurred.
749: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected
750: * error has occurred and the calling program cannot correct the error.
743: * @param x_return_status This flag is used to indicate the return
744: * status of the API. The values that are valid for this parameter are:
745: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
746: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
747: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
748: * value is returned, a validation or missing data error has occurred.
749: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected
750: * error has occurred and the calling program cannot correct the error.
751: * @param x_msg_count This represents the count of error messages in the
745: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
746: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
747: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
748: * value is returned, a validation or missing data error has occurred.
749: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected
750: * error has occurred and the calling program cannot correct the error.
751: * @param x_msg_count This represents the count of error messages in the
752: * message list.
753: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
768: */
769: PROCEDURE Get_InteractionActivityCount
770: (
771: p_api_version IN NUMBER,
772: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
773: p_resp_appl_id IN NUMBER DEFAULT NULL,
774: p_resp_id IN NUMBER DEFAULT NULL,
775: p_user_id IN NUMBER,
776: p_login_id IN NUMBER DEFAULT NULL,
793: --
794: -- Standard IN Parameters:
795: -- p_api_version IN NUMBER Required
796: -- p_init_msg_list IN VARCHAR2(1) Optional
797: -- Default = FND_API.G_FALSE
798: --
799: -- Standard OUT Parameters:
800: -- x_return_status OUT VARCHAR2(1)
801: -- x_msg_count OUT NUMBER
860: * An unexpected error is returned if the calling program version number
861: * is incompatible with the current API version number.
862: * @param p_init_msg_list This flag is used to indicate if the message stack
863: * should be initialized. The values that are valid for this parameter are:
864: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
865: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
866: * to the fnd_msg_pub.initialize to initialize the message stack. When
867: * set to 'False', it is the responsibility of the calling program to
868: * initialize the message stack. It is only required that this action be
861: * is incompatible with the current API version number.
862: * @param p_init_msg_list This flag is used to indicate if the message stack
863: * should be initialized. The values that are valid for this parameter are:
864: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
865: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
866: * to the fnd_msg_pub.initialize to initialize the message stack. When
867: * set to 'False', it is the responsibility of the calling program to
868: * initialize the message stack. It is only required that this action be
869: * performed once, even when more than one API is called.
874: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
875: * table and identifies the login session.
876: * @param x_return_status This flag is used to indicate the return
877: * status of the API. The values that are valid for this parameter are:
878: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
879: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
880: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
881: * value is returned, a validation or missing data error has occurred.
882: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
875: * table and identifies the login session.
876: * @param x_return_status This flag is used to indicate the return
877: * status of the API. The values that are valid for this parameter are:
878: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
879: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
880: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
881: * value is returned, a validation or missing data error has occurred.
882: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
883: * has occurred and the calling program cannot correct the error.
876: * @param x_return_status This flag is used to indicate the return
877: * status of the API. The values that are valid for this parameter are:
878: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
879: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
880: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
881: * value is returned, a validation or missing data error has occurred.
882: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
883: * has occurred and the calling program cannot correct the error.
884: * @param x_msg_count This represents the count of error messages in the
878: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
879: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
880: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
881: * value is returned, a validation or missing data error has occurred.
882: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
883: * has occurred and the calling program cannot correct the error.
884: * @param x_msg_count This represents the count of error messages in the
885: * message list.
886: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
912: */
913: PROCEDURE Get_InteractionCount
914: (
915: p_api_version IN NUMBER,
916: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
917: p_resp_appl_id IN NUMBER DEFAULT NULL,
918: p_resp_id IN NUMBER DEFAULT NULL,
919: p_user_id IN NUMBER,
920: p_login_id IN NUMBER DEFAULT NULL,
952: --
953: -- Standard IN Parameters:
954: -- p_api_version IN NUMBER Required
955: -- p_init_msg_list IN VARCHAR2(1) Optional
956: -- Default = FND_API.G_FALSE
957: --
958: -- Standard OUT Parameters:
959: -- x_return_status OUT VARCHAR2(1)
960: -- x_msg_count OUT NUMBER
1001: * An unexpected error is returned if the calling program version number
1002: * is incompatible with the current API version number.
1003: * @param p_init_msg_list This flag is used to indicate if the message stack
1004: * should be initialized. The values that are valid for this parameter are:
1005: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1006: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1007: * to the fnd_msg_pub.initialize to initialize the message stack. When
1008: * set to 'False', it is the responsibility of the calling program to
1009: * initialize the message stack. It is only required that this action be
1002: * is incompatible with the current API version number.
1003: * @param p_init_msg_list This flag is used to indicate if the message stack
1004: * should be initialized. The values that are valid for this parameter are:
1005: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1006: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1007: * to the fnd_msg_pub.initialize to initialize the message stack. When
1008: * set to 'False', it is the responsibility of the calling program to
1009: * initialize the message stack. It is only required that this action be
1010: * performed once, even when more than one API is called.
1009: * initialize the message stack. It is only required that this action be
1010: * performed once, even when more than one API is called.
1011: * @param p_commit This flag is used to indicate if changes made to the
1012: * transaction should be committed on success. The values that are valid
1013: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1014: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1015: * before returning to the calling program. When set to 'False', it is the
1016: * responsibility of the calling program to commit the transaction.
1017: * @param p_resp_appl_id This represents the unique application identifier.
1010: * performed once, even when more than one API is called.
1011: * @param p_commit This flag is used to indicate if changes made to the
1012: * transaction should be committed on success. The values that are valid
1013: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1014: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1015: * before returning to the calling program. When set to 'False', it is the
1016: * responsibility of the calling program to commit the transaction.
1017: * @param p_resp_appl_id This represents the unique application identifier.
1018: * @param p_resp_id This is a unique identifier for the responsibility.
1021: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1022: * table and identifies the login session.
1023: * @param x_return_status This flag is used to indicate the return status
1024: * of the API. The values that are valid for this parameter are:
1025: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1026: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1027: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1028: * value is returned, a validation or missing data error has occurred.
1029: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1022: * table and identifies the login session.
1023: * @param x_return_status This flag is used to indicate the return status
1024: * of the API. The values that are valid for this parameter are:
1025: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1026: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1027: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1028: * value is returned, a validation or missing data error has occurred.
1029: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1030: * has occurred and the calling program cannot correct the error.
1023: * @param x_return_status This flag is used to indicate the return status
1024: * of the API. The values that are valid for this parameter are:
1025: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1026: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1027: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1028: * value is returned, a validation or missing data error has occurred.
1029: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1030: * has occurred and the calling program cannot correct the error.
1031: * @param x_msg_count This represents the count of error messages in the
1025: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1026: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1027: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1028: * value is returned, a validation or missing data error has occurred.
1029: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1030: * has occurred and the calling program cannot correct the error.
1031: * @param x_msg_count This represents the count of error messages in the
1032: * message list.
1033: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1041: */
1042: PROCEDURE Open_Interaction
1043: (
1044: p_api_version IN NUMBER,
1045: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1046: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1047: p_resp_appl_id IN NUMBER DEFAULT NULL,
1048: p_resp_id IN NUMBER DEFAULT NULL,
1049: p_user_id IN NUMBER,
1042: PROCEDURE Open_Interaction
1043: (
1044: p_api_version IN NUMBER,
1045: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1046: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1047: p_resp_appl_id IN NUMBER DEFAULT NULL,
1048: p_resp_id IN NUMBER DEFAULT NULL,
1049: p_user_id IN NUMBER,
1050: p_login_id IN NUMBER DEFAULT NULL,
1064: --
1065: -- Standard IN Parameters:
1066: -- p_api_version IN NUMBER Required
1067: -- p_init_msg_list IN VARCHAR2(1) Optional
1068: -- Default = FND_API.G_FALSE
1069: --
1070: -- Standard OUT Parameters:
1071: -- x_return_status OUT VARCHAR2(1)
1072: -- x_msg_count OUT NUMBER
1109: * An unexpected error is returned if the calling program version number
1110: * is incompatible with the current API version number.
1111: * @param p_init_msg_list This flag is used to indicate if the message stack
1112: * should be initialized. The values that are valid for this parameter are:
1113: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1114: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1115: * to the fnd_msg_pub.initialize to initialize the message stack. When
1116: * set to 'False', it is the responsibility of the calling program to
1117: * initialize the message stack. It is only required that this action be
1110: * is incompatible with the current API version number.
1111: * @param p_init_msg_list This flag is used to indicate if the message stack
1112: * should be initialized. The values that are valid for this parameter are:
1113: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1114: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1115: * to the fnd_msg_pub.initialize to initialize the message stack. When
1116: * set to 'False', it is the responsibility of the calling program to
1117: * initialize the message stack. It is only required that this action be
1118: * performed once, even when more than one API is called.
1117: * initialize the message stack. It is only required that this action be
1118: * performed once, even when more than one API is called.
1119: * @param p_commit This flag is used to indicate if changes made to the
1120: * transaction should be committed on success. The values that are valid
1121: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1122: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1123: * before returning to the calling program. When set to 'False', it is the
1124: * responsibility of the calling program to commit the transaction.
1125: * @param p_resp_appl_id This represents the unique application identifier.
1118: * performed once, even when more than one API is called.
1119: * @param p_commit This flag is used to indicate if changes made to the
1120: * transaction should be committed on success. The values that are valid
1121: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1122: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1123: * before returning to the calling program. When set to 'False', it is the
1124: * responsibility of the calling program to commit the transaction.
1125: * @param p_resp_appl_id This represents the unique application identifier.
1126: * @param p_resp_id This is a unique identifier for the responsibility.
1129: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1130: * table and identifies the login session.
1131: * @param x_return_status This flag is used to indicate the return status
1132: * of the API. The values that are valid for this parameter are:
1133: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1134: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1135: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1136: * value is returned, a validation or missing data error has occurred. If
1137: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1130: * table and identifies the login session.
1131: * @param x_return_status This flag is used to indicate the return status
1132: * of the API. The values that are valid for this parameter are:
1133: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1134: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1135: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1136: * value is returned, a validation or missing data error has occurred. If
1137: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1138: * has occurred and the calling program cannot correct the error.
1131: * @param x_return_status This flag is used to indicate the return status
1132: * of the API. The values that are valid for this parameter are:
1133: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1134: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1135: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1136: * value is returned, a validation or missing data error has occurred. If
1137: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1138: * has occurred and the calling program cannot correct the error.
1139: * @param x_msg_count This represents the count of error messages in the
1133: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1134: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1135: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1136: * value is returned, a validation or missing data error has occurred. If
1137: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1138: * has occurred and the calling program cannot correct the error.
1139: * @param x_msg_count This represents the count of error messages in the
1140: * message list.
1141: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1147: */
1148: PROCEDURE Update_Interaction
1149: (
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1152: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1153: p_resp_appl_id IN NUMBER DEFAULT NULL,
1154: p_resp_id IN NUMBER DEFAULT NULL,
1155: p_user_id IN NUMBER,
1148: PROCEDURE Update_Interaction
1149: (
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1152: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1153: p_resp_appl_id IN NUMBER DEFAULT NULL,
1154: p_resp_id IN NUMBER DEFAULT NULL,
1155: p_user_id IN NUMBER,
1156: p_login_id IN NUMBER DEFAULT NULL,
1171: --
1172: -- Standard IN Parameters:
1173: -- p_api_version IN NUMBER Required
1174: -- p_init_msg_list IN VARCHAR2(1) Optional
1175: -- Default = FND_API.G_FALSE
1176: --
1177: -- Standard OUT Parameters:
1178: -- x_return_status OUT VARCHAR2(1)
1179: -- x_msg_count OUT NUMBER
1217: * An unexpected error is returned if the calling program version number
1218: * is incompatible with the current API version number.
1219: * @param p_init_msg_list This flag is used to indicate if the message stack
1220: * should be initialized. The values that are valid for this parameter are:
1221: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1222: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1223: * to the fnd_msg_pub.initialize to initialize the message stack. When
1224: * set to 'False', it is the responsibility of the calling program to
1225: * initialize the message stack. It is only required that this action be
1218: * is incompatible with the current API version number.
1219: * @param p_init_msg_list This flag is used to indicate if the message stack
1220: * should be initialized. The values that are valid for this parameter are:
1221: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1222: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1223: * to the fnd_msg_pub.initialize to initialize the message stack. When
1224: * set to 'False', it is the responsibility of the calling program to
1225: * initialize the message stack. It is only required that this action be
1226: * performed once, even when more than one API is called.
1225: * initialize the message stack. It is only required that this action be
1226: * performed once, even when more than one API is called.
1227: * @param p_commit This flag is used to indicate if changes made to the
1228: * transaction should be committed on success. The values that are valid
1229: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1230: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1231: * before returning to the calling program. When set to 'False', it is the
1232: * responsibility of the calling program to commit the transaction.
1233: * @param p_resp_appl_id This represents the unique application identifier.
1226: * performed once, even when more than one API is called.
1227: * @param p_commit This flag is used to indicate if changes made to the
1228: * transaction should be committed on success. The values that are valid
1229: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1230: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1231: * before returning to the calling program. When set to 'False', it is the
1232: * responsibility of the calling program to commit the transaction.
1233: * @param p_resp_appl_id This represents the unique application identifier.
1234: * @param p_resp_id This is a unique identifier for the responsibility.
1237: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1238: * table and identifies the login session.
1239: * @param x_return_status This flag is used to indicate the return status
1240: * of the API. The values that are valid for this parameter are:
1241: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1242: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value is
1243: * returned, the API call was successful. If the FND_API.G_RET_STS_ERROR value
1244: * is returned, a validation or missing data error has occurred. If the
1245: * FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1238: * table and identifies the login session.
1239: * @param x_return_status This flag is used to indicate the return status
1240: * of the API. The values that are valid for this parameter are:
1241: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1242: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value is
1243: * returned, the API call was successful. If the FND_API.G_RET_STS_ERROR value
1244: * is returned, a validation or missing data error has occurred. If the
1245: * FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1246: * has occurred and the calling program cannot correct the error.
1239: * @param x_return_status This flag is used to indicate the return status
1240: * of the API. The values that are valid for this parameter are:
1241: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1242: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value is
1243: * returned, the API call was successful. If the FND_API.G_RET_STS_ERROR value
1244: * is returned, a validation or missing data error has occurred. If the
1245: * FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1246: * has occurred and the calling program cannot correct the error.
1247: * @param x_msg_count This represents the count of error messages in the
1241: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1242: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value is
1243: * returned, the API call was successful. If the FND_API.G_RET_STS_ERROR value
1244: * is returned, a validation or missing data error has occurred. If the
1245: * FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1246: * has occurred and the calling program cannot correct the error.
1247: * @param x_msg_count This represents the count of error messages in the
1248: * message list.
1249: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1255: */
1256: PROCEDURE Close_Interaction
1257: (
1258: p_api_version IN NUMBER,
1259: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1260: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1261: p_resp_appl_id IN NUMBER DEFAULT NULL,
1262: p_resp_id IN NUMBER DEFAULT NULL,
1263: p_user_id IN NUMBER,
1256: PROCEDURE Close_Interaction
1257: (
1258: p_api_version IN NUMBER,
1259: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1260: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1261: p_resp_appl_id IN NUMBER DEFAULT NULL,
1262: p_resp_id IN NUMBER DEFAULT NULL,
1263: p_user_id IN NUMBER,
1264: p_login_id IN NUMBER DEFAULT NULL,
1278: --
1279: -- Standard IN Parameters:
1280: -- p_api_version IN NUMBER Required
1281: -- p_init_msg_list IN VARCHAR2(1) Optional
1282: -- Default = FND_API.G_FALSE
1283: --
1284: -- Standard OUT Parameters:
1285: -- x_return_status OUT VARCHAR2(1)
1286: -- x_msg_count OUT NUMBER
1325: * An unexpected error is returned if the calling program version number
1326: * is incompatible with the current API version number.
1327: * @param p_init_msg_list This flag is used to indicate if the message stack
1328: * should be initialized. The values that are valid for this parameter are:
1329: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1330: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1331: * to the fnd_msg_pub.initialize to initialize the message stack. When
1332: * set to 'False', it is the responsibility of the calling program to
1333: * initialize the message stack. It is only required that this action be
1326: * is incompatible with the current API version number.
1327: * @param p_init_msg_list This flag is used to indicate if the message stack
1328: * should be initialized. The values that are valid for this parameter are:
1329: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1330: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1331: * to the fnd_msg_pub.initialize to initialize the message stack. When
1332: * set to 'False', it is the responsibility of the calling program to
1333: * initialize the message stack. It is only required that this action be
1334: * performed once, even when more than one API is called.
1333: * initialize the message stack. It is only required that this action be
1334: * performed once, even when more than one API is called.
1335: * @param p_commit This flag is used to indicate if changes made to the
1336: * transaction should be committed on success. The values that are valid
1337: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1338: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1339: * before returning to the calling program. When set to 'False', it is the
1340: * responsibility of the calling program to commit the transaction.
1341: * @param p_resp_appl_id This represents the unique application identifier.
1334: * performed once, even when more than one API is called.
1335: * @param p_commit This flag is used to indicate if changes made to the
1336: * transaction should be committed on success. The values that are valid
1337: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1338: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1339: * before returning to the calling program. When set to 'False', it is the
1340: * responsibility of the calling program to commit the transaction.
1341: * @param p_resp_appl_id This represents the unique application identifier.
1342: * @param p_resp_id This is a unique identifier for the responsibility.
1345: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1346: * table and identifies the login session.
1347: * @param x_return_status This flag is used to indicate the return
1348: * status of the API. The values that are valid for this parameter are:
1349: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1350: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1351: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1352: * value is returned, a validation or missing data error has occurred. If
1353: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1346: * table and identifies the login session.
1347: * @param x_return_status This flag is used to indicate the return
1348: * status of the API. The values that are valid for this parameter are:
1349: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1350: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1351: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1352: * value is returned, a validation or missing data error has occurred. If
1353: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1354: * has occurred and the calling program cannot correct the error.
1347: * @param x_return_status This flag is used to indicate the return
1348: * status of the API. The values that are valid for this parameter are:
1349: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1350: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1351: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1352: * value is returned, a validation or missing data error has occurred. If
1353: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1354: * has occurred and the calling program cannot correct the error.
1355: * @param x_msg_count This represents the count of error messages in the
1349: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1350: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1351: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1352: * value is returned, a validation or missing data error has occurred. If
1353: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1354: * has occurred and the calling program cannot correct the error.
1355: * @param x_msg_count This represents the count of error messages in the
1356: * message list.
1357: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1366: */
1367: PROCEDURE Add_Activity
1368: (
1369: p_api_version IN NUMBER,
1370: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1371: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1372: p_resp_appl_id IN NUMBER DEFAULT NULL,
1373: p_resp_id IN NUMBER DEFAULT NULL,
1374: p_user_id IN NUMBER,
1367: PROCEDURE Add_Activity
1368: (
1369: p_api_version IN NUMBER,
1370: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1371: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1372: p_resp_appl_id IN NUMBER DEFAULT NULL,
1373: p_resp_id IN NUMBER DEFAULT NULL,
1374: p_user_id IN NUMBER,
1375: p_login_id IN NUMBER DEFAULT NULL,
1389: --
1390: -- Standard IN Parameters:
1391: -- p_api_version IN NUMBER Required
1392: -- p_init_msg_list IN VARCHAR2(1) Optional
1393: -- Default = FND_API.G_FALSE
1394: --
1395: -- Standard OUT Parameters:
1396: -- x_return_status OUT VARCHAR2(1)
1397: -- x_msg_count OUT NUMBER
1433: * An unexpected error is returned if the calling program version number
1434: * is incompatible with the current API version number.
1435: * @param p_init_msg_list This flag is used to indicate if the message stack
1436: * should be initialized. The values that are valid for this parameter are:
1437: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1438: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1439: * to the fnd_msg_pub.initialize to initialize the message stack. When
1440: * set to 'False', it is the responsibility of the calling program to
1441: * initialize the message stack. It is only required that this action be
1434: * is incompatible with the current API version number.
1435: * @param p_init_msg_list This flag is used to indicate if the message stack
1436: * should be initialized. The values that are valid for this parameter are:
1437: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1438: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1439: * to the fnd_msg_pub.initialize to initialize the message stack. When
1440: * set to 'False', it is the responsibility of the calling program to
1441: * initialize the message stack. It is only required that this action be
1442: * performed once, even when more than one API is called.
1441: * initialize the message stack. It is only required that this action be
1442: * performed once, even when more than one API is called.
1443: * @param p_commit This flag is used to indicate if changes made to the
1444: * transaction should be committed on success. The values that are valid
1445: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1446: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1447: * before returning to the calling program. When set to 'False', it is the
1448: * responsibility of the calling program to commit the transaction.
1449: * @param p_resp_appl_id This represents the unique application identifier.
1442: * performed once, even when more than one API is called.
1443: * @param p_commit This flag is used to indicate if changes made to the
1444: * transaction should be committed on success. The values that are valid
1445: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1446: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1447: * before returning to the calling program. When set to 'False', it is the
1448: * responsibility of the calling program to commit the transaction.
1449: * @param p_resp_appl_id This represents the unique application identifier.
1450: * @param p_resp_id This is a unique identifier for the responsibility.
1453: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1454: * table and identifies the login session.
1455: * @param x_return_status This flag is used to indicate the return
1456: * status of the API. The values that are valid for this parameter are:
1457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1460: * value is returned, a validation or missing data error has occurred.
1461: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1454: * table and identifies the login session.
1455: * @param x_return_status This flag is used to indicate the return
1456: * status of the API. The values that are valid for this parameter are:
1457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1460: * value is returned, a validation or missing data error has occurred.
1461: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1462: * has occurred and the calling program cannot correct the error.
1455: * @param x_return_status This flag is used to indicate the return
1456: * status of the API. The values that are valid for this parameter are:
1457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1460: * value is returned, a validation or missing data error has occurred.
1461: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1462: * has occurred and the calling program cannot correct the error.
1463: * @param x_msg_count This represents the count of error messages in the
1457: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1458: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1459: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1460: * value is returned, a validation or missing data error has occurred.
1461: * If the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1462: * has occurred and the calling program cannot correct the error.
1463: * @param x_msg_count This represents the count of error messages in the
1464: * message list.
1465: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1473: */
1474: PROCEDURE Update_Activity
1475: (
1476: p_api_version IN NUMBER,
1477: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1478: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1479: p_resp_appl_id IN NUMBER DEFAULT NULL,
1480: p_resp_id IN NUMBER DEFAULT NULL,
1481: p_user_id IN NUMBER,
1474: PROCEDURE Update_Activity
1475: (
1476: p_api_version IN NUMBER,
1477: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1478: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1479: p_resp_appl_id IN NUMBER DEFAULT NULL,
1480: p_resp_id IN NUMBER DEFAULT NULL,
1481: p_user_id IN NUMBER,
1482: p_login_id IN NUMBER DEFAULT NULL,
1498: --
1499: -- Standard IN Parameters:
1500: -- p_api_version IN NUMBER Required
1501: -- p_init_msg_list IN VARCHAR2(1) Optional
1502: -- Default = FND_API.G_FALSE
1503: --
1504: -- Standard OUT Parameters:
1505: -- x_return_status OUT VARCHAR2(1)
1506: -- x_msg_count OUT NUMBER
1544: * An unexpected error is returned if the calling program version number
1545: * is incompatible with the current API version number.
1546: * @param p_init_msg_list This flag is used to indicate if the message stack
1547: * should be initialized. The values that are valid for this parameter are:
1548: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1549: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1550: * to the fnd_msg_pub.initialize to initialize the message stack. When
1551: * set to 'False', it is the responsibility of the calling program to
1552: * initialize the message stack. It is only required that this action be
1545: * is incompatible with the current API version number.
1546: * @param p_init_msg_list This flag is used to indicate if the message stack
1547: * should be initialized. The values that are valid for this parameter are:
1548: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1549: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1550: * to the fnd_msg_pub.initialize to initialize the message stack. When
1551: * set to 'False', it is the responsibility of the calling program to
1552: * initialize the message stack. It is only required that this action be
1553: * performed once, even when more than one API is called.
1552: * initialize the message stack. It is only required that this action be
1553: * performed once, even when more than one API is called.
1554: * @param p_commit This flag is used to indicate if changes made to the
1555: * transaction should be committed on success. The values that are valid
1556: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1557: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1558: * before returning to the calling program. When set to 'False', it is the
1559: * responsibility of the calling program to commit the transaction.
1560: * @param p_resp_appl_id This represents the unique application identifier.
1553: * performed once, even when more than one API is called.
1554: * @param p_commit This flag is used to indicate if changes made to the
1555: * transaction should be committed on success. The values that are valid
1556: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1557: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1558: * before returning to the calling program. When set to 'False', it is the
1559: * responsibility of the calling program to commit the transaction.
1560: * @param p_resp_appl_id This represents the unique application identifier.
1561: * @param p_resp_id This is a unique identifier for the responsibility.
1564: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1565: * table and identifies the login session.
1566: * @param x_return_status This flag is used to indicate the return
1567: * status of the API. The values that are valid for this parameter are:
1568: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1569: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1570: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1571: * value is returned, a validation or missing data error has occurred. If
1572: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1565: * table and identifies the login session.
1566: * @param x_return_status This flag is used to indicate the return
1567: * status of the API. The values that are valid for this parameter are:
1568: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1569: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1570: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1571: * value is returned, a validation or missing data error has occurred. If
1572: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1573: * has occurred and the calling program cannot correct the error.
1566: * @param x_return_status This flag is used to indicate the return
1567: * status of the API. The values that are valid for this parameter are:
1568: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1569: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1570: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1571: * value is returned, a validation or missing data error has occurred. If
1572: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1573: * has occurred and the calling program cannot correct the error.
1574: * @param x_msg_count This represents the count of error messages in the
1568: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1569: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1570: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1571: * value is returned, a validation or missing data error has occurred. If
1572: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1573: * has occurred and the calling program cannot correct the error.
1574: * @param x_msg_count This represents the count of error messages in the
1575: * message list.
1576: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1581: */
1582: PROCEDURE Close_Interaction
1583: (
1584: p_api_version IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1587: p_resp_appl_id IN NUMBER DEFAULT NULL,
1588: p_resp_id IN NUMBER DEFAULT NULL,
1589: p_user_id IN NUMBER,
1582: PROCEDURE Close_Interaction
1583: (
1584: p_api_version IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1587: p_resp_appl_id IN NUMBER DEFAULT NULL,
1588: p_resp_id IN NUMBER DEFAULT NULL,
1589: p_user_id IN NUMBER,
1590: p_login_id IN NUMBER DEFAULT NULL,
1603: --
1604: -- Standard IN Parameters:
1605: -- p_api_version IN NUMBER Required
1606: -- p_init_msg_list IN VARCHAR2(1) Optional
1607: -- Default = FND_API.G_FALSE
1608: --
1609: -- Standard OUT Parameters:
1610: -- x_return_status OUT VARCHAR2(1)
1611: -- x_msg_count OUT NUMBER
1651: * An unexpected error is returned if the calling program version number
1652: * is incompatible with the current API version number.
1653: * @param p_init_msg_list This flag is used to indicate if the message stack
1654: * should be initialized. The values that are valid for this parameter are:
1655: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1656: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1657: * to the fnd_msg_pub.initialize to initialize the message stack. When
1658: * set to 'False', it is the responsibility of the calling program to
1659: * initialize the message stack. It is only required that this action be
1652: * is incompatible with the current API version number.
1653: * @param p_init_msg_list This flag is used to indicate if the message stack
1654: * should be initialized. The values that are valid for this parameter are:
1655: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1656: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1657: * to the fnd_msg_pub.initialize to initialize the message stack. When
1658: * set to 'False', it is the responsibility of the calling program to
1659: * initialize the message stack. It is only required that this action be
1660: * performed once, even when more than one API is called.
1659: * initialize the message stack. It is only required that this action be
1660: * performed once, even when more than one API is called.
1661: * @param p_commit This flag is used to indicate if changes made to the
1662: * transaction should be committed on success. The values that are valid
1663: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1664: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1665: * before returning to the calling program. When set to 'False', it is the
1666: * responsibility of the calling program to commit the transaction.
1667: * @param p_resp_appl_id This represents the unique application identifier.
1660: * performed once, even when more than one API is called.
1661: * @param p_commit This flag is used to indicate if changes made to the
1662: * transaction should be committed on success. The values that are valid
1663: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1664: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1665: * before returning to the calling program. When set to 'False', it is the
1666: * responsibility of the calling program to commit the transaction.
1667: * @param p_resp_appl_id This represents the unique application identifier.
1668: * @param p_resp_id This is a unique identifier for the responsibility.
1671: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1672: * table and identifies the login session.
1673: * @param x_return_status This flag is used to indicate the return
1674: * status of the API. The values that are valid for this parameter are:
1675: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1676: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1677: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1678: * value is returned, a validation or missing data error has occurred. If
1679: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1672: * table and identifies the login session.
1673: * @param x_return_status This flag is used to indicate the return
1674: * status of the API. The values that are valid for this parameter are:
1675: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1676: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1677: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1678: * value is returned, a validation or missing data error has occurred. If
1679: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1680: * has occurred and the calling program cannot correct the error.
1673: * @param x_return_status This flag is used to indicate the return
1674: * status of the API. The values that are valid for this parameter are:
1675: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1676: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1677: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1678: * value is returned, a validation or missing data error has occurred. If
1679: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1680: * has occurred and the calling program cannot correct the error.
1681: * @param x_msg_count This represents the count of error messages in the
1675: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1676: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1677: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1678: * value is returned, a validation or missing data error has occurred. If
1679: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1680: * has occurred and the calling program cannot correct the error.
1681: * @param x_msg_count This represents the count of error messages in the
1682: * message list.
1683: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1694: */
1695: PROCEDURE Update_ActivityDuration
1696: (
1697: p_api_version IN NUMBER,
1698: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1699: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1700: p_resp_appl_id IN NUMBER DEFAULT NULL,
1701: p_resp_id IN NUMBER DEFAULT NULL,
1702: p_user_id IN NUMBER,
1695: PROCEDURE Update_ActivityDuration
1696: (
1697: p_api_version IN NUMBER,
1698: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1699: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1700: p_resp_appl_id IN NUMBER DEFAULT NULL,
1701: p_resp_id IN NUMBER DEFAULT NULL,
1702: p_user_id IN NUMBER,
1703: p_login_id IN NUMBER DEFAULT NULL,
1727: --
1728: -- Standard IN Parameters:
1729: -- p_api_version IN NUMBER Required
1730: -- p_init_msg_list IN VARCHAR2(1) Optional
1731: -- Default = FND_API.G_FALSE
1732: -- p_commit IN VARCHAR2(1) Optional
1733: -- Default = FND_API.G_FALSE
1734: --
1735: -- Standard OUT Parameters:
1729: -- p_api_version IN NUMBER Required
1730: -- p_init_msg_list IN VARCHAR2(1) Optional
1731: -- Default = FND_API.G_FALSE
1732: -- p_commit IN VARCHAR2(1) Optional
1733: -- Default = FND_API.G_FALSE
1734: --
1735: -- Standard OUT Parameters:
1736: -- x_return_status OUT VARCHAR2(1)
1737: -- x_msg_count OUT NUMBER
1773: * An unexpected error is returned if the calling program version number
1774: * is incompatible with the current API version number.
1775: * @param p_init_msg_list This flag is used to indicate if the message stack
1776: * should be initialized. The values that are valid for this parameter are:
1777: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1778: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1779: * to the fnd_msg_pub.initialize to initialize the message stack. When
1780: * set to 'False', it is the responsibility of the calling program to
1781: * initialize the message stack. It is only required that this action be
1774: * is incompatible with the current API version number.
1775: * @param p_init_msg_list This flag is used to indicate if the message stack
1776: * should be initialized. The values that are valid for this parameter are:
1777: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1778: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1779: * to the fnd_msg_pub.initialize to initialize the message stack. When
1780: * set to 'False', it is the responsibility of the calling program to
1781: * initialize the message stack. It is only required that this action be
1782: * performed once, even when more than one API is called.
1781: * initialize the message stack. It is only required that this action be
1782: * performed once, even when more than one API is called.
1783: * @param p_commit This flag is used to indicate if changes made to the
1784: * transaction should be committed on success. The values that are valid
1785: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1786: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1787: * before returning to the calling program. When set to 'False', it is the
1788: * responsibility of the calling program to commit the transaction.
1789: * @param p_resp_appl_id This represents the unique application identifier.
1782: * performed once, even when more than one API is called.
1783: * @param p_commit This flag is used to indicate if changes made to the
1784: * transaction should be committed on success. The values that are valid
1785: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1786: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1787: * before returning to the calling program. When set to 'False', it is the
1788: * responsibility of the calling program to commit the transaction.
1789: * @param p_resp_appl_id This represents the unique application identifier.
1790: * @param p_resp_id This is a unique identifier for the responsibility.
1793: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1794: * table and identifies the login session.
1795: * @param x_return_status This flag is used to indicate the return status
1796: * of the API. The values that are valid for this parameter are:
1797: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1798: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS
1799: * value is returned, the API call was successful. If the
1800: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
1801: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value is
1794: * table and identifies the login session.
1795: * @param x_return_status This flag is used to indicate the return status
1796: * of the API. The values that are valid for this parameter are:
1797: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1798: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS
1799: * value is returned, the API call was successful. If the
1800: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
1801: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value is
1802: * returned, an unexpected error has occurred and the calling program
1796: * of the API. The values that are valid for this parameter are:
1797: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1798: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS
1799: * value is returned, the API call was successful. If the
1800: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
1801: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value is
1802: * returned, an unexpected error has occurred and the calling program
1803: * cannot correct the error.
1804: * @param x_msg_count This represents the count of error messages in the
1797: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1798: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS
1799: * value is returned, the API call was successful. If the
1800: * FND_API.G_RET_STS_ERROR value is returned, a validation or missing
1801: * data error has occurred. If the FND_API.G_RET_STS_UNEXP_ERROR value is
1802: * returned, an unexpected error has occurred and the calling program
1803: * cannot correct the error.
1804: * @param x_msg_count This represents the count of error messages in the
1805: * message list.
1814: */
1815: PROCEDURE Open_MediaItem
1816: (
1817: p_api_version IN NUMBER,
1818: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1819: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1820: p_resp_appl_id IN NUMBER DEFAULT NULL,
1821: p_resp_id IN NUMBER DEFAULT NULL,
1822: p_user_id IN NUMBER,
1815: PROCEDURE Open_MediaItem
1816: (
1817: p_api_version IN NUMBER,
1818: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1819: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1820: p_resp_appl_id IN NUMBER DEFAULT NULL,
1821: p_resp_id IN NUMBER DEFAULT NULL,
1822: p_user_id IN NUMBER,
1823: p_login_id IN NUMBER DEFAULT NULL,
1845: --
1846: -- Standard IN Parameters:
1847: -- p_api_version IN NUMBER Required
1848: -- p_init_msg_list IN VARCHAR2(1) Optional
1849: -- Default = FND_API.G_FALSE
1850: -- p_commit IN VARCHAR2(1) Optional
1851: -- Default = FND_API.G_FALSE
1852: --
1853: -- Standard OUT Parameters:
1847: -- p_api_version IN NUMBER Required
1848: -- p_init_msg_list IN VARCHAR2(1) Optional
1849: -- Default = FND_API.G_FALSE
1850: -- p_commit IN VARCHAR2(1) Optional
1851: -- Default = FND_API.G_FALSE
1852: --
1853: -- Standard OUT Parameters:
1854: -- x_return_status OUT VARCHAR2(1)
1855: -- x_msg_count OUT NUMBER
1891: * An unexpected error is returned if the calling program version number
1892: * is incompatible with the current API version number.
1893: * @param p_init_msg_list This flag is used to indicate if the message stack
1894: * should be initialized. The values that are valid for this parameter are:
1895: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1896: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1897: * to the fnd_msg_pub.initialize to initialize the message stack. When
1898: * set to 'False', it is the responsibility of the calling program to
1899: * initialize the message stack. It is only required that this action be
1892: * is incompatible with the current API version number.
1893: * @param p_init_msg_list This flag is used to indicate if the message stack
1894: * should be initialized. The values that are valid for this parameter are:
1895: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
1896: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
1897: * to the fnd_msg_pub.initialize to initialize the message stack. When
1898: * set to 'False', it is the responsibility of the calling program to
1899: * initialize the message stack. It is only required that this action be
1900: * performed once, even when more than one API is called.
1899: * initialize the message stack. It is only required that this action be
1900: * performed once, even when more than one API is called.
1901: * @param p_commit This flag is used to indicate if changes made to the
1902: * transaction should be committed on success. The values that are valid
1903: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1904: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1905: * before returning to the calling program. When set to 'False', it is the
1906: * responsibility of the calling program to commit the transaction.
1907: * @param p_resp_appl_id This represents the unique application identifier.
1900: * performed once, even when more than one API is called.
1901: * @param p_commit This flag is used to indicate if changes made to the
1902: * transaction should be committed on success. The values that are valid
1903: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
1904: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
1905: * before returning to the calling program. When set to 'False', it is the
1906: * responsibility of the calling program to commit the transaction.
1907: * @param p_resp_appl_id This represents the unique application identifier.
1908: * @param p_resp_id This is a unique identifier for the responsibility.
1911: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
1912: * table and identifies the login session.
1913: * @param x_return_status This flag is used to indicate the return
1914: * status of the API. The values that are valid for this parameter are:
1915: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1916: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1917: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1918: * value is returned, a validation or missing data error has occurred. If
1919: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1912: * table and identifies the login session.
1913: * @param x_return_status This flag is used to indicate the return
1914: * status of the API. The values that are valid for this parameter are:
1915: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1916: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1917: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1918: * value is returned, a validation or missing data error has occurred. If
1919: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1920: * has occurred and the calling program cannot correct the error.
1913: * @param x_return_status This flag is used to indicate the return
1914: * status of the API. The values that are valid for this parameter are:
1915: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1916: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1917: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1918: * value is returned, a validation or missing data error has occurred. If
1919: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1920: * has occurred and the calling program cannot correct the error.
1921: * @param x_msg_count This represents the count of error messages in the
1915: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
1916: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
1917: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
1918: * value is returned, a validation or missing data error has occurred. If
1919: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
1920: * has occurred and the calling program cannot correct the error.
1921: * @param x_msg_count This represents the count of error messages in the
1922: * message list.
1923: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
1930: */
1931: PROCEDURE Update_MediaItem
1932: (
1933: p_api_version IN NUMBER,
1934: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1935: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1936: p_resp_appl_id IN NUMBER DEFAULT NULL,
1937: p_resp_id IN NUMBER DEFAULT NULL,
1938: p_user_id IN NUMBER,
1931: PROCEDURE Update_MediaItem
1932: (
1933: p_api_version IN NUMBER,
1934: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1935: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1936: p_resp_appl_id IN NUMBER DEFAULT NULL,
1937: p_resp_id IN NUMBER DEFAULT NULL,
1938: p_user_id IN NUMBER,
1939: p_login_id IN NUMBER DEFAULT NULL,
1969: --
1970: -- Standard IN Parameters:
1971: -- p_api_version IN NUMBER Required
1972: -- p_init_msg_list IN VARCHAR2(1) Optional
1973: -- Default = FND_API.G_FALSE
1974: -- p_commit IN VARCHAR2(1) Optional
1975: -- Default = FND_API.G_FALSE
1976: --
1977: -- Standard OUT Parameters:
1971: -- p_api_version IN NUMBER Required
1972: -- p_init_msg_list IN VARCHAR2(1) Optional
1973: -- Default = FND_API.G_FALSE
1974: -- p_commit IN VARCHAR2(1) Optional
1975: -- Default = FND_API.G_FALSE
1976: --
1977: -- Standard OUT Parameters:
1978: -- x_return_status OUT VARCHAR2(1)
1979: -- x_msg_count OUT NUMBER
2014: * An unexpected error is returned if the calling program version number
2015: * is incompatible with the current API version number.
2016: * @param p_init_msg_list This flag is used to indicate if the message stack
2017: * should be initialized. The values that are valid for this parameter are:
2018: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2019: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2020: * to the fnd_msg_pub.initialize to initialize the message stack. When
2021: * set to 'False', it is the responsibility of the calling program to
2022: * initialize the message stack. It is only required that this action be
2015: * is incompatible with the current API version number.
2016: * @param p_init_msg_list This flag is used to indicate if the message stack
2017: * should be initialized. The values that are valid for this parameter are:
2018: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2019: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2020: * to the fnd_msg_pub.initialize to initialize the message stack. When
2021: * set to 'False', it is the responsibility of the calling program to
2022: * initialize the message stack. It is only required that this action be
2023: * performed once, even when more than one API is called.
2022: * initialize the message stack. It is only required that this action be
2023: * performed once, even when more than one API is called.
2024: * @param p_commit This flag is used to indicate if changes made to the
2025: * transaction should be committed on success. The values that are valid
2026: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2027: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2028: * before returning to the calling program. When set to 'False', it is the
2029: * responsibility of the calling program to commit the transaction.
2030: * @param p_resp_appl_id This represents the unique application identifier.
2023: * performed once, even when more than one API is called.
2024: * @param p_commit This flag is used to indicate if changes made to the
2025: * transaction should be committed on success. The values that are valid
2026: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2027: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2028: * before returning to the calling program. When set to 'False', it is the
2029: * responsibility of the calling program to commit the transaction.
2030: * @param p_resp_appl_id This represents the unique application identifier.
2031: * @param p_resp_id This is a unique identifier for the responsibility.
2034: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
2035: * table and identifies the login session.
2036: * @param x_return_status This flag is used to indicate the return
2037: * status of the API. The values that are valid for this parameter are:
2038: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2039: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2040: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2041: * value is returned, a validation or missing data error has occurred. If
2042: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2035: * table and identifies the login session.
2036: * @param x_return_status This flag is used to indicate the return
2037: * status of the API. The values that are valid for this parameter are:
2038: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2039: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2040: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2041: * value is returned, a validation or missing data error has occurred. If
2042: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2043: * has occurred and the calling program cannot correct the error.
2036: * @param x_return_status This flag is used to indicate the return
2037: * status of the API. The values that are valid for this parameter are:
2038: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2039: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2040: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2041: * value is returned, a validation or missing data error has occurred. If
2042: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2043: * has occurred and the calling program cannot correct the error.
2044: * @param x_msg_count This represents the count of error messages in the
2038: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2039: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2040: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2041: * value is returned, a validation or missing data error has occurred. If
2042: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2043: * has occurred and the calling program cannot correct the error.
2044: * @param x_msg_count This represents the count of error messages in the
2045: * message list.
2046: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
2053: */
2054: PROCEDURE Close_MediaItem
2055: (
2056: p_api_version IN NUMBER,
2057: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2058: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2059: p_resp_appl_id IN NUMBER DEFAULT NULL,
2060: p_resp_id IN NUMBER DEFAULT NULL,
2061: p_user_id IN NUMBER,
2054: PROCEDURE Close_MediaItem
2055: (
2056: p_api_version IN NUMBER,
2057: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2058: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2059: p_resp_appl_id IN NUMBER DEFAULT NULL,
2060: p_resp_id IN NUMBER DEFAULT NULL,
2061: p_user_id IN NUMBER,
2062: p_login_id IN NUMBER DEFAULT NULL,
2083: --
2084: -- Standard IN Parameters:
2085: -- p_api_version IN NUMBER Required
2086: -- p_init_msg_list IN VARCHAR2(1) Optional
2087: -- Default = FND_API.G_FALSE
2088: -- p_commit IN VARCHAR2(1) Optional
2089: -- Default = FND_API.G_FALSE
2090: --
2091: -- Standard OUT Parameters:
2085: -- p_api_version IN NUMBER Required
2086: -- p_init_msg_list IN VARCHAR2(1) Optional
2087: -- Default = FND_API.G_FALSE
2088: -- p_commit IN VARCHAR2(1) Optional
2089: -- Default = FND_API.G_FALSE
2090: --
2091: -- Standard OUT Parameters:
2092: -- x_return_status OUT VARCHAR2(1)
2093: -- x_msg_count OUT NUMBER
2133: * An unexpected error is returned if the calling program version number
2134: * is incompatible with the current API version number.
2135: * @param p_init_msg_list This flag is used to indicate if the message stack
2136: * should be initialized. The values that are valid for this parameter are:
2137: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2138: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2139: * to the fnd_msg_pub.initialize to initialize the message stack. When
2140: * set to 'False', it is the responsibility of the calling program to
2141: * initialize the message stack. It is only required that this action be
2134: * is incompatible with the current API version number.
2135: * @param p_init_msg_list This flag is used to indicate if the message stack
2136: * should be initialized. The values that are valid for this parameter are:
2137: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2138: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2139: * to the fnd_msg_pub.initialize to initialize the message stack. When
2140: * set to 'False', it is the responsibility of the calling program to
2141: * initialize the message stack. It is only required that this action be
2142: * performed once, even when more than one API is called.
2141: * initialize the message stack. It is only required that this action be
2142: * performed once, even when more than one API is called.
2143: * @param p_commit This flag is used to indicate if changes made to the
2144: * transaction should be committed on success. The values that are valid
2145: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2146: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2147: * before returning to the calling program. When set to 'False', it is the
2148: * responsibility of the calling program to commit the transaction.
2149: * @param p_resp_appl_id This represents the unique application identifier.
2142: * performed once, even when more than one API is called.
2143: * @param p_commit This flag is used to indicate if changes made to the
2144: * transaction should be committed on success. The values that are valid
2145: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2146: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2147: * before returning to the calling program. When set to 'False', it is the
2148: * responsibility of the calling program to commit the transaction.
2149: * @param p_resp_appl_id This represents the unique application identifier.
2150: * @param p_resp_id This is a unique identifier for the responsibility.
2153: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
2154: * table and identifies the login session.
2155: * @param x_return_status This flag is used to indicate the return
2156: * status of the API. The values that are valid for this parameter are:
2157: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2158: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2159: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2160: * value is returned, a validation or missing data error has occurred. If
2161: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2154: * table and identifies the login session.
2155: * @param x_return_status This flag is used to indicate the return
2156: * status of the API. The values that are valid for this parameter are:
2157: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2158: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2159: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2160: * value is returned, a validation or missing data error has occurred. If
2161: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2162: * has occurred and the calling program cannot correct the error.
2155: * @param x_return_status This flag is used to indicate the return
2156: * status of the API. The values that are valid for this parameter are:
2157: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2158: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2159: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2160: * value is returned, a validation or missing data error has occurred. If
2161: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2162: * has occurred and the calling program cannot correct the error.
2163: * @param x_msg_count This represents the count of error messages in the
2157: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2158: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2159: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2160: * value is returned, a validation or missing data error has occurred. If
2161: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2162: * has occurred and the calling program cannot correct the error.
2163: * @param x_msg_count This represents the count of error messages in the
2164: * message list.
2165: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
2173: */
2174: PROCEDURE Add_MediaLifecycle
2175: (
2176: p_api_version IN NUMBER,
2177: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2179: p_resp_appl_id IN NUMBER DEFAULT NULL,
2180: p_resp_id IN NUMBER DEFAULT NULL,
2181: p_user_id IN NUMBER,
2174: PROCEDURE Add_MediaLifecycle
2175: (
2176: p_api_version IN NUMBER,
2177: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2179: p_resp_appl_id IN NUMBER DEFAULT NULL,
2180: p_resp_id IN NUMBER DEFAULT NULL,
2181: p_user_id IN NUMBER,
2182: p_login_id IN NUMBER DEFAULT NULL,
2202: --
2203: -- Standard IN Parameters:
2204: -- p_api_version IN NUMBER Required
2205: -- p_init_msg_list IN VARCHAR2(1) Optional
2206: -- Default = FND_API.G_FALSE
2207: -- p_commit IN VARCHAR2(1) Optional
2208: -- Default = FND_API.G_FALSE
2209: --
2210: -- Standard OUT Parameters:
2204: -- p_api_version IN NUMBER Required
2205: -- p_init_msg_list IN VARCHAR2(1) Optional
2206: -- Default = FND_API.G_FALSE
2207: -- p_commit IN VARCHAR2(1) Optional
2208: -- Default = FND_API.G_FALSE
2209: --
2210: -- Standard OUT Parameters:
2211: -- x_return_status OUT VARCHAR2(1)
2212: -- x_msg_count OUT NUMBER
2249: * An unexpected error is returned if the calling program version number
2250: * is incompatible with the current API version number.
2251: * @param p_init_msg_list This flag is used to indicate if the message stack
2252: * should be initialized. The values that are valid for this parameter are:
2253: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2254: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2255: * to the fnd_msg_pub.initialize to initialize the message stack. When
2256: * set to 'False', it is the responsibility of the calling program to
2257: * initialize the message stack. It is only required that this action be
2250: * is incompatible with the current API version number.
2251: * @param p_init_msg_list This flag is used to indicate if the message stack
2252: * should be initialized. The values that are valid for this parameter are:
2253: * True = FND_API.G_TRUE, False = FND_API.G_FALSE, and
2254: * Default = FND_API.G_FALSE. When set to 'True',the API makes a call
2255: * to the fnd_msg_pub.initialize to initialize the message stack. When
2256: * set to 'False', it is the responsibility of the calling program to
2257: * initialize the message stack. It is only required that this action be
2258: * performed once, even when more than one API is called.
2257: * initialize the message stack. It is only required that this action be
2258: * performed once, even when more than one API is called.
2259: * @param p_commit This flag is used to indicate if changes made to the
2260: * transaction should be committed on success. The values that are valid
2261: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2262: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2263: * before returning to the calling program. When set to 'False', it is the
2264: * responsibility of the calling program to commit the transaction.
2265: * @param p_resp_appl_id This represents the unique application identifier.
2258: * performed once, even when more than one API is called.
2259: * @param p_commit This flag is used to indicate if changes made to the
2260: * transaction should be committed on success. The values that are valid
2261: * for this parameter are: True = FND_API.G_TRUE, False = FND_API.G_FALSE,
2262: * and Default = FND_API.G_FALSE. When set to 'True', the API commits
2263: * before returning to the calling program. When set to 'False', it is the
2264: * responsibility of the calling program to commit the transaction.
2265: * @param p_resp_appl_id This represents the unique application identifier.
2266: * @param p_resp_id This is a unique identifier for the responsibility.
2269: * @param p_login_id Corresponds to the LOGIN_ID column in the FND_LOGINS
2270: * table and identifies the login session.
2271: * @param x_return_status This flag is used to indicate the return
2272: * status of the API. The values that are valid for this parameter are:
2273: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2274: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2275: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2276: * value is returned, a validation or missing data error has occurred. If
2277: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2270: * table and identifies the login session.
2271: * @param x_return_status This flag is used to indicate the return
2272: * status of the API. The values that are valid for this parameter are:
2273: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2274: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2275: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2276: * value is returned, a validation or missing data error has occurred. If
2277: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2278: * has occurred and the calling program cannot correct the error.
2271: * @param x_return_status This flag is used to indicate the return
2272: * status of the API. The values that are valid for this parameter are:
2273: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2274: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2275: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2276: * value is returned, a validation or missing data error has occurred. If
2277: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2278: * has occurred and the calling program cannot correct the error.
2279: * @param x_msg_count This represents the count of error messages in the
2273: * FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and
2274: * FND_API.G_RET_STS_UNEXP_ERROR. If the FND_API.G_RET_STS_SUCCESS value
2275: * is returned, the API call was successful. If the FND_API.G_RET_STS_ERROR
2276: * value is returned, a validation or missing data error has occurred. If
2277: * the FND_API.G_RET_STS_UNEXP_ERROR value is returned, an unexpected error
2278: * has occurred and the calling program cannot correct the error.
2279: * @param x_msg_count This represents the count of error messages in the
2280: * message list.
2281: * @param x_msg_data Holds the encoded message if x_msg_count is equal to one.
2288: */
2289: PROCEDURE Update_MediaLifecycle
2290: (
2291: p_api_version IN NUMBER,
2292: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2293: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2294: p_resp_appl_id IN NUMBER DEFAULT NULL,
2295: p_resp_id IN NUMBER DEFAULT NULL,
2296: p_user_id IN NUMBER,
2289: PROCEDURE Update_MediaLifecycle
2290: (
2291: p_api_version IN NUMBER,
2292: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2293: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2294: p_resp_appl_id IN NUMBER DEFAULT NULL,
2295: p_resp_id IN NUMBER DEFAULT NULL,
2296: p_user_id IN NUMBER,
2297: p_login_id IN NUMBER DEFAULT NULL,