[Home] [Help]
PACKAGE: APPS.JTF_TASK_WF_UTIL
Source
1 PACKAGE jtf_task_wf_util AUTHID CURRENT_USER AS
2 /* $Header: jtftkwus.pls 120.1.12000000.2 2007/10/04 13:20:43 venjayar ship $ */
3 g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASK_WF_UTIL';
4 jtf_task_wf_item_type CONSTANT VARCHAR2(8) := 'JTFTASK';
5 jtf_task_main_process CONSTANT VARCHAR2(30) := 'TASK_WORKFLOW';
6
7 TYPE nlist_rec_type IS RECORD(
8 NAME wf_users.NAME%TYPE := fnd_api.g_miss_char
9 , display_name wf_users.display_name%TYPE := fnd_api.g_miss_char
10 , email_address wf_users.email_address%TYPE := fnd_api.g_miss_char
11 );
12
13 TYPE nlist_tbl_type IS TABLE OF nlist_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 notiflist nlist_tbl_type;
17 g_miss_notiflist nlist_tbl_type;
18 g_miss_nlist_rec nlist_rec_type;
19 g_event VARCHAR2(80);
20 g_task_id jtf_tasks_b.task_id%TYPE;
21 g_old_owner_id jtf_tasks_b.owner_id%TYPE;
22 g_old_owner_code jtf_tasks_b.owner_type_code%TYPE;
23 g_owner_id jtf_tasks_b.owner_id%TYPE;
24 g_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
25 g_old_assignee_id jtf_tasks_b.owner_id%TYPE;
26 g_old_assignee_code jtf_tasks_b.owner_type_code%TYPE;
27 g_new_assignee_id jtf_tasks_b.owner_id%TYPE;
28 g_new_assignee_code jtf_tasks_b.owner_type_code%TYPE;
29
30 FUNCTION do_notification(p_task_id IN NUMBER)
31 RETURN BOOLEAN;
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
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
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
56 );
57
58 PROCEDURE set_notif_message(
59 itemtype IN VARCHAR2
60 , itemkey IN VARCHAR2
61 , actid IN NUMBER
62 , funcmode IN VARCHAR2
63 , resultout OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE set_notif_performer(
67 itemtype IN VARCHAR2
68 , itemkey IN VARCHAR2
69 , actid IN NUMBER
70 , funcmode IN VARCHAR2
71 , resultout OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE set_notif_list(
75 itemtype IN VARCHAR2
76 , itemkey IN VARCHAR2
77 , actid IN NUMBER
78 , funcmode IN VARCHAR2
79 , resultout OUT NOCOPY VARCHAR2
80 );
81 END jtf_task_wf_util;