APPS.GL_DEFAS_ACCESS_DETAILS_PKG dependencies on GL_DEFAS_ASSIGNMENTS

Line 305: FROM gl_defas_assignments

301: X_Request_Id NUMBER)IS
302:
303: CURSOR C IS
304: SELECT rowid
305: FROM gl_defas_assignments
306: WHERE definition_access_set_id = X_Definition_Access_Set_Id
307: AND object_type = X_Object_Type
308: AND object_key = X_Object_Key;
309: BEGIN

Line 310: INSERT INTO gl_defas_assignments

306: WHERE definition_access_set_id = X_Definition_Access_Set_Id
307: AND object_type = X_Object_Type
308: AND object_key = X_Object_Key;
309: BEGIN
310: INSERT INTO gl_defas_assignments
311: (definition_access_set_id,
312: object_type,
313: object_key,
314: view_access_flag,

Line 407: UPDATE gl_defas_assignments

403: X_Attribute13 VARCHAR2 DEFAULT NULL,
404: X_Attribute14 VARCHAR2 DEFAULT NULL,
405: X_Attribute15 VARCHAR2 DEFAULT NULL) IS
406: BEGIN
407: UPDATE gl_defas_assignments
408: SET view_access_flag = X_View_Access_Flag,
409: use_access_flag = X_Use_Access_Flag,
410: modify_access_flag = X_Modify_Access_Flag,
411: last_update_date = X_Last_Update_Date,

Line 474: FROM gl_defas_assignments

470: X_Attribute15 VARCHAR2 DEFAULT NULL,
471: X_Request_Id NUMBER )IS
472: CURSOR C IS
473: SELECT *
474: FROM gl_defas_assignments
475: WHERE rowid = X_Rowid
476: FOR UPDATE of Definition_Access_Set_Id NOWAIT;
477: Recinfo C%ROWTYPE;
478: l_request_id NUMBER(15);

Line 612: UPDATE GL_DEFAS_ASSIGNMENTS

608: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
609: X_Status_Code VARCHAR2) IS
610: BEGIN
611: if( X_Status_Code = 'D') then
612: UPDATE GL_DEFAS_ASSIGNMENTS
613: SET status_code = 'D'
614: WHERE rowid = X_Rowid;
615: else
616: DELETE FROM gl_defas_assignments

Line 616: DELETE FROM gl_defas_assignments

612: UPDATE GL_DEFAS_ASSIGNMENTS
613: SET status_code = 'D'
614: WHERE rowid = X_Rowid;
615: else
616: DELETE FROM gl_defas_assignments
617: WHERE rowid = X_Rowid;
618: end if;
619:
620: if SQL%NOTFOUND then

Line 631: FROM GL_DEFAS_ASSIGNMENTS a

627: X_Object_Key VARCHAR2 ) IS
628:
629: CURSOR c_dup IS
630: SELECT 'Duplicate'
631: FROM GL_DEFAS_ASSIGNMENTS a
632: WHERE a.object_type = X_Object_Type
633: AND a.object_key = X_Object_Key
634: AND a.definition_access_set_id = X_Definition_Access_Set_Id
635: AND (a.status_code <> 'D' or a.status_code is null);