APPS.JTF_PREFAB_CA_COMPS_PKG dependencies on JTF_PREFAB_CA_COMPS_B

Line 28: -- cursor C is select ROWID from JTF_PREFAB_CA_COMPS_B

24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: l_ca_comp_id NUMBER;
28: -- cursor C is select ROWID from JTF_PREFAB_CA_COMPS_B
29: -- where CA_COMP_ID = X_CA_COMP_ID;
30: begin
31: -- The following select is required as we are referring the X_CA_COMP_ID in
32: -- two insert statements and calling JTF.CA_COMP_ID_SEQ.nextval twice will return two different values.

Line 34: insert into JTF_PREFAB_CA_COMPS_B (

30: begin
31: -- The following select is required as we are referring the X_CA_COMP_ID in
32: -- two insert statements and calling JTF.CA_COMP_ID_SEQ.nextval twice will return two different values.
33: select JTF.CA_COMP_ID_SEQ.nextval into l_ca_comp_id from dual;
34: insert into JTF_PREFAB_CA_COMPS_B (
35: -- SECURITY_GROUP_ID,
36: APPLICATION_ID,
37: COMP_NAME,
38: COMPONENT_KEY,

Line 153: from JTF_PREFAB_CA_COMPS_B

149: DISTRIBUTED_FLAG,
150: CACHE_GENERIC_FLAG,
151: BUSINESS_EVENT_NAME,
152: OBJECT_VERSION_NUMBER
153: from JTF_PREFAB_CA_COMPS_B
154: where CA_COMP_ID = X_CA_COMP_ID
155: for update of CA_COMP_ID nowait;
156: recinfo c%rowtype;
157:

Line 233: update JTF_PREFAB_CA_COMPS_B set

229: X_LAST_UPDATED_BY in NUMBER,
230: X_LAST_UPDATE_LOGIN in NUMBER
231: ) is
232: begin
233: update JTF_PREFAB_CA_COMPS_B set
234: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
235: APPLICATION_ID = X_APPLICATION_ID,
236: COMP_NAME = X_COMP_NAME,
237: COMPONENT_KEY = X_COMPONENT_KEY,

Line 279: update JTF_PREFAB_CA_COMPS_B set

275: X_CA_COMP_ID in NUMBER,
276: X_LAST_UPDATED_BY in NUMBER
277: ) is
278: begin
279: update JTF_PREFAB_CA_COMPS_B set
280: LAST_UPDATED_BY = X_LAST_UPDATED_BY
281: where CA_COMP_ID = X_CA_COMP_ID;
282:
283: if (sql%notfound) then

Line 300: delete from JTF_PREFAB_CA_COMPS_B

296: if (sql%notfound) then
297: raise no_data_found;
298: end if;
299:
300: delete from JTF_PREFAB_CA_COMPS_B
301: where CA_COMP_ID = X_CA_COMP_ID;
302:
303: if (sql%notfound) then
304: raise no_data_found;

Line 314: from JTF_PREFAB_CA_COMPS_B B

310: begin
311: delete from JTF_PREFAB_CA_COMPS_TL T
312: where not exists
313: (select NULL
314: from JTF_PREFAB_CA_COMPS_B B
315: where B.CA_COMP_ID = T.CA_COMP_ID
316: );
317:
318: update JTF_PREFAB_CA_COMPS_TL T set (

Line 398: -- cursor c is select nvl(max(CA_COMP_ID), 0) from jtf_prefab_ca_comps_b where CA_COMP_ID < 10000;

394: db_ludate DATE;
395: l_ca_comp_id NUMBER;
396: l_host_app_id NUMBER;
397:
398: -- cursor c is select nvl(max(CA_COMP_ID), 0) from jtf_prefab_ca_comps_b where CA_COMP_ID < 10000;
399: -- cursor c_ha is select nvl(max(HA_COMP_ID), 0) from jtf_prefab_ha_comps where HA_COMP_ID < 10000;
400: l_pseudo_seq NUMBER := NULL;
401: l_pseudo_seq_ha NUMBER := NULL;
402:

Line 424: FROM JTF_PREFAB_CA_COMPS_B

420:
421: begin
422: SELECT CA_COMP_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
423: INTO l_ca_comp_id, db_luby, db_ludate
424: FROM JTF_PREFAB_CA_COMPS_B
425: WHERE APPLICATION_ID = X_APPLICATION_ID AND
426: COMPONENT_KEY = X_COMPONENT_KEY;
427:
428: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 522: --as we have already inserted comp_id value into JTF_PREFAB_CA_COMPS_B table

518: f_ludate,
519: 0,
520: -- NULL,
521: l_host_app_id,
522: --as we have already inserted comp_id value into JTF_PREFAB_CA_COMPS_B table
523: JTF.CA_COMP_ID_SEQ.currval,
524: -- l_pseudo_seq,
525: 'CO',
526: 'f',

Line 562: --as we have already inserted comp_id value into JTF_PREFAB_CA_COMPS_B table

558: f_ludate,
559: 0,
560: -- NULL,
561: l_host_app_id,
562: --as we have already inserted comp_id value into JTF_PREFAB_CA_COMPS_B table
563: JTF.CA_COMP_ID_SEQ.currval,
564: -- l_pseudo_seq,
565: 'CO',
566: 'f',

Line 599: FROM JTF_PREFAB_CA_COMPS_B b, JTF_PREFAB_CA_COMPS_TL tl

595:
596: begin
597: SELECT tl.CA_COMP_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
598: INTO l_ca_comp_id, db_luby, db_ludate
599: FROM JTF_PREFAB_CA_COMPS_B b, JTF_PREFAB_CA_COMPS_TL tl
600: WHERE b.CA_COMP_ID = tl.CA_COMP_ID AND
601: b.APPLICATION_ID = X_APPLICATION_ID AND
602: b.COMPONENT_KEY = X_COMPONENT_KEY AND
603: tl.LANGUAGE = userenv('LANG');