APPS.JTF_UM_APPROVALS_PKG dependencies on JTF_UM_APPROVALS_B

Line 21: insert into JTF_UM_APPROVALS_B (

17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_USE_PENDING_REQ_FLAG in VARCHAR2
19: ) is
20: begin
21: insert into JTF_UM_APPROVALS_B (
22: EFFECTIVE_END_DATE,
23: APPROVAL_ID,
24: APPROVAL_KEY,
25: ENABLED_FLAG,

Line 37: JTF_UM_APPROVALS_B_S.NEXTVAL,

33: LAST_UPDATE_LOGIN,
34: USE_PENDING_REQ_FLAG
35: ) values (
36: X_EFFECTIVE_END_DATE,
37: JTF_UM_APPROVALS_B_S.NEXTVAL,
38: X_APPROVAL_KEY,
39: X_ENABLED_FLAG,
40: X_WF_ITEM_TYPE,
41: X_EFFECTIVE_START_DATE,

Line 147: from JTF_UM_APPROVALS_B

143: ENABLED_FLAG,
144: WF_ITEM_TYPE,
145: EFFECTIVE_START_DATE,
146: APPLICATION_ID
147: from JTF_UM_APPROVALS_B
148: where APPROVAL_ID = X_APPROVAL_ID
149: for update of APPROVAL_ID nowait;
150: recinfo c%rowtype;
151:

Line 214: update JTF_UM_APPROVALS_B set

210: X_LAST_UPDATE_LOGIN in NUMBER,
211: X_USE_PENDING_REQ_FLAG in VARCHAR2
212: ) is
213: begin
214: update JTF_UM_APPROVALS_B set
215: APPROVAL_KEY = X_APPROVAL_KEY,
216: ENABLED_FLAG = X_ENABLED_FLAG,
217: WF_ITEM_TYPE = X_WF_ITEM_TYPE,
218: APPLICATION_ID = X_APPLICATION_ID,

Line 309: FROM JTF_UM_APPROVALS_B

305: -- there is a row for this app_id and this app_short_name
306: -- Exception is thrown otherwise.
307: select LAST_UPDATED_BY, LAST_UPDATE_DATE
308: into db_luby, db_ludate
309: FROM JTF_UM_APPROVALS_B
310: where APPROVAL_ID = X_APPROVAL_ID;
311:
312: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
313: db_ludate, X_CUSTOM_MODE)) then

Line 551: delete from JTF_UM_APPROVALS_B

547: if (sql%notfound) then
548: raise no_data_found;
549: end if;
550:
551: delete from JTF_UM_APPROVALS_B
552: where APPROVAL_ID = X_APPROVAL_ID;
553:
554: if (sql%notfound) then
555: raise no_data_found;

Line 577: from JTF_UM_APPROVALS_B B

573: begin
574: delete from JTF_UM_APPROVALS_TL T
575: where not exists
576: (select NULL
577: from JTF_UM_APPROVALS_B B
578: where B.APPROVAL_ID = T.APPROVAL_ID
579: );
580:
581: update JTF_UM_APPROVALS_TL T set (