135:
136: --===================================================================
137: TYPE schedule_rec_type IS RECORD
138: (
139: schedule_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
136: --===================================================================
137: TYPE schedule_rec_type IS RECORD
138: (
139: schedule_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
137: TYPE schedule_rec_type IS RECORD
138: (
139: schedule_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
138: (
139: schedule_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
139: schedule_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
140: last_update_date DATE := FND_API.G_MISS_DATE,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: last_updated_by NUMBER := FND_API.G_MISS_NUM,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
142: creation_date DATE := FND_API.G_MISS_DATE,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: created_by NUMBER := FND_API.G_MISS_NUM,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
144: last_update_login NUMBER := FND_API.G_MISS_NUM,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
145: object_version_number NUMBER := FND_API.G_MISS_NUM,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
146: campaign_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
147: user_status_id NUMBER := FND_API.G_MISS_NUM,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
149: status_date DATE := FND_API.G_MISS_DATE,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
152: start_date_time DATE := FND_API.G_MISS_DATE,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: end_date_time DATE := FND_API.G_MISS_DATE,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
154: timezone_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
155: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
156: activity_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
157: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
160: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
161: trigger_id NUMBER := FND_API.G_MISS_NUM,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
162: notify_user_id NUMBER := FND_API.G_MISS_NUM,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
163: approver_user_id NUMBER := FND_API.G_MISS_NUM,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
165: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
167: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
172: org_id NUMBER := FND_API.G_MISS_NUM,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
173: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
174: country_id NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
175: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
176: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
177: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
178: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
180: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
181: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
185: task_id NUMBER := FND_API.G_MISS_NUM,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
186: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
187: related_event_id NUMBER := FND_API.G_MISS_NUM,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
189: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
193: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
197: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
213: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
214: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
215: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
216: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
218: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
219: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
220: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
224: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
225: related_source_id NUMBER := FND_API.G_MISS_NUM,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
226: query_id NUMBER := FND_API.G_MISS_NUM,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
228: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
230: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
231: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
232: -- following are added by anchaudh on 27-jun-2003
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
234: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
237: -- added by dbiswas on Aug12, 2003
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
239: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
247: );
240: last_activation_date DATE := FND_API.G_MISS_DATE,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
247: );
248:
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
247: );
248:
249: g_miss_schedule_rec schedule_rec_type;
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
243: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
247: );
248:
249: g_miss_schedule_rec schedule_rec_type;
250: TYPE schedule_tbl_type IS TABLE OF schedule_rec_type INDEX BY BINARY_INTEGER;
262: -- Parameters
263: --
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
268: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
269: -- p_schedule_rec IN schedule_rec_type Required
270: --
263: --
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
268: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
269: -- p_schedule_rec IN schedule_rec_type Required
270: --
271: -- OUT
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
268: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
269: -- p_schedule_rec IN schedule_rec_type Required
270: --
271: -- OUT
272: -- x_return_status OUT VARCHAR2
281: --
282:
283: PROCEDURE Create_Camp_Schedule(
284: p_api_version_number IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_commit IN VARCHAR2 := FND_API.G_FALSE,
287: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
288:
289: x_return_status OUT NOCOPY VARCHAR2,
282:
283: PROCEDURE Create_Camp_Schedule(
284: p_api_version_number IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_commit IN VARCHAR2 := FND_API.G_FALSE,
287: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
288:
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
283: PROCEDURE Create_Camp_Schedule(
284: p_api_version_number IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_commit IN VARCHAR2 := FND_API.G_FALSE,
287: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
288:
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
306: -- Parameters
307: --
308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_schedule_rec IN schedule_rec_type Required
314: --
307: --
308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_schedule_rec IN schedule_rec_type Required
314: --
315: -- OUT
308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_schedule_rec IN schedule_rec_type Required
314: --
315: -- OUT
316: -- x_return_status OUT VARCHAR2
325: --
326:
327: PROCEDURE Update_Camp_Schedule(
328: p_api_version_number IN NUMBER,
329: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330: p_commit IN VARCHAR2 := FND_API.G_FALSE,
331: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332:
333: x_return_status OUT NOCOPY VARCHAR2,
326:
327: PROCEDURE Update_Camp_Schedule(
328: p_api_version_number IN NUMBER,
329: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330: p_commit IN VARCHAR2 := FND_API.G_FALSE,
331: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332:
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
327: PROCEDURE Update_Camp_Schedule(
328: p_api_version_number IN NUMBER,
329: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330: p_commit IN VARCHAR2 := FND_API.G_FALSE,
331: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332:
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
350: -- Parameters
351: --
352: -- IN
353: -- p_api_version_number IN NUMBER Required
354: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
355: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
356: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
357: -- p_SCHEDULE_ID IN NUMBER
358: -- p_object_version_number IN NUMBER Optional Default = NULL
351: --
352: -- IN
353: -- p_api_version_number IN NUMBER Required
354: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
355: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
356: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
357: -- p_SCHEDULE_ID IN NUMBER
358: -- p_object_version_number IN NUMBER Optional Default = NULL
359: --
352: -- IN
353: -- p_api_version_number IN NUMBER Required
354: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
355: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
356: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
357: -- p_SCHEDULE_ID IN NUMBER
358: -- p_object_version_number IN NUMBER Optional Default = NULL
359: --
360: -- OUT
370: --
371:
372: PROCEDURE Delete_Camp_Schedule(
373: p_api_version_number IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
375: p_commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
371:
372: PROCEDURE Delete_Camp_Schedule(
373: p_api_version_number IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
375: p_commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
372: PROCEDURE Delete_Camp_Schedule(
373: p_api_version_number IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
375: p_commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
380: p_schedule_id IN NUMBER,
393: -- Parameters
394: --
395: -- IN
396: -- p_api_version_number IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
398: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
399: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
400: -- p_schedule_rec IN schedule_rec_type Required
401: --
394: --
395: -- IN
396: -- p_api_version_number IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
398: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
399: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
400: -- p_schedule_rec IN schedule_rec_type Required
401: --
402: -- OUT
395: -- IN
396: -- p_api_version_number IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
398: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
399: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
400: -- p_schedule_rec IN schedule_rec_type Required
401: --
402: -- OUT
403: -- x_return_status OUT VARCHAR2
412: --
413:
414: PROCEDURE Lock_Camp_Schedule(
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417:
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,
436: -- End of Comments
437:
438: PROCEDURE Validate_camp_schedule(
439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: p_schedule_rec IN schedule_rec_type,
443: p_validation_mode IN VARCHAR2,
444: x_return_status OUT NOCOPY VARCHAR2,
437:
438: PROCEDURE Validate_camp_schedule(
439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: p_schedule_rec IN schedule_rec_type,
443: p_validation_mode IN VARCHAR2,
444: x_return_status OUT NOCOPY VARCHAR2,
445: x_msg_count OUT NOCOPY NUMBER,
475: -- End of Comments
476:
477: PROCEDURE Validate_schedule_rec(
478: p_api_version_number IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_schedule_rec IN schedule_rec_type
551: --
552:
553: PROCEDURE Copy_Camp_Schedule(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
556: p_commit IN VARCHAR2 := FND_API.G_FALSE,
557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558:
559: x_return_status OUT NOCOPY VARCHAR2,
552:
553: PROCEDURE Copy_Camp_Schedule(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
556: p_commit IN VARCHAR2 := FND_API.G_FALSE,
557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558:
559: x_return_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
553: PROCEDURE Copy_Camp_Schedule(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
556: p_commit IN VARCHAR2 := FND_API.G_FALSE,
557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558:
559: x_return_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2,