APPS.GL_DEFAS_ACCESS_DETAILS_PKG dependencies on GL_DEFAS_ASSIGNMENTS

Line 310: FROM gl_defas_assignments

306: X_Request_Id NUMBER)IS
307:
308: CURSOR C IS
309: SELECT rowid
310: FROM gl_defas_assignments
311: WHERE definition_access_set_id = X_Definition_Access_Set_Id
312: AND object_type = X_Object_Type
313: AND object_key = X_Object_Key;
314: BEGIN

Line 315: INSERT INTO gl_defas_assignments

311: WHERE definition_access_set_id = X_Definition_Access_Set_Id
312: AND object_type = X_Object_Type
313: AND object_key = X_Object_Key;
314: BEGIN
315: INSERT INTO gl_defas_assignments
316: (definition_access_set_id,
317: object_type,
318: object_key,
319: view_access_flag,

Line 412: UPDATE gl_defas_assignments

408: X_Attribute13 VARCHAR2 DEFAULT NULL,
409: X_Attribute14 VARCHAR2 DEFAULT NULL,
410: X_Attribute15 VARCHAR2 DEFAULT NULL) IS
411: BEGIN
412: UPDATE gl_defas_assignments
413: SET view_access_flag = X_View_Access_Flag,
414: use_access_flag = X_Use_Access_Flag,
415: modify_access_flag = X_Modify_Access_Flag,
416: last_update_date = X_Last_Update_Date,

Line 479: FROM gl_defas_assignments

475: X_Attribute15 VARCHAR2 DEFAULT NULL,
476: X_Request_Id NUMBER )IS
477: CURSOR C IS
478: SELECT *
479: FROM gl_defas_assignments
480: WHERE rowid = X_Rowid
481: FOR UPDATE of Definition_Access_Set_Id NOWAIT;
482: Recinfo C%ROWTYPE;
483: l_request_id NUMBER(15);

Line 617: UPDATE GL_DEFAS_ASSIGNMENTS

613: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
614: X_Status_Code VARCHAR2) IS
615: BEGIN
616: if( X_Status_Code = 'D') then
617: UPDATE GL_DEFAS_ASSIGNMENTS
618: SET status_code = 'D'
619: WHERE rowid = X_Rowid;
620: else
621: DELETE FROM gl_defas_assignments

Line 621: DELETE FROM gl_defas_assignments

617: UPDATE GL_DEFAS_ASSIGNMENTS
618: SET status_code = 'D'
619: WHERE rowid = X_Rowid;
620: else
621: DELETE FROM gl_defas_assignments
622: WHERE rowid = X_Rowid;
623: end if;
624:
625: if SQL%NOTFOUND then

Line 636: FROM GL_DEFAS_ASSIGNMENTS a

632: X_Object_Key VARCHAR2 ) IS
633:
634: CURSOR c_dup IS
635: SELECT 'Duplicate'
636: FROM GL_DEFAS_ASSIGNMENTS a
637: WHERE a.object_type = X_Object_Type
638: AND a.object_key = X_Object_Key
639: AND a.definition_access_set_id = X_Definition_Access_Set_Id
640: AND (a.status_code <> 'D' or a.status_code is null);