APPS.JTF_STATE_TRANSITIONS_PKG dependencies on JTF_STATE_TRANSITIONS

Line 1: PACKAGE body JTF_STATE_TRANSITIONS_PKG as

1: PACKAGE body JTF_STATE_TRANSITIONS_PKG as
2: /* $Header: jtftktrb.pls 115.13 2002/12/04 23:09:45 cjang ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_STATE_TRANSITION_ID in NUMBER,

Line 31: cursor C is select ROWID from JTF_STATE_TRANSITIONS

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from JTF_STATE_TRANSITIONS
32: where STATE_TRANSITION_ID = X_STATE_TRANSITION_ID
33: ;
34: begin
35: insert into JTF_STATE_TRANSITIONS (

Line 35: insert into JTF_STATE_TRANSITIONS (

31: cursor C is select ROWID from JTF_STATE_TRANSITIONS
32: where STATE_TRANSITION_ID = X_STATE_TRANSITION_ID
33: ;
34: begin
35: insert into JTF_STATE_TRANSITIONS (
36: STATE_TRANSITION_ID,
37: CREATED_BY,
38: CREATION_DATE,
39: LAST_UPDATED_BY,

Line 106: from JTF_STATE_TRANSITIONS

102: X_OBJECT_VERSION_NUMBER in NUMBER
103: ) is
104: cursor c is select
105: OBJECT_VERSION_NUMBER
106: from JTF_STATE_TRANSITIONS
107: where STATE_TRANSITION_ID = X_STATE_TRANSITION_ID
108: for update of STATE_TRANSITION_ID nowait;
109:
110:

Line 159: update JTF_STATE_TRANSITIONS set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update JTF_STATE_TRANSITIONS set
160: INITIAL_STATE_ID = X_INITIAL_STATE_ID,
161: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ,
162: FINAL_STATE_ID = X_FINAL_STATE_ID,
163: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 194: delete from JTF_STATE_TRANSITIONS

190: procedure DELETE_ROW (
191: X_STATE_TRANSITION_ID in NUMBER
192: ) is
193: begin
194: delete from JTF_STATE_TRANSITIONS
195: where STATE_TRANSITION_ID = X_STATE_TRANSITION_ID ;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 204: end JTF_STATE_TRANSITIONS_PKG;

200:
201: end DELETE_ROW;
202:
203:
204: end JTF_STATE_TRANSITIONS_PKG;