APPS.AK_SECURITY_PVT dependencies on AK_EXCLUDED_ITEMS

Line 37: from AK_EXCLUDED_ITEMS

33: p_attribute_application_id IN NUMBER
34: ) return BOOLEAN is
35: cursor l_check_csr is
36: select 1
37: from AK_EXCLUDED_ITEMS
38: where responsibility_id = p_responsibility_id
39: and resp_application_id = p_resp_application_id
40: and attribute_application_id = p_attribute_application_id
41: and attribute_code = p_attribute_code;

Line 311: insert into AK_EXCLUDED_ITEMS (

307:
308: select userenv('LANG') into l_lang
309: from dual;
310:
311: insert into AK_EXCLUDED_ITEMS (
312: RESPONSIBILITY_ID,
313: RESP_APPLICATION_ID,
314: ATTRIBUTE_CODE,
315: ATTRIBUTE_APPLICATION_ID,

Line 798: p_excluded_rec IN ak_excluded_items%ROWTYPE

794: --=======================================================
795: procedure WRITE_TO_BUFFER (
796: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
797: p_return_status OUT NOCOPY VARCHAR2,
798: p_excluded_rec IN ak_excluded_items%ROWTYPE
799: ) is
800: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
801: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
802: l_index NUMBER;

Line 965: from AK_EXCLUDED_ITEMS

961: p_nls_language IN VARCHAR2
962: ) is
963: cursor l_get_resp_1_csr (appl_id_parm number) is
964: select *
965: from AK_EXCLUDED_ITEMS
966: where RESP_APPLICATION_ID = appl_id_parm;
967: cursor l_get_resp_2_csr (appl_id_parm number, resp_id_parm number) is
968: select *
969: from AK_EXCLUDED_ITEMS

Line 969: from AK_EXCLUDED_ITEMS

965: from AK_EXCLUDED_ITEMS
966: where RESP_APPLICATION_ID = appl_id_parm;
967: cursor l_get_resp_2_csr (appl_id_parm number, resp_id_parm number) is
968: select *
969: from AK_EXCLUDED_ITEMS
970: where RESP_APPLICATION_ID = appl_id_parm
971: and RESPONSIBILITY_ID = resp_id_parm;
972: l_api_version_number CONSTANT number := 1.0;
973: l_api_name CONSTANT varchar2(30) := 'Download Excluded Items';

Line 977: l_excluded_rec ak_excluded_items%ROWTYPE;

973: l_api_name CONSTANT varchar2(30) := 'Download Excluded Items';
974: l_responsibility_found BOOLEAN;
975: i number;
976: l_responsibility_appl_id NUMBER;
977: l_excluded_rec ak_excluded_items%ROWTYPE;
978: l_return_status varchar2(1);
979: l_select_by_appl_id BOOLEAN;
980: begin
981:

Line 1039: -- Retrieve excluded items from AK_EXCLUDED_ITEMS that fits the selection

1035: l_select_by_appl_id := FALSE;
1036: end if;
1037:
1038: --
1039: -- Retrieve excluded items from AK_EXCLUDED_ITEMS that fits the selection
1040: -- criteria, one at a time, and write it the buffer table
1041: --
1042: if (l_select_by_appl_id) then
1043: --

Line 1489: l_excluded_items_rec ak_excluded_items%ROWTYPE;

1485: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
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;

Line 1494: l_empty_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;
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;

Line 1793: -- Insert record into ak_excluded_items if record does not exist

1789: p_attribute_code => l_excluded_items_rec.attribute_code,
1790: p_attribute_application_id=>
1791: l_excluded_items_rec.attribute_application_id) then
1792:
1793: -- Insert record into ak_excluded_items if record does not exist
1794: --
1795: AK_SECURITY_PVT.CREATE_EXCLUDED_ITEM (
1796: p_validation_level => p_validation_level,
1797: p_api_version_number => 1.0,