APPS.JTF_TASK_CUSTOM_COLORS_PKG dependencies on JTF_TASK_CUSTOM_COLORS

Line 1: package body JTF_TASK_CUSTOM_COLORS_PKG as

1: package body JTF_TASK_CUSTOM_COLORS_PKG as
2: /* $Header: jtftkclb.pls 115.2 2002/12/04 02:27:56 sachoudh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_RULE_ID in NUMBER,

Line 20: cursor C is select ROWID from JTF_TASK_CUSTOM_COLORS

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from JTF_TASK_CUSTOM_COLORS
21: where RULE_ID = X_RULE_ID
22: ;
23: begin
24: insert into JTF_TASK_CUSTOM_COLORS (

Line 24: insert into JTF_TASK_CUSTOM_COLORS (

20: cursor C is select ROWID from JTF_TASK_CUSTOM_COLORS
21: where RULE_ID = X_RULE_ID
22: ;
23: begin
24: insert into JTF_TASK_CUSTOM_COLORS (
25: RULE_ID,
26: OBJECT_VERSION_NUMBER,
27: COLOR_DETERMINATION_PRIORITY,
28: TYPE_ID,

Line 74: from JTF_TASK_CUSTOM_COLORS

70: X_OBJECT_VERSION_NUMBER in NUMBER
71: ) is
72: cursor c1 is select
73: OBJECT_VERSION_NUMBER
74: from JTF_TASK_CUSTOM_COLORS
75: where RULE_ID = X_RULE_ID
76: for update of RULE_ID nowait;
77:
78: recinfo c1%rowtype;

Line 124: update JTF_TASK_CUSTOM_COLORS set

120: X_LAST_UPDATED_BY in NUMBER,
121: X_LAST_UPDATE_LOGIN in NUMBER
122: ) is
123: begin
124: update JTF_TASK_CUSTOM_COLORS set
125: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
126: COLOR_DETERMINATION_PRIORITY = X_COLOR_DETERMINATION_PRIORITY,
127: TYPE_ID = X_TYPE_ID,
128: PRIORITY_ID = X_PRIORITY_ID,

Line 148: delete from JTF_TASK_CUSTOM_COLORS

144: procedure DELETE_ROW (
145: X_RULE_ID in NUMBER
146: ) is
147: begin
148: delete from JTF_TASK_CUSTOM_COLORS
149: where RULE_ID = X_RULE_ID;
150:
151: if (sql%notfound) then
152: raise no_data_found;

Line 157: end JTF_TASK_CUSTOM_COLORS_PKG;

153: end if;
154:
155: end DELETE_ROW;
156:
157: end JTF_TASK_CUSTOM_COLORS_PKG;