APPS.JTA_TASK_EXCLUSIONS_PKG dependencies on JTA_TASK_EXCLUSIONS

Line 1: PACKAGE BODY JTA_TASK_EXCLUSIONS_PKG AS

1: PACKAGE BODY JTA_TASK_EXCLUSIONS_PKG AS
2: /* $Header: jtavsemb.pls 115.5 2002/05/13 10:01:17 pkm ship $ */
3: /*=======================================================================+
4: | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 45: FROM jta_task_exclusions

41: l_login_id NUMBER := fnd_global.login_id;
42:
43: CURSOR c_exclusion IS
44: SELECT '1'
45: FROM jta_task_exclusions
46: WHERE task_id = p_task_id
47: AND recurrence_rule_id = p_recurrence_rule_id;
48:
49: l_exists VARCHAR2(1);

Line 56: INSERT INTO jta_task_exclusions

52: FETCH c_exclusion INTO l_exists;
53: IF c_exclusion%NOTFOUND
54: THEN
55: CLOSE c_exclusion;
56: INSERT INTO jta_task_exclusions
57: (
58: TASK_EXCLUSION_ID,
59: TASK_ID ,
60: RECURRENCE_RULE_ID,

Line 106: UPDATE jta_task_exclusions

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,
108: RECURRENCE_RULE_ID = p_recurrence_rule_id,
109: EXCLUSION_DATE = p_exclusion_date,
110: LAST_UPDATED_BY = nvl(p_last_updated_by, l_user_id),

Line 121: DELETE FROM jta_task_exclusions

117: p_task_exclusion_id IN NUMBER
118: )
119: IS
120: BEGIN
121: DELETE FROM jta_task_exclusions
122: WHERE TASK_EXCLUSION_ID = p_task_exclusion_id;
123: END Delete_Row;
124:
125: END JTA_TASK_EXCLUSIONS_PKG;

Line 125: END JTA_TASK_EXCLUSIONS_PKG;

121: DELETE FROM jta_task_exclusions
122: WHERE TASK_EXCLUSION_ID = p_task_exclusion_id;
123: END Delete_Row;
124:
125: END JTA_TASK_EXCLUSIONS_PKG;