APPS.JTF_UM_TEMPLATES_PKG dependencies on JTF_UM_TEMPLATES_B

Line 21: cursor C is select ROWID from JTF_UM_TEMPLATES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_UM_TEMPLATES_B
22: where TEMPLATE_ID = X_TEMPLATE_ID
23: ;
24: begin
25: insert into JTF_UM_TEMPLATES_B (

Line 25: insert into JTF_UM_TEMPLATES_B (

21: cursor C is select ROWID from JTF_UM_TEMPLATES_B
22: where TEMPLATE_ID = X_TEMPLATE_ID
23: ;
24: begin
25: insert into JTF_UM_TEMPLATES_B (
26: TEMPLATE_ID,
27: TEMPLATE_KEY,
28: TEMPLATE_TYPE_CODE,
29: PAGE_NAME,

Line 41: JTF_UM_TEMPLATES_B_S.NEXTVAL,

37: LAST_UPDATE_DATE,
38: LAST_UPDATED_BY,
39: LAST_UPDATE_LOGIN
40: ) values (
41: JTF_UM_TEMPLATES_B_S.NEXTVAL,
42: X_TEMPLATE_KEY,
43: X_TEMPLATE_TYPE_CODE,
44: X_PAGE_NAME,
45: X_TEMPLATE_HANDLER,

Line 118: from JTF_UM_TEMPLATES_B

114: ENABLED_FLAG,
115: EFFECTIVE_START_DATE,
116: APPLICATION_ID,
117: EFFECTIVE_END_DATE
118: from JTF_UM_TEMPLATES_B
119: where TEMPLATE_ID = X_TEMPLATE_ID
120: for update of TEMPLATE_ID nowait;
121: recinfo c%rowtype;
122:

Line 188: update JTF_UM_TEMPLATES_B set

184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: begin
188: update JTF_UM_TEMPLATES_B set
189: TEMPLATE_KEY = X_TEMPLATE_KEY,
190: TEMPLATE_TYPE_CODE = X_TEMPLATE_TYPE_CODE,
191: PAGE_NAME = X_PAGE_NAME,
192: TEMPLATE_HANDLER = X_TEMPLATE_HANDLER,

Line 231: delete from JTF_UM_TEMPLATES_B

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: delete from JTF_UM_TEMPLATES_B
232: where TEMPLATE_ID = X_TEMPLATE_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 245: from JTF_UM_TEMPLATES_B B

241: begin
242: delete from JTF_UM_TEMPLATES_TL T
243: where not exists
244: (select NULL
245: from JTF_UM_TEMPLATES_B B
246: where B.TEMPLATE_ID = T.TEMPLATE_ID
247: );
248:
249: update JTF_UM_TEMPLATES_TL T set (

Line 370: FROM JTF_UM_TEMPLATES_B

366: -- there is a row for this app_id and this app_short_name
367: -- Exception is thrown otherwise.
368: select LAST_UPDATED_BY, LAST_UPDATE_DATE
369: into db_luby, db_ludate
370: FROM JTF_UM_TEMPLATES_B
371: where TEMPLATE_ID = X_TEMPLATE_ID;
372:
373: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
374: db_ludate, X_CUSTOM_MODE)) then