APPS.JTF_DISPLAYCONTEXT_GRP dependencies on JTF_DSP_CONTEXT_B

Line 40: SELECT jtf_dsp_context_b_s1.NEXTVAL

36:
37: l_access_name VARCHAR2(40);
38:
39: CURSOR context_id_seq IS
40: SELECT jtf_dsp_context_b_s1.NEXTVAL
41: FROM DUAL;
42:
43: BEGIN
44:

Line 145: INSERT INTO JTF_DSP_CONTEXT_B (

141: END IF;
142:
143: IF l_operation_type = 'INSERT'
144: THEN
145: INSERT INTO JTF_DSP_CONTEXT_B (
146: CONTEXT_ID,
147: OBJECT_VERSION_NUMBER,
148: LAST_UPDATE_DATE,
149: LAST_UPDATED_BY,

Line 207: UPDATE JTF_DSP_CONTEXT_B SET

203:
204: ELSIF l_operation_type = 'UPDATE'
205: THEN
206:
207: UPDATE JTF_DSP_CONTEXT_B SET
208: LAST_UPDATE_DATE = SYSDATE,
209: LAST_UPDATED_BY = FND_GLOBAL.user_id,
210: LAST_UPDATE_LOGIN= FND_GLOBAL.user_id,
211: ACCESS_NAME = p_display_context_rec.access_name,

Line 353: DELETE FROM JTF_DSP_CONTEXT_B WHERE

349: = false then
350: raise FND_API.g_exc_error;
351: end if;
352:
353: DELETE FROM JTF_DSP_CONTEXT_B WHERE
354: CONTEXT_ID = p_display_context_rec.context_id AND
355: CONTEXT_TYPE_CODE = p_display_context_rec.context_type AND
356: OBJECT_VERSION_NUMBER= p_display_context_rec.object_version_number;
357:

Line 571: -- 2. Sets the item_id in JTF_DSP_CONTEXT_B to null for

567:
568: ---------------------------------------------------------------
569: -- NOTES
570: -- 1. Raise exception if there is a database error
571: -- 2. Sets the item_id in JTF_DSP_CONTEXT_B to null for
572: -- the deliverable id passed
573: -- 3. No api level exceptions are raised
574: --------------------------------------------------------------------
575: PROCEDURE delete_deliverable(

Line 586: update JTF_DSP_CONTEXT_B set item_id = null where

582:
583: if p_deliverable_id <> FND_API.g_miss_num or p_deliverable_id is not null
584: then
585: -- Set the deliverable id to null for any display context
586: update JTF_DSP_CONTEXT_B set item_id = null where
587: item_id = p_deliverable_id;
588: end if;
589:
590:

Line 615: cursor C is select ROWID from JTF_DSP_CONTEXT_B

611: X_LAST_UPDATE_DATE in DATE,
612: X_LAST_UPDATED_BY in NUMBER,
613: X_LAST_UPDATE_LOGIN in NUMBER) IS
614:
615: cursor C is select ROWID from JTF_DSP_CONTEXT_B
616: where CONTEXT_ID = X_CONTEXT_ID
617: ;
618: begin
619: insert into JTF_DSP_CONTEXT_B (

Line 619: insert into JTF_DSP_CONTEXT_B (

615: cursor C is select ROWID from JTF_DSP_CONTEXT_B
616: where CONTEXT_ID = X_CONTEXT_ID
617: ;
618: begin
619: insert into JTF_DSP_CONTEXT_B (
620: SECURITY_GROUP_ID,
621: CONTEXT_ID,
622: OBJECT_VERSION_NUMBER,
623: ACCESS_NAME,

Line 710: from JTF_DSP_CONTEXT_B

706: OBJECT_VERSION_NUMBER,
707: ACCESS_NAME,
708: CONTEXT_TYPE_CODE,
709: ITEM_ID
710: from JTF_DSP_CONTEXT_B
711: where CONTEXT_ID = X_CONTEXT_ID
712: for update of CONTEXT_ID nowait;
713: recinfo c%rowtype;
714:

Line 782: update JTF_DSP_CONTEXT_B set

778: X_LAST_UPDATE_LOGIN in NUMBER
779: ) IS
780:
781: begin
782: update JTF_DSP_CONTEXT_B set
783: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
784: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
785: ACCESS_NAME = X_ACCESS_NAME,
786: CONTEXT_TYPE_CODE = X_CONTEXT_TYPE_CODE,

Line 827: delete from JTF_DSP_CONTEXT_B

823: if (sql%notfound) then
824: raise no_data_found;
825: end if;
826:
827: delete from JTF_DSP_CONTEXT_B
828: where CONTEXT_ID = X_CONTEXT_ID;
829:
830: if (sql%notfound) then
831: raise no_data_found;

Line 924: from JTF_DSP_CONTEXT_B B

920: begin
921: delete from JTF_DSP_CONTEXT_TL T
922: where not exists
923: (select NULL
924: from JTF_DSP_CONTEXT_B B
925: where B.CONTEXT_ID = T.CONTEXT_ID
926: );
927:
928: update JTF_DSP_CONTEXT_TL T set (