9: --
10: -- Standard IN Parameters:
11: -- p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2(1) Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2(1) Optional
15: -- Default = FND_API.G_FALSE
16: --
17: -- Standard OUT Parameters:
11: -- p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2(1) Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2(1) Optional
15: -- Default = FND_API.G_FALSE
16: --
17: -- Standard OUT Parameters:
18: -- x_return_status OUT VARCHAR2(1)
19: -- x_msg_count OUT NUMBER
119: -- End of comments
120:
121: TYPE interaction_rec_type IS RECORD
122: (
123: interaction_id NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
120:
121: TYPE interaction_rec_type IS RECORD
122: (
123: interaction_id NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
121: TYPE interaction_rec_type IS RECORD
122: (
123: interaction_id NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
122: (
123: interaction_id NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
123: interaction_id NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
124: reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
125: follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
126: duration NUMBER := fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
127: end_date_time DATE :=fnd_api.g_miss_date,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
128: inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
129: non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
130: preview_time_amount NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
131: productive_time_amount NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
132: start_date_time DATE :=fnd_api.g_miss_date,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
133: wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
134: handler_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
135: script_id NUMBER :=fnd_api.g_miss_num,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
136: outcome_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
137: result_id NUMBER :=fnd_api.g_miss_num,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
138: reason_id NUMBER :=fnd_api.g_miss_num,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
139: resource_id NUMBER :=fnd_api.g_miss_num,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
140: party_id NUMBER :=fnd_api.g_miss_num,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
141: parent_id NUMBER :=fnd_api.g_miss_num,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
142: object_id NUMBER :=fnd_api.g_miss_num,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
143: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
144: source_code_id NUMBER :=fnd_api.g_miss_num,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
145: source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
146: attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
147: attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
148: attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
149: attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
150: attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
151: attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
152: attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
153: attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
154: attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
162: );
155: attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
162: );
163:
156: attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
162: );
163:
164: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
157: attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158: attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159: attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160: attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161: attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
162: );
163:
164: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
165:
164: FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
165:
166: TYPE activity_rec_type IS RECORD
167: (
168: activity_id NUMBER := fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
165:
166: TYPE activity_rec_type IS RECORD
167: (
168: activity_id NUMBER := fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
166: TYPE activity_rec_type IS RECORD
167: (
168: activity_id NUMBER := fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
167: (
168: activity_id NUMBER := fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
168: activity_id NUMBER := fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
169: duration NUMBER :=fnd_api.g_miss_num,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
170: cust_account_id NUMBER := fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
171: cust_org_id NUMBER := fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
172: role VARCHAR2(240) := fnd_api.g_miss_char,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
173: end_date_time DATE :=fnd_api.g_miss_date,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
174: start_date_time DATE :=fnd_api.g_miss_date,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
175: task_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
176: doc_id NUMBER :=fnd_api.g_miss_num,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
177: doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
178: media_id NUMBER :=fnd_api.g_miss_num,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
179: action_item_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
180: interaction_id NUMBER :=fnd_api.g_miss_num,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
181: outcome_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
182: result_id NUMBER :=fnd_api.g_miss_num,
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
190: source_code VARCHAR2(30) :=fnd_api.g_miss_char
183: reason_id NUMBER :=fnd_api.g_miss_num,
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
190: source_code VARCHAR2(30) :=fnd_api.g_miss_char
191: );
184: description VARCHAR2(1000) :=fnd_api.g_miss_char,
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
190: source_code VARCHAR2(30) :=fnd_api.g_miss_char
191: );
192: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
185: action_id NUMBER :=fnd_api.g_miss_num,
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
190: source_code VARCHAR2(30) :=fnd_api.g_miss_char
191: );
192: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
193:
186: interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187: object_id NUMBER :=fnd_api.g_miss_num,
188: object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189: source_code_id NUMBER :=fnd_api.g_miss_num,
190: source_code VARCHAR2(30) :=fnd_api.g_miss_char
191: );
192: TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
193:
194: FUNCTION INIT_ACTIVITY_REC RETURN activity_rec_type;
195:
196: PROCEDURE Create_Interaction
197: (
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_resp_appl_id IN NUMBER DEFAULT NULL,
202: p_resp_id IN NUMBER DEFAULT NULL,
203: p_user_id IN NUMBER,
196: PROCEDURE Create_Interaction
197: (
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_resp_appl_id IN NUMBER DEFAULT NULL,
202: p_resp_id IN NUMBER DEFAULT NULL,
203: p_user_id IN NUMBER,
204: p_login_id IN NUMBER DEFAULT NULL,
218: --
219: -- Standard IN Parameters:
220: -- p_api_version IN NUMBER Required
221: -- p_init_msg_list IN VARCHAR2(1) Optional
222: -- Default = FND_API.G_FALSE
223: -- p_commit IN VARCHAR2(1) Optional
224: -- Default = FND_API.G_FALSE
225: --
226: -- Standard OUT Parameters:
220: -- p_api_version IN NUMBER Required
221: -- p_init_msg_list IN VARCHAR2(1) Optional
222: -- Default = FND_API.G_FALSE
223: -- p_commit IN VARCHAR2(1) Optional
224: -- Default = FND_API.G_FALSE
225: --
226: -- Standard OUT Parameters:
227: -- x_return_status OUT VARCHAR2(1)
228: -- x_msg_count OUT NUMBER
270: --
271: -- End of comments
272: TYPE media_rec_type IS RECORD
273: (
274: media_id NUMBER :=fnd_api.g_miss_num,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
271: -- End of comments
272: TYPE media_rec_type IS RECORD
273: (
274: media_id NUMBER :=fnd_api.g_miss_num,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
272: TYPE media_rec_type IS RECORD
273: (
274: media_id NUMBER :=fnd_api.g_miss_num,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
273: (
274: media_id NUMBER :=fnd_api.g_miss_num,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
274: media_id NUMBER :=fnd_api.g_miss_num,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
275: source_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
276: direction VARCHAR2(240) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
277: duration NUMBER :=fnd_api.g_miss_num,
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
278: end_date_time DATE :=fnd_api.g_miss_date,
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286: );
279: interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286: );
287: TYPE media_lc_rec_type IS RECORD
280: start_date_time DATE :=fnd_api.g_miss_date,
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286: );
287: TYPE media_lc_rec_type IS RECORD
288: (
281: media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282: source_item_create_date_time DATE :=fnd_api.g_miss_date,
283: source_item_id NUMBER :=fnd_api.g_miss_num,
284: media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286: );
287: TYPE media_lc_rec_type IS RECORD
288: (
289: start_date_time DATE :=fnd_api.g_miss_date,
285: media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286: );
287: TYPE media_lc_rec_type IS RECORD
288: (
289: start_date_time DATE :=fnd_api.g_miss_date,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
286: );
287: TYPE media_lc_rec_type IS RECORD
288: (
289: start_date_time DATE :=fnd_api.g_miss_date,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
287: TYPE media_lc_rec_type IS RECORD
288: (
289: start_date_time DATE :=fnd_api.g_miss_date,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
288: (
289: start_date_time DATE :=fnd_api.g_miss_date,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
289: start_date_time DATE :=fnd_api.g_miss_date,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
290: type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
298: resource_id NUMBER :=fnd_api.g_miss_num
291: type_id NUMBER :=fnd_api.g_miss_num,
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
298: resource_id NUMBER :=fnd_api.g_miss_num
299: );
292: duration NUMBER :=fnd_api.g_miss_num,
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
298: resource_id NUMBER :=fnd_api.g_miss_num
299: );
300:
293: end_date_time DATE :=fnd_api.g_miss_date,
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
298: resource_id NUMBER :=fnd_api.g_miss_num
299: );
300:
301: TYPE mlcs_tbl_type IS TABLE OF media_lc_rec_type INDEX BY BINARY_INTEGER;
294: milcs_id NUMBER :=fnd_api.g_miss_num,
295: milcs_type_id NUMBER :=fnd_api.g_miss_num,
296: media_id NUMBER :=fnd_api.g_miss_num,
297: handler_id NUMBER :=fnd_api.g_miss_num,
298: resource_id NUMBER :=fnd_api.g_miss_num
299: );
300:
301: TYPE mlcs_tbl_type IS TABLE OF media_lc_rec_type INDEX BY BINARY_INTEGER;
302:
302:
303: PROCEDURE Create_MediaItem
304: (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
308: p_resp_appl_id IN NUMBER DEFAULT NULL,
309: p_resp_id IN NUMBER DEFAULT NULL,
310: p_user_id IN NUMBER,
303: PROCEDURE Create_MediaItem
304: (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
308: p_resp_appl_id IN NUMBER DEFAULT NULL,
309: p_resp_id IN NUMBER DEFAULT NULL,
310: p_user_id IN NUMBER,
311: p_login_id IN NUMBER DEFAULT NULL,
318:
319: PROCEDURE Create_MediaItem
320: (
321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
323: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
324: p_resp_appl_id IN NUMBER DEFAULT NULL,
325: p_resp_id IN NUMBER DEFAULT NULL,
326: p_user_id IN NUMBER,
319: PROCEDURE Create_MediaItem
320: (
321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
323: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
324: p_resp_appl_id IN NUMBER DEFAULT NULL,
325: p_resp_id IN NUMBER DEFAULT NULL,
326: p_user_id IN NUMBER,
327: p_login_id IN NUMBER DEFAULT NULL,
341: --
342: -- Standard IN Parameters:
343: -- p_api_version IN NUMBER Required
344: -- p_init_msg_list IN VARCHAR2(1) Optional
345: -- Default = FND_API.G_FALSE
346: -- p_commit IN VARCHAR2(1) Optional
347: -- Default = FND_API.G_FALSE
348: --
349: -- Standard OUT Parameters:
343: -- p_api_version IN NUMBER Required
344: -- p_init_msg_list IN VARCHAR2(1) Optional
345: -- Default = FND_API.G_FALSE
346: -- p_commit IN VARCHAR2(1) Optional
347: -- Default = FND_API.G_FALSE
348: --
349: -- Standard OUT Parameters:
350: -- x_return_status OUT VARCHAR2(1)
351: -- x_msg_count OUT NUMBER
394:
395: PROCEDURE Create_MediaLifecycle
396: (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
399: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
400: p_resp_appl_id IN NUMBER DEFAULT NULL,
401: p_resp_id IN NUMBER DEFAULT NULL,
402: p_user_id IN NUMBER,
395: PROCEDURE Create_MediaLifecycle
396: (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
399: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
400: p_resp_appl_id IN NUMBER DEFAULT NULL,
401: p_resp_id IN NUMBER DEFAULT NULL,
402: p_user_id IN NUMBER,
403: p_login_id IN NUMBER DEFAULT NULL,
415: --
416: -- Standard IN Parameters:
417: -- p_api_version IN NUMBER Required
418: -- p_init_msg_list IN VARCHAR2(1) Optional
419: -- Default = FND_API.G_FALSE
420: --
421: -- Standard OUT Parameters:
422: -- x_return_status OUT VARCHAR2(1)
423: -- x_msg_count OUT NUMBER
460:
461: PROCEDURE Get_InteractionActivityCount
462: (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
465: p_resp_appl_id IN NUMBER DEFAULT NULL,
466: p_resp_id IN NUMBER DEFAULT NULL,
467: p_user_id IN NUMBER,
468: p_login_id IN NUMBER DEFAULT NULL,
485: --
486: -- Standard IN Parameters:
487: -- p_api_version IN NUMBER Required
488: -- p_init_msg_list IN VARCHAR2(1) Optional
489: -- Default = FND_API.G_FALSE
490: --
491: -- Standard OUT Parameters:
492: -- x_return_status OUT VARCHAR2(1)
493: -- x_msg_count OUT NUMBER
547:
548: PROCEDURE Get_InteractionCount
549: (
550: p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
552: p_resp_appl_id IN NUMBER DEFAULT NULL,
553: p_resp_id IN NUMBER DEFAULT NULL,
554: p_user_id IN NUMBER,
555: p_login_id IN NUMBER DEFAULT NULL,
587: --
588: -- Standard IN Parameters:
589: -- p_api_version IN NUMBER Required
590: -- p_init_msg_list IN VARCHAR2(1) Optional
591: -- Default = FND_API.G_FALSE
592: --
593: -- Standard OUT Parameters:
594: -- x_return_status OUT VARCHAR2(1)
595: -- x_msg_count OUT NUMBER
631:
632: PROCEDURE Open_Interaction
633: (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
636: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
637: p_resp_appl_id IN NUMBER DEFAULT NULL,
638: p_resp_id IN NUMBER DEFAULT NULL,
639: p_user_id IN NUMBER,
632: PROCEDURE Open_Interaction
633: (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
636: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
637: p_resp_appl_id IN NUMBER DEFAULT NULL,
638: p_resp_id IN NUMBER DEFAULT NULL,
639: p_user_id IN NUMBER,
640: p_login_id IN NUMBER DEFAULT NULL,
654: --
655: -- Standard IN Parameters:
656: -- p_api_version IN NUMBER Required
657: -- p_init_msg_list IN VARCHAR2(1) Optional
658: -- Default = FND_API.G_FALSE
659: --
660: -- Standard OUT Parameters:
661: -- x_return_status OUT VARCHAR2(1)
662: -- x_msg_count OUT NUMBER
695:
696: PROCEDURE Update_Interaction
697: (
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
701: p_resp_appl_id IN NUMBER DEFAULT NULL,
702: p_resp_id IN NUMBER DEFAULT NULL,
703: p_user_id IN NUMBER,
696: PROCEDURE Update_Interaction
697: (
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
701: p_resp_appl_id IN NUMBER DEFAULT NULL,
702: p_resp_id IN NUMBER DEFAULT NULL,
703: p_user_id IN NUMBER,
704: p_login_id IN NUMBER DEFAULT NULL,
717: --
718: -- Standard IN Parameters:
719: -- p_api_version IN NUMBER Required
720: -- p_init_msg_list IN VARCHAR2(1) Optional
721: -- Default = FND_API.G_FALSE
722: --
723: -- Standard OUT Parameters:
724: -- x_return_status OUT VARCHAR2(1)
725: -- x_msg_count OUT NUMBER
758:
759: PROCEDURE Close_Interaction
760: (
761: p_api_version IN NUMBER,
762: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
764: p_resp_appl_id IN NUMBER DEFAULT NULL,
765: p_resp_id IN NUMBER DEFAULT NULL,
766: p_user_id IN NUMBER,
759: PROCEDURE Close_Interaction
760: (
761: p_api_version IN NUMBER,
762: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
764: p_resp_appl_id IN NUMBER DEFAULT NULL,
765: p_resp_id IN NUMBER DEFAULT NULL,
766: p_user_id IN NUMBER,
767: p_login_id IN NUMBER DEFAULT NULL,
780: --
781: -- Standard IN Parameters:
782: -- p_api_version IN NUMBER Required
783: -- p_init_msg_list IN VARCHAR2(1) Optional
784: -- Default = FND_API.G_FALSE
785: --
786: -- Standard OUT Parameters:
787: -- x_return_status OUT VARCHAR2(1)
788: -- x_msg_count OUT NUMBER
824:
825: PROCEDURE Add_Activity
826: (
827: p_api_version IN NUMBER,
828: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
829: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
830: p_resp_appl_id IN NUMBER DEFAULT NULL,
831: p_resp_id IN NUMBER DEFAULT NULL,
832: p_user_id IN NUMBER,
825: PROCEDURE Add_Activity
826: (
827: p_api_version IN NUMBER,
828: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
829: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
830: p_resp_appl_id IN NUMBER DEFAULT NULL,
831: p_resp_id IN NUMBER DEFAULT NULL,
832: p_user_id IN NUMBER,
833: p_login_id IN NUMBER DEFAULT NULL,
847: --
848: -- Standard IN Parameters:
849: -- p_api_version IN NUMBER Required
850: -- p_init_msg_list IN VARCHAR2(1) Optional
851: -- Default = FND_API.G_FALSE
852: --
853: -- Standard OUT Parameters:
854: -- x_return_status OUT VARCHAR2(1)
855: -- x_msg_count OUT NUMBER
888:
889: PROCEDURE Update_Activity
890: (
891: p_api_version IN NUMBER,
892: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
893: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
894: p_resp_appl_id IN NUMBER DEFAULT NULL,
895: p_resp_id IN NUMBER DEFAULT NULL,
896: p_user_id IN NUMBER,
889: PROCEDURE Update_Activity
890: (
891: p_api_version IN NUMBER,
892: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
893: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
894: p_resp_appl_id IN NUMBER DEFAULT NULL,
895: p_resp_id IN NUMBER DEFAULT NULL,
896: p_user_id IN NUMBER,
897: p_login_id IN NUMBER DEFAULT NULL,
910: --
911: -- Standard IN Parameters:
912: -- p_api_version IN NUMBER Required
913: -- p_init_msg_list IN VARCHAR2(1) Optional
914: -- Default = FND_API.G_FALSE
915: --
916: -- Standard OUT Parameters:
917: -- x_return_status OUT VARCHAR2(1)
918: -- x_msg_count OUT NUMBER
951:
952: PROCEDURE Close_Interaction
953: (
954: p_api_version IN NUMBER,
955: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
956: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
957: p_resp_appl_id IN NUMBER DEFAULT NULL,
958: p_resp_id IN NUMBER DEFAULT NULL,
959: p_user_id IN NUMBER,
952: PROCEDURE Close_Interaction
953: (
954: p_api_version IN NUMBER,
955: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
956: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
957: p_resp_appl_id IN NUMBER DEFAULT NULL,
958: p_resp_id IN NUMBER DEFAULT NULL,
959: p_user_id IN NUMBER,
960: p_login_id IN NUMBER DEFAULT NULL,
973: --
974: -- Standard IN Parameters:
975: -- p_api_version IN NUMBER Required
976: -- p_init_msg_list IN VARCHAR2(1) Optional
977: -- Default = FND_API.G_FALSE
978: --
979: -- Standard OUT Parameters:
980: -- x_return_status OUT VARCHAR2(1)
981: -- x_msg_count OUT NUMBER
1015:
1016: PROCEDURE Update_ActivityDuration
1017: (
1018: p_api_version IN NUMBER,
1019: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1020: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1021: p_resp_appl_id IN NUMBER DEFAULT NULL,
1022: p_resp_id IN NUMBER DEFAULT NULL,
1023: p_user_id IN NUMBER,
1016: PROCEDURE Update_ActivityDuration
1017: (
1018: p_api_version IN NUMBER,
1019: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1020: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1021: p_resp_appl_id IN NUMBER DEFAULT NULL,
1022: p_resp_id IN NUMBER DEFAULT NULL,
1023: p_user_id IN NUMBER,
1024: p_login_id IN NUMBER DEFAULT NULL,
1045: --
1046: -- Standard IN Parameters:
1047: -- p_api_version IN NUMBER Required
1048: -- p_init_msg_list IN VARCHAR2(1) Optional
1049: -- Default = FND_API.G_FALSE
1050: -- p_commit IN VARCHAR2(1) Optional
1051: -- Default = FND_API.G_FALSE
1052: --
1053: -- Standard OUT Parameters:
1047: -- p_api_version IN NUMBER Required
1048: -- p_init_msg_list IN VARCHAR2(1) Optional
1049: -- Default = FND_API.G_FALSE
1050: -- p_commit IN VARCHAR2(1) Optional
1051: -- Default = FND_API.G_FALSE
1052: --
1053: -- Standard OUT Parameters:
1054: -- x_return_status OUT VARCHAR2(1)
1055: -- x_msg_count OUT NUMBER
1087:
1088: PROCEDURE Open_MediaItem
1089: (
1090: p_api_version IN NUMBER,
1091: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1092: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1093: p_resp_appl_id IN NUMBER DEFAULT NULL,
1094: p_resp_id IN NUMBER DEFAULT NULL,
1095: p_user_id IN NUMBER,
1088: PROCEDURE Open_MediaItem
1089: (
1090: p_api_version IN NUMBER,
1091: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1092: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1093: p_resp_appl_id IN NUMBER DEFAULT NULL,
1094: p_resp_id IN NUMBER DEFAULT NULL,
1095: p_user_id IN NUMBER,
1096: p_login_id IN NUMBER DEFAULT NULL,
1118: --
1119: -- Standard IN Parameters:
1120: -- p_api_version IN NUMBER Required
1121: -- p_init_msg_list IN VARCHAR2(1) Optional
1122: -- Default = FND_API.G_FALSE
1123: -- p_commit IN VARCHAR2(1) Optional
1124: -- Default = FND_API.G_FALSE
1125: --
1126: -- Standard OUT Parameters:
1120: -- p_api_version IN NUMBER Required
1121: -- p_init_msg_list IN VARCHAR2(1) Optional
1122: -- Default = FND_API.G_FALSE
1123: -- p_commit IN VARCHAR2(1) Optional
1124: -- Default = FND_API.G_FALSE
1125: --
1126: -- Standard OUT Parameters:
1127: -- x_return_status OUT VARCHAR2(1)
1128: -- x_msg_count OUT NUMBER
1158:
1159: PROCEDURE Update_MediaItem
1160: (
1161: p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1164: p_resp_appl_id IN NUMBER DEFAULT NULL,
1165: p_resp_id IN NUMBER DEFAULT NULL,
1166: p_user_id IN NUMBER,
1159: PROCEDURE Update_MediaItem
1160: (
1161: p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1163: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1164: p_resp_appl_id IN NUMBER DEFAULT NULL,
1165: p_resp_id IN NUMBER DEFAULT NULL,
1166: p_user_id IN NUMBER,
1167: p_login_id IN NUMBER DEFAULT NULL,
1194: --
1195: -- Standard IN Parameters:
1196: -- p_api_version IN NUMBER Required
1197: -- p_init_msg_list IN VARCHAR2(1) Optional
1198: -- Default = FND_API.G_FALSE
1199: -- p_commit IN VARCHAR2(1) Optional
1200: -- Default = FND_API.G_FALSE
1201: --
1202: -- Standard OUT Parameters:
1196: -- p_api_version IN NUMBER Required
1197: -- p_init_msg_list IN VARCHAR2(1) Optional
1198: -- Default = FND_API.G_FALSE
1199: -- p_commit IN VARCHAR2(1) Optional
1200: -- Default = FND_API.G_FALSE
1201: --
1202: -- Standard OUT Parameters:
1203: -- x_return_status OUT VARCHAR2(1)
1204: -- x_msg_count OUT NUMBER
1234:
1235: PROCEDURE Close_MediaItem
1236: (
1237: p_api_version IN NUMBER,
1238: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1239: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1240: p_resp_appl_id IN NUMBER DEFAULT NULL,
1241: p_resp_id IN NUMBER DEFAULT NULL,
1242: p_user_id IN NUMBER,
1235: PROCEDURE Close_MediaItem
1236: (
1237: p_api_version IN NUMBER,
1238: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1239: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1240: p_resp_appl_id IN NUMBER DEFAULT NULL,
1241: p_resp_id IN NUMBER DEFAULT NULL,
1242: p_user_id IN NUMBER,
1243: p_login_id IN NUMBER DEFAULT NULL,
1263: --
1264: -- Standard IN Parameters:
1265: -- p_api_version IN NUMBER Required
1266: -- p_init_msg_list IN VARCHAR2(1) Optional
1267: -- Default = FND_API.G_FALSE
1268: -- p_commit IN VARCHAR2(1) Optional
1269: -- Default = FND_API.G_FALSE
1270: --
1271: -- Standard OUT Parameters:
1265: -- p_api_version IN NUMBER Required
1266: -- p_init_msg_list IN VARCHAR2(1) Optional
1267: -- Default = FND_API.G_FALSE
1268: -- p_commit IN VARCHAR2(1) Optional
1269: -- Default = FND_API.G_FALSE
1270: --
1271: -- Standard OUT Parameters:
1272: -- x_return_status OUT VARCHAR2(1)
1273: -- x_msg_count OUT NUMBER
1307:
1308: PROCEDURE Add_MediaLifecycle
1309: (
1310: p_api_version IN NUMBER,
1311: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1312: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1313: p_resp_appl_id IN NUMBER DEFAULT NULL,
1314: p_resp_id IN NUMBER DEFAULT NULL,
1315: p_user_id IN NUMBER,
1308: PROCEDURE Add_MediaLifecycle
1309: (
1310: p_api_version IN NUMBER,
1311: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1312: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1313: p_resp_appl_id IN NUMBER DEFAULT NULL,
1314: p_resp_id IN NUMBER DEFAULT NULL,
1315: p_user_id IN NUMBER,
1316: p_login_id IN NUMBER DEFAULT NULL,
1335: --
1336: -- Standard IN Parameters:
1337: -- p_api_version IN NUMBER Required
1338: -- p_init_msg_list IN VARCHAR2(1) Optional
1339: -- Default = FND_API.G_FALSE
1340: -- p_commit IN VARCHAR2(1) Optional
1341: -- Default = FND_API.G_FALSE
1342: --
1343: -- Standard OUT Parameters:
1337: -- p_api_version IN NUMBER Required
1338: -- p_init_msg_list IN VARCHAR2(1) Optional
1339: -- Default = FND_API.G_FALSE
1340: -- p_commit IN VARCHAR2(1) Optional
1341: -- Default = FND_API.G_FALSE
1342: --
1343: -- Standard OUT Parameters:
1344: -- x_return_status OUT VARCHAR2(1)
1345: -- x_msg_count OUT NUMBER
1378:
1379: PROCEDURE Update_MediaLifecycle
1380: (
1381: p_api_version IN NUMBER,
1382: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1383: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1384: p_resp_appl_id IN NUMBER DEFAULT NULL,
1385: p_resp_id IN NUMBER DEFAULT NULL,
1386: p_user_id IN NUMBER,
1379: PROCEDURE Update_MediaLifecycle
1380: (
1381: p_api_version IN NUMBER,
1382: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1383: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1384: p_resp_appl_id IN NUMBER DEFAULT NULL,
1385: p_resp_id IN NUMBER DEFAULT NULL,
1386: p_user_id IN NUMBER,
1387: p_login_id IN NUMBER DEFAULT NULL,