APPS.AK_SECURITY_PVT dependencies on AK_RESP_SECURITY_ATTRIBUTES

Line 112: from AK_RESP_SECURITY_ATTRIBUTES

108: p_attribute_application_id IN NUMBER
109: ) return BOOLEAN is
110: cursor l_check_csr is
111: select 1
112: from AK_RESP_SECURITY_ATTRIBUTES
113: where responsibility_id = p_responsibility_id
114: and resp_application_id = p_resp_application_id
115: and attribute_application_id = p_attribute_application_id
116: and attribute_code = p_attribute_code;

Line 550: insert into AK_RESP_SECURITY_ATTRIBUTES (

546:
547: select userenv('LANG') into l_lang
548: from dual;
549:
550: insert into AK_RESP_SECURITY_ATTRIBUTES (
551: RESPONSIBILITY_ID,
552: RESP_APPLICATION_ID,
553: ATTRIBUTE_CODE,
554: ATTRIBUTE_APPLICATION_ID,

Line 658: p_resp_sec_attr_rec IN ak_resp_security_attributes%ROWTYPE

654: --=======================================================
655: procedure WRITE_RESP_SEC_ATTR_TO_BUFFER (
656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: p_return_status OUT NOCOPY VARCHAR2,
658: p_resp_sec_attr_rec IN ak_resp_security_attributes%ROWTYPE
659: ) is
660: l_api_name CONSTANT varchar2(30) := 'Write_Resp_Sec_Attr_to_buffer';
661: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
662: l_index NUMBER;

Line 1183: from AK_RESP_SECURITY_ATTRIBUTES

1179: p_nls_language IN VARCHAR2
1180: ) is
1181: cursor l_get_resp_1_csr (appl_id_parm number) is
1182: select *
1183: from AK_RESP_SECURITY_ATTRIBUTES
1184: where RESP_APPLICATION_ID = appl_id_parm;
1185: cursor l_get_resp_2_csr (appl_id_parm number, resp_id_parm number) is
1186: select *
1187: from AK_RESP_SECURITY_ATTRIBUTES

Line 1187: from AK_RESP_SECURITY_ATTRIBUTES

1183: from AK_RESP_SECURITY_ATTRIBUTES
1184: where RESP_APPLICATION_ID = appl_id_parm;
1185: cursor l_get_resp_2_csr (appl_id_parm number, resp_id_parm number) is
1186: select *
1187: from AK_RESP_SECURITY_ATTRIBUTES
1188: where RESP_APPLICATION_ID = appl_id_parm
1189: and RESPONSIBILITY_ID = resp_id_parm;
1190: l_api_version_number CONSTANT number := 1.0;
1191: l_api_name CONSTANT varchar2(30) := 'Download Resp Sec Attributes';

Line 1195: l_resp_rec ak_resp_security_attributes%ROWTYPE;

1191: l_api_name CONSTANT varchar2(30) := 'Download Resp Sec Attributes';
1192: l_responsibility_found BOOLEAN;
1193: i number;
1194: l_responsibility_appl_id NUMBER;
1195: l_resp_rec ak_resp_security_attributes%ROWTYPE;
1196: l_return_status varchar2(1);
1197: l_select_by_appl_id BOOLEAN;
1198: begin
1199: IF NOT FND_API.Compatible_API_Call (

Line 1256: -- Retrieve excluded items from AK_RESP_SECURITY_ATTRIBUTES that fits the selection

1252: l_select_by_appl_id := FALSE;
1253: end if;
1254:
1255: --
1256: -- Retrieve excluded items from AK_RESP_SECURITY_ATTRIBUTES that fits the selection
1257: -- criteria, one at a time, and write it the buffer table
1258: --
1259: if (l_select_by_appl_id) then
1260: --

Line 1490: l_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;

1486: ) is
1487: l_api_version_number CONSTANT number := 1.0;
1488: l_api_name CONSTANT varchar2(30) := 'Upload_Security';
1489: l_excluded_items_rec ak_excluded_items%ROWTYPE;
1490: l_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;
1491: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1492: l_column varchar2(30);
1493: l_dummy NUMBER;
1494: l_empty_excluded_items_rec ak_excluded_items%ROWTYPE;

Line 1495: l_empty_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;

1491: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1492: l_column varchar2(30);
1493: l_dummy NUMBER;
1494: l_empty_excluded_items_rec ak_excluded_items%ROWTYPE;
1495: l_empty_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;
1496: l_eof_flag VARCHAR2(1);
1497: l_line_num NUMBER;
1498: l_lines_read NUMBER;
1499: l_msg_count NUMBER;