32:
33: PROCEDURE create_notification(
34: p_event IN VARCHAR2
35: , p_task_id IN NUMBER
36: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
33: PROCEDURE create_notification(
34: p_event IN VARCHAR2
35: , p_task_id IN NUMBER
36: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
34: p_event IN VARCHAR2
35: , p_task_id IN NUMBER
36: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
35: , p_task_id IN NUMBER
36: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
36: , p_old_owner_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
37: , p_old_owner_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
38: , p_old_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
39: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
40: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
41: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
42: , p_old_type IN NUMBER DEFAULT jtf_task_utl.g_miss_number
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
43: , p_old_priority IN NUMBER DEFAULT jtf_task_utl.g_miss_number
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
51: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
44: , p_old_status IN NUMBER DEFAULT jtf_task_utl.g_miss_number
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
51: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
52: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
45: , p_old_planned_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
51: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
52: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
53: , x_return_status OUT NOCOPY VARCHAR2
46: , p_old_planned_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
51: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
52: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
53: , x_return_status OUT NOCOPY VARCHAR2
54: , x_msg_count OUT NOCOPY NUMBER
47: , p_old_scheduled_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
48: , p_old_scheduled_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
49: , p_old_actual_start_date IN DATE DEFAULT jtf_task_utl.g_miss_date
50: , p_old_actual_end_date IN DATE DEFAULT jtf_task_utl.g_miss_date
51: , p_old_description IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
52: , p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
53: , x_return_status OUT NOCOPY VARCHAR2
54: , x_msg_count OUT NOCOPY NUMBER
55: , x_msg_data OUT NOCOPY VARCHAR2