6: * Note: The campaign schedule record type is used as an input parameter in campaign schedule
7: * creation and update methods.
8: *
9: * TYPE schedule_rec_type is RECORD (
10: * schedule_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
7: * creation and update methods.
8: *
9: * TYPE schedule_rec_type is RECORD (
10: * schedule_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
8: *
9: * TYPE schedule_rec_type is RECORD (
10: * schedule_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
9: * TYPE schedule_rec_type is RECORD (
10: * schedule_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
10: * schedule_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
11: * last_update_date DATE := FND_API.G_MISS_DATE,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: * last_updated_by NUMBER := FND_API.G_MISS_NUM,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
13: * creation_date DATE := FND_API.G_MISS_DATE,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: * created_by NUMBER := FND_API.G_MISS_NUM,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
15: * last_update_login NUMBER := FND_API.G_MISS_NUM,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
16: * object_version_number NUMBER := FND_API.G_MISS_NUM,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
17: * campaign_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
18: * user_status_id NUMBER := FND_API.G_MISS_NUM,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: * status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
20: * status_date DATE := FND_API.G_MISS_DATE,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: * source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
22: * use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
23: * start_date_time DATE := FND_API.G_MISS_DATE,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: * end_date_time DATE := FND_API.G_MISS_DATE,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
25: * timezone_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
26: * activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
27: * activity_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
28: * arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: * marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
30: * custom_setup_id NUMBER := FND_API.G_MISS_NUM,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
31: * triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
32: * trigger_id NUMBER := FND_API.G_MISS_NUM,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: * notify_user_id NUMBER := FND_API.G_MISS_NUM,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
34: * approver_user_id NUMBER := FND_API.G_MISS_NUM,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: * owner_user_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
36: * active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: * cover_letter_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
38: * reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
39: * mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
40: * mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: * from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: * accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: * org_id NUMBER := FND_API.G_MISS_NUM,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
44: * objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: * country_id NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
46: * campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
47: * start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: * end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
49: * priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: * workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
51: * transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: * functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: * budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: * budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: * language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: * task_id NUMBER := FND_API.G_MISS_NUM,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: * related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: * related_event_id NUMBER := FND_API.G_MISS_NUM,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: * attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: * attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: * attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: * attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: * attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: * attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: * attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: * attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: * attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: * attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: * attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: * attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: * attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: * attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: * attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: * attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: * activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: * activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: * activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: * activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: * activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: * activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: * activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: * activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: * activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
84: * activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
85: * activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: * activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: * activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
88: * activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
89: * activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: * activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: * schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
92: * description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
93: * related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
94: * related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
95: * related_source_id NUMBER := FND_API.G_MISS_NUM,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
96: * query_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
97: * include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
98: * content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: * test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: * greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
101: * footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
102: * trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
103: * tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: * orig_csch_id NUMBER := FND_API.G_MISS_NUM,
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
105: * cover_letter_version NUMBER := FND_API.G_MISS_NUM,
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
113: * )
106: * usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
113: * )
114: *
107: * purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
113: * )
114: *
115: * @rep:scope public
108: * last_activation_date DATE := FND_API.G_MISS_DATE,
109: * sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
110: * printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
111: * notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: * delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
113: * )
114: *
115: * @rep:scope public
116: * @rep:product AMS
249:
250: --===================================================================
251: TYPE schedule_rec_type IS RECORD
252: (
253: schedule_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
250: --===================================================================
251: TYPE schedule_rec_type IS RECORD
252: (
253: schedule_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
251: TYPE schedule_rec_type IS RECORD
252: (
253: schedule_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
252: (
253: schedule_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
253: schedule_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
254: last_update_date DATE := FND_API.G_MISS_DATE,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
255: last_updated_by NUMBER := FND_API.G_MISS_NUM,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
256: creation_date DATE := FND_API.G_MISS_DATE,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
257: created_by NUMBER := FND_API.G_MISS_NUM,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
258: last_update_login NUMBER := FND_API.G_MISS_NUM,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
259: object_version_number NUMBER := FND_API.G_MISS_NUM,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
260: campaign_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
261: user_status_id NUMBER := FND_API.G_MISS_NUM,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
262: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
263: status_date DATE := FND_API.G_MISS_DATE,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
264: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
265: use_parent_code_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
266: start_date_time DATE := FND_API.G_MISS_DATE,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
267: end_date_time DATE := FND_API.G_MISS_DATE,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
268: timezone_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
269: activity_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
270: activity_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
271: arc_marketing_medium_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
272: marketing_medium_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
273: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
274: triggerable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
275: trigger_id NUMBER := FND_API.G_MISS_NUM,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
276: notify_user_id NUMBER := FND_API.G_MISS_NUM,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
277: approver_user_id NUMBER := FND_API.G_MISS_NUM,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
278: owner_user_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
279: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
280: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
281: reply_to_mail VARCHAR2(120) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
282: mail_sender_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
283: mail_subject VARCHAR2(240) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
284: from_fax_no VARCHAR2(25) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
285: accounts_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
286: org_id NUMBER := FND_API.G_MISS_NUM,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
287: objective_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
288: country_id NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
289: campaign_calendar VARCHAR2(20) := FND_API.G_MISS_CHAR,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
290: start_period_name VARCHAR2(15) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
291: end_period_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
292: priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
293: workflow_item_key VARCHAR2(240) := FND_API.G_MISS_CHAR,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
294: transaction_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
295: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: language_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
299: task_id NUMBER := FND_API.G_MISS_NUM,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: related_event_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: related_event_id NUMBER := FND_API.G_MISS_NUM,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
311: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: activity_attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: activity_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: activity_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: activity_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: activity_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: activity_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: activity_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: activity_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: activity_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
327: activity_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
328: activity_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
329: activity_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: activity_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
331: activity_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: activity_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
333: activity_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
334: -- removed by soagrawa on 24-sep-2001
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: -- security_group_id NUMBER := FND_API.G_MISS_NUM,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: schedule_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
337: description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
338: related_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
339: related_source_object VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
340: related_source_id NUMBER := FND_API.G_MISS_NUM,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: query_id NUMBER := FND_API.G_MISS_NUM,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: include_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
343: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
344: test_email_address VARCHAR2(250):= FND_API.G_MISS_CHAR,
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
345: greeting_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
346: footer_text VARCHAR2(4000):= FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
347: --following are added by anchaudh on 27-jun-2003
348: trig_repeat_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
349: tgrp_exclude_prev_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
350: orig_csch_id NUMBER := FND_API.G_MISS_NUM,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
351: cover_letter_version NUMBER := FND_API.G_MISS_NUM,
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
352: --following are added by dbiswas on 12-aug-2003
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
353: usage VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
354: purpose VARCHAR2(30) := FND_API.G_MISS_CHAR,
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
362: );
355: last_activation_date DATE := FND_API.G_MISS_DATE,
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
362: );
363:
356: sales_methodology_id NUMBER := FND_API.G_MISS_NUM,
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
362: );
363:
364: g_miss_schedule_rec schedule_rec_type;
357: printer_address VARCHAR2(255) := FND_API.G_MISS_CHAR,
358: notify_on_activation_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
359: sender_display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh
360: asn_group_id VARCHAR2(240) := FND_API.G_MISS_CHAR,--anchaudh for leads bug
361: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR
362: );
363:
364: g_miss_schedule_rec schedule_rec_type;
365: TYPE schedule_tbl_type IS TABLE OF schedule_rec_type INDEX BY BINARY_INTEGER;
385: -- Parameters
386: --
387: -- IN
388: -- p_api_version_number IN NUMBER Required
389: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
390: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
391: -- p_schedule_rec IN schedule_rec_type Required
392: --
393: -- OUT
386: --
387: -- IN
388: -- p_api_version_number IN NUMBER Required
389: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
390: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
391: -- p_schedule_rec IN schedule_rec_type Required
392: --
393: -- OUT
394: -- x_return_status OUT VARCHAR2
413: * @param p_commit Flag to indicate if changes should be comitted on success.
414: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
415: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
416: * @param x_return_status Indicates the return status of the API. The values are one of the following:
417: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
418: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
419: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
420: * @param x_msg_count Count of error messages in the message list.
421: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
414: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
415: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
416: * @param x_return_status Indicates the return status of the API. The values are one of the following:
417: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
418: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
419: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
420: * @param x_msg_count Count of error messages in the message list.
421: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
422: * @param x_schedule_id Unique identifier for the newly created Campaign Schedule.
415: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
416: * @param x_return_status Indicates the return status of the API. The values are one of the following:
417: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
418: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
419: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
420: * @param x_msg_count Count of error messages in the message list.
421: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
422: * @param x_schedule_id Unique identifier for the newly created Campaign Schedule.
423: * @rep:scope public
425: * @rep:displayname Create Marketing Campaign Schedule
426: */
427: PROCEDURE Create_Camp_Schedule(
428: p_api_version_number IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
426: */
427: PROCEDURE Create_Camp_Schedule(
428: p_api_version_number IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
427: PROCEDURE Create_Camp_Schedule(
428: p_api_version_number IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435:
451: -- Parameters
452: --
453: -- IN
454: -- p_api_version_number IN NUMBER Required
455: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
456: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
457: -- p_schedule_rec IN schedule_rec_type Required
458: --
459: -- OUT
452: --
453: -- IN
454: -- p_api_version_number IN NUMBER Required
455: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
456: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
457: -- p_schedule_rec IN schedule_rec_type Required
458: --
459: -- OUT
460: -- x_return_status OUT VARCHAR2
479: * @param p_commit Flag to indicate if changes should be comitted on success.
480: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
481: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
482: * @param x_return_status Indicates the return status of the API. The values are one of the following:
483: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful
484: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error
485: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
486: * @param x_msg_count Count of error messages in the message list.
487: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
480: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
481: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
482: * @param x_return_status Indicates the return status of the API. The values are one of the following:
483: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful
484: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error
485: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
486: * @param x_msg_count Count of error messages in the message list.
487: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
488: * @param x_object_version_number Object version number of the updated campaign schedule
481: * @param p_schedule_rec Record of type AMS_Camp_Schedule_PUB.schedule_rec_type that takes in the details for the Campaign Schedule.
482: * @param x_return_status Indicates the return status of the API. The values are one of the following:
483: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful
484: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error
485: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
486: * @param x_msg_count Count of error messages in the message list.
487: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
488: * @param x_object_version_number Object version number of the updated campaign schedule
489: * @rep:scope public
492: */
493:
494: PROCEDURE Update_Camp_Schedule(
495: p_api_version_number IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
498: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
493:
494: PROCEDURE Update_Camp_Schedule(
495: p_api_version_number IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
498: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2,
494: PROCEDURE Update_Camp_Schedule(
495: p_api_version_number IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
498: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2,
502:
518: -- Parameters
519: --
520: -- IN
521: -- p_api_version_number IN NUMBER Required
522: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
523: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
524: -- p_SCHEDULE_ID IN NUMBER
525: -- p_object_version_number IN NUMBER Optional Default = NULL
526: --
519: --
520: -- IN
521: -- p_api_version_number IN NUMBER Required
522: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
523: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
524: -- p_SCHEDULE_ID IN NUMBER
525: -- p_object_version_number IN NUMBER Optional Default = NULL
526: --
527: -- OUT
537: --
538:
539: PROCEDURE Delete_Camp_Schedule(
540: p_api_version_number IN NUMBER,
541: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
542: p_commit IN VARCHAR2 := FND_API.G_FALSE,
543: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
544: x_return_status OUT NOCOPY VARCHAR2,
545: x_msg_count OUT NOCOPY NUMBER,
538:
539: PROCEDURE Delete_Camp_Schedule(
540: p_api_version_number IN NUMBER,
541: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
542: p_commit IN VARCHAR2 := FND_API.G_FALSE,
543: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
544: x_return_status OUT NOCOPY VARCHAR2,
545: x_msg_count OUT NOCOPY NUMBER,
546: x_msg_data OUT NOCOPY VARCHAR2,
539: PROCEDURE Delete_Camp_Schedule(
540: p_api_version_number IN NUMBER,
541: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
542: p_commit IN VARCHAR2 := FND_API.G_FALSE,
543: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
544: x_return_status OUT NOCOPY VARCHAR2,
545: x_msg_count OUT NOCOPY NUMBER,
546: x_msg_data OUT NOCOPY VARCHAR2,
547: p_schedule_id IN NUMBER,
560: -- Parameters
561: --
562: -- IN
563: -- p_api_version_number IN NUMBER Required
564: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
565: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
566: -- p_schedule_rec IN schedule_rec_type Required
567: --
568: -- OUT
561: --
562: -- IN
563: -- p_api_version_number IN NUMBER Required
564: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
565: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
566: -- p_schedule_rec IN schedule_rec_type Required
567: --
568: -- OUT
569: -- x_return_status OUT VARCHAR2
578: --
579:
580: PROCEDURE Lock_Camp_Schedule(
581: p_api_version_number IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586:
599: -- p_schedule_rec: the campaign record to be validated
600: --
601: -- NOTES
602: -- 1. p_schedule_rec should be the complete schedule record. There
603: -- should not be any FND_API.g_miss_char/num/date in it.
604: ----------------------------------------------------------------------
605: PROCEDURE Validate_Camp_Schedule(
606: p_api_version IN NUMBER,
607: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
603: -- should not be any FND_API.g_miss_char/num/date in it.
604: ----------------------------------------------------------------------
605: PROCEDURE Validate_Camp_Schedule(
606: p_api_version IN NUMBER,
607: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
604: ----------------------------------------------------------------------
605: PROCEDURE Validate_Camp_Schedule(
606: p_api_version IN NUMBER,
607: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: p_validation_mode IN VARCHAR2,
625: ----------------------------------------------------------------------
626:
627: PROCEDURE Copy_Camp_Schedule(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630: p_commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632:
633: x_return_status OUT NOCOPY VARCHAR2,
626:
627: PROCEDURE Copy_Camp_Schedule(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630: p_commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632:
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
627: PROCEDURE Copy_Camp_Schedule(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630: p_commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632:
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,