36: p_security_group_id IN NUMBER DEFAULT NULL
37: )
38: IS
39: l_current_date DATE := SYSDATE;
40: l_user_id NUMBER := fnd_global.user_id;
41: l_login_id NUMBER := fnd_global.login_id;
42:
43: CURSOR c_exclusion IS
44: SELECT '1'
37: )
38: IS
39: l_current_date DATE := SYSDATE;
40: l_user_id NUMBER := fnd_global.user_id;
41: l_login_id NUMBER := fnd_global.login_id;
42:
43: CURSOR c_exclusion IS
44: SELECT '1'
45: FROM jta_task_exclusions
98: p_last_update_login IN NUMBER DEFAULT NULL
99: )
100: IS
101: l_current_date DATE := SYSDATE;
102: l_user_id NUMBER := fnd_global.user_id;
103: l_login_id NUMBER := fnd_global.login_id;
104: BEGIN
105:
106: UPDATE jta_task_exclusions
99: )
100: IS
101: l_current_date DATE := SYSDATE;
102: l_user_id NUMBER := fnd_global.user_id;
103: l_login_id NUMBER := fnd_global.login_id;
104: BEGIN
105:
106: UPDATE jta_task_exclusions
107: SET TASK_ID = p_task_id,