APPS.JTF_TASK_RECUR_RULES_PKG dependencies on JTF_TASK_RECUR_RULES

Line 1: PACKAGE body JTF_TASK_RECUR_RULES_PKG as

1: PACKAGE body JTF_TASK_RECUR_RULES_PKG as
2: /* $Header: jtftkrrb.pls 115.16 2002/12/04 22:12:34 cjang ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_RECURRENCE_RULE_ID in NUMBER,

Line 45: cursor C is select ROWID from JTF_TASK_RECUR_RULES

41: x_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: x_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: x_date_selected IN VARCHAR2 default null
44: ) is
45: cursor C is select ROWID from JTF_TASK_RECUR_RULES
46: where RECURRENCE_RULE_ID = X_RECURRENCE_RULE_ID
47: ;
48: begin
49: insert into JTF_TASK_RECUR_RULES (

Line 49: insert into JTF_TASK_RECUR_RULES (

45: cursor C is select ROWID from JTF_TASK_RECUR_RULES
46: where RECURRENCE_RULE_ID = X_RECURRENCE_RULE_ID
47: ;
48: begin
49: insert into JTF_TASK_RECUR_RULES (
50: RECURRENCE_RULE_ID,
51: CREATED_BY,
52: CREATION_DATE,
53: LAST_UPDATED_BY,

Line 149: from JTF_TASK_RECUR_RULES

145: X_OBJECT_VERSION_NUMBER in NUMBER
146: ) is
147: cursor c1 is select
148: OBJECT_VERSION_NUMBER
149: from JTF_TASK_RECUR_RULES
150: where RECURRENCE_RULE_ID = X_RECURRENCE_RULE_ID
151: for update of RECURRENCE_RULE_ID nowait;
152: tlinfo c1%rowtype ;
153: BEGIN

Line 215: update JTF_TASK_RECUR_RULES set

211: x_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
212: x_date_selected IN VARCHAR2 default null
213: ) is
214: begin
215: update JTF_TASK_RECUR_RULES set
216: OCCURS_WHICH = X_OCCURS_WHICH,
217: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
218: DAY_OF_WEEK = X_DAY_OF_WEEK,
219: DATE_OF_MONTH = X_DATE_OF_MONTH,

Line 266: delete from JTF_TASK_RECUR_RULES

262: X_RECURRENCE_RULE_ID in NUMBER,
263: X_OBJECT_VERSION_NUMBER in NUMBER
264: ) is
265: begin
266: delete from JTF_TASK_RECUR_RULES
267: where RECURRENCE_RULE_ID = X_RECURRENCE_RULE_ID
268: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ;
269:
270: if (sql%notfound) then

Line 276: end JTF_TASK_RECUR_RULES_PKG;

272: end if;
273:
274: end DELETE_ROW;
275:
276: end JTF_TASK_RECUR_RULES_PKG;