DBA Data[Home] [Help]

APPS.AMS_CAMP_SCHEDULE_PVT dependencies on FND_API

Line 139: schedule_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 140: last_update_date DATE := FND_API.G_MISS_DATE,

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,

Line 141: last_updated_by 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,

Line 142: creation_date DATE := FND_API.G_MISS_DATE,

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,

Line 143: created_by 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,

Line 144: last_update_login 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,

Line 145: object_version_number NUMBER := FND_API.G_MISS_NUM,

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,

Line 146: campaign_id 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,
150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 147: user_status_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 148: status_code VARCHAR2(30) := 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,

Line 149: status_date 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,

Line 150: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 151: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 152: start_date_time DATE := FND_API.G_MISS_DATE,

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,

Line 153: end_date_time DATE := FND_API.G_MISS_DATE,

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,

Line 154: timezone_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 155: activity_type_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,
159: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

Line 156: activity_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,

Line 157: arc_marketing_medium_from VARCHAR2(30) := 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,

Line 158: marketing_medium_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,

Line 159: custom_setup_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,

Line 160: triggerable_flag VARCHAR2(1) := 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,
164: owner_user_id NUMBER := FND_API.G_MISS_NUM,

Line 161: trigger_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,

Line 162: notify_user_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 163: approver_user_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,

Line 164: owner_user_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,
168: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 165: active_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,
169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 166: cover_letter_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,
170: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,

Line 167: reply_to_mail VARCHAR2(120) := 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,

Line 168: mail_sender_name VARCHAR2(120) := 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,

Line 169: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 170: from_fax_no VARCHAR2(25) := 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,

Line 171: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 172: org_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 173: objective_code VARCHAR2(30) := 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,

Line 174: country_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 175: campaign_calendar VARCHAR2(20) := 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,

Line 176: start_period_name VARCHAR2(15) := 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,

Line 177: end_period_name VARCHAR2(30) := 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,

Line 178: priority 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,
182: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,

Line 179: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 180: transaction_currency_code VARCHAR2(15) := 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,
184: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,

Line 181: functional_currency_code 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,
185: task_id NUMBER := FND_API.G_MISS_NUM,

Line 182: budget_amount_tc 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,

Line 183: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,

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,

Line 184: language_code VARCHAR2(4) := 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,
188: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 185: task_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 186: related_event_from VARCHAR2(30) := 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,

Line 187: related_event_id 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,
191: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 188: attribute_category VARCHAR2(30) := 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,

Line 189: attribute1 VARCHAR2(150) := 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,

Line 190: attribute2 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,

Line 191: attribute3 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,

Line 192: attribute4 VARCHAR2(240) := 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,

Line 193: attribute5 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,

Line 194: attribute6 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,

Line 195: attribute7 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,

Line 196: attribute8 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,

Line 197: attribute9 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,

Line 198: attribute10 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,

Line 199: attribute11 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,

Line 200: attribute12 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,

Line 201: attribute13 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,
205: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 202: attribute14 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,

Line 203: attribute15 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,

Line 204: activity_attribute_category VARCHAR2(240) := 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,

Line 205: activity_attribute1 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,

Line 206: activity_attribute2 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,

Line 207: activity_attribute3 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,

Line 208: activity_attribute4 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,

Line 209: activity_attribute5 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,

Line 210: activity_attribute6 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,

Line 211: activity_attribute7 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,

Line 212: activity_attribute8 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,

Line 213: activity_attribute9 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,

Line 214: activity_attribute10 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,

Line 215: activity_attribute11 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,

Line 216: activity_attribute12 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,

Line 217: activity_attribute13 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,
221: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 218: activity_attribute14 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,
222: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,

Line 219: activity_attribute15 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,
223: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

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,

Line 221: schedule_name VARCHAR2(120) := 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,

Line 222: description VARCHAR2(4000):= 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,
226: query_id NUMBER := FND_API.G_MISS_NUM,

Line 223: related_source_code VARCHAR2(30) := 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,
227: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 224: related_source_object VARCHAR2(30) := 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,

Line 225: related_source_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,
229: test_email_address VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 226: query_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 227: include_content_flag VARCHAR2(1) := 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,

Line 228: content_type 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,
232: -- following are added by anchaudh on 27-jun-2003

Line 229: test_email_address VARCHAR2(250) := 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
233: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 230: greeting_text VARCHAR2(4000):= 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,

Line 231: footer_text VARCHAR2(4000):= 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,

Line 233: trig_repeat_flag VARCHAR2(1) := 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,
236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
237: -- added by dbiswas on Aug12, 2003

Line 234: tgrp_exclude_prev_flag VARCHAR2(1) := 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
238: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 235: orig_csch_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 236: cover_letter_version NUMBER := FND_API.G_MISS_NUM,

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,

Line 238: usage VARCHAR2(30) := 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,
241: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,

Line 239: purpose VARCHAR2(30) := 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,

Line 240: last_activation_date DATE := FND_API.G_MISS_DATE,

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

Line 241: sales_methodology_id 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
245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug

Line 242: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,

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

Line 243: notify_on_activation_flag VARCHAR2(1) := 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: );

Line 244: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh

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:

Line 245: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug

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;

Line 246: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR

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;

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

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: --

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

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

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

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

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

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,

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

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,

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

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,

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

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: --

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

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

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

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

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

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,

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

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,

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

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,

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

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

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

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: --

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

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

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

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,

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

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,

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

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,

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

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: --

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

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

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

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

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

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,

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

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,

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

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,

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

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

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

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,

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

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,

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

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,