PACKAGE BODY: APPS.ISC_FS_TASK_SETUP

Source

1 PACKAGE BODY ISC_FS_TASK_SETUP as
2 /*$Header: iscfsbftskb.pls 120.0 2005/08/28 14:56:33 kreardon noship $ */
3 
4 g_user_id  number;
5 g_login_id number;
6 
7 PROCEDURE merge_tasks
8 IS
9 
10 BEGIN
11 
12   g_user_id  := fnd_global.user_id;
13   g_login_id := fnd_global.login_id;
14 
15 
16   insert into ISC_FS_BREAK_FIX_TASKS
17   ( task_type_id
18   , created_by
19   , creation_date
20   , last_updated_by
21   , last_update_date
22   , last_update_login
23   , enabled
24   )
25   select
26     task_type_id
27   , fnd_global.user_id
28   , sysdate
29   , fnd_global.user_id
30   , sysdate
31   , fnd_global.login_id
32   , 'N'
33   from JTF_TASK_TYPES_B jtfb
34   where jtfb.rule='DISPATCH'
35   and jtfb.task_type_id NOT in ( select task_type_id
36                                  from ISC_FS_BREAK_FIX_TASKS
37                                );
38 
39   commit;
40 
41 END merge_tasks;
42 
43 END ISC_FS_TASK_SETUP;
44