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