APPS.JTF_AM_SCREEN_SETUPS_PKG dependencies on JTF_AM_SCREEN_SETUPS_B

Line 46: cursor C is select ROWID from JTF_AM_SCREEN_SETUPS_B

42: X_LAST_UPDATE_DATE in DATE,
43: X_LAST_UPDATED_BY in NUMBER,
44: X_LAST_UPDATE_LOGIN in NUMBER
45: ) is
46: cursor C is select ROWID from JTF_AM_SCREEN_SETUPS_B
47: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
48: ;
49: begin
50: insert into JTF_AM_SCREEN_SETUPS_B (

Line 50: insert into JTF_AM_SCREEN_SETUPS_B (

46: cursor C is select ROWID from JTF_AM_SCREEN_SETUPS_B
47: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
48: ;
49: begin
50: insert into JTF_AM_SCREEN_SETUPS_B (
51: ATTRIBUTE15,
52: ATTRIBUTE_CATEGORY,
53: SECURITY_GROUP_ID,
54: ATTRIBUTE11,

Line 243: from JTF_AM_SCREEN_SETUPS_B

239: ATTRIBUTE4,
240: ATTRIBUTE5,
241: ATTRIBUTE6,
242: DOC_DETAILS
243: from JTF_AM_SCREEN_SETUPS_B
244: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
245: for update of SCREEN_SETUP_ID nowait;
246: recinfo c%rowtype;
247:

Line 393: update JTF_AM_SCREEN_SETUPS_B set

389: X_LAST_UPDATED_BY in NUMBER,
390: X_LAST_UPDATE_LOGIN in NUMBER
391: ) is
392: begin
393: update JTF_AM_SCREEN_SETUPS_B set
394: ATTRIBUTE15 = X_ATTRIBUTE15,
395: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
396: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
397: ATTRIBUTE11 = X_ATTRIBUTE11,

Line 461: delete from JTF_AM_SCREEN_SETUPS_B

457: if (sql%notfound) then
458: raise no_data_found;
459: end if;
460:
461: delete from JTF_AM_SCREEN_SETUPS_B
462: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID;
463:
464: if (sql%notfound) then
465: raise no_data_found;

Line 475: from JTF_AM_SCREEN_SETUPS_B B

471: begin
472: delete from JTF_AM_SCREEN_SETUPS_TL T
473: where not exists
474: (select NULL
475: from JTF_AM_SCREEN_SETUPS_B B
476: where B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID
477: );
478:
479: update JTF_AM_SCREEN_SETUPS_TL T set (