[Home] [Help]
229: -- Start of comments
230: -- API name : purge_login_items_table
231: -- TYPE : PRIVATE
232: -- Pre-reqs : None
233: -- FUNCTION : Delete the records from EGO_LOGIN_ITEMS_TEMP
234: --
235: -- Parameters:
236: -- IN : NONE
237: --
235: -- Parameters:
236: -- IN : NONE
237: --
238: BEGIN
239: DELETE EGO_LOGIN_ITEMS_TEMP WHERE CONC_REQUEST_ID = G_REQUEST_ID;
240: EXCEPTION
241: WHEN OTHERS THEN
242: NULL;
243: END purge_login_items_table;
382: RAISE;
383: END initialize_all_users;
384:
385: -----------------------------------------------------------
386: -- Populate temporary table EGO_LOGIN_ITEMS_TEMP with --
387: -- the itmes on which the user has 'EGO_ADD_ITEM_PEOPLE' --
388: -- privilege --
389: -----------------------------------------------------------
390: PROCEDURE Initialize_Access_Items
394: -- API name : Initialize_Access_Items
395: -- TYPE : PRIVATE
396: -- Pre-reqs : Valid user has logged in
397: --
398: -- FUNCTION : To populate temporary table EGO_LOGIN_ITEMS_TEMP
399: -- with the items onto which the user can give access
400: --
401: -- Parameters:
402: -- IN : NONE
425: -- Deleting the entire table, is avoided.
426: -- Now seeding Item rows striped with Concurrent Request ID.
427: -- Rows will be deleted, per Conc Req ID, at the end of processing.
428: -----------------------------------------------------------------------
429: -- DELETE EGO_LOGIN_ITEMS_TEMP;
430:
431: EGO_DATA_SECURITY.get_security_predicate(
432: p_api_version => 1.0,
433: p_function => 'EGO_ADD_ITEM_PEOPLE',
463: l_select_sql := l_select_sql || 'WHERE ' || l_sec_predicate ;
464:
465: Write_Debug('Access Items SQL => '||l_select_sql);
466:
467: l_insert_sql := 'INSERT INTO EGO_LOGIN_ITEMS_TEMP (INVENTORY_ITEM_ID, ORGANIZATION_ID, CONC_REQUEST_ID) ';
468: l_insert_sql := l_insert_sql || ' VALUES (:l_item_id_table, :l_org_id_table, :l_conc_req_id_table) ';
469:
470: cursor_select := DBMS_SQL.OPEN_CURSOR;
471: cursor_insert := DBMS_SQL.OPEN_CURSOR;
1603: -- --
1604: -- CURSOR c_get_grant_privileges (cp_inventory_item_id IN NUMBER
1605: -- ,cp_organization_id IN NUMBER) IS
1606: -- SELECT inventory_item_id
1607: -- FROM EGO_LOGIN_ITEMS_TEMP
1608: -- WHERE inventory_item_id = cp_inventory_item_id
1609: -- AND organization_id = cp_organization_id
1610: -- AND conc_request_id = G_REQUEST_ID;
1611: --
1777: -- conc_output (x_errbuff);
1778: RETURN;
1779: END IF;
1780:
1781: Write_Debug('Initalizing table Ego_Login_Items_Temp');
1782: initialize_access_items (p_login_person_id => l_login_party_id
1783: ,x_retcode => x_retcode);
1784: IF x_retcode = RETCODE_ERROR THEN
1785: Write_Debug('Error Initalizing Ego_Login_Items_Temp');
1781: Write_Debug('Initalizing table Ego_Login_Items_Temp');
1782: initialize_access_items (p_login_person_id => l_login_party_id
1783: ,x_retcode => x_retcode);
1784: IF x_retcode = RETCODE_ERROR THEN
1785: Write_Debug('Error Initalizing Ego_Login_Items_Temp');
1786: fnd_message.set_name('EGO', 'EGO_IPI_ERR_INIT_ITEMS');
1787: x_errbuff := fnd_message.get();
1788: -- conc_output (x_errbuff);
1789: purge_login_items_table();
1788: -- conc_output (x_errbuff);
1789: purge_login_items_table();
1790: RETURN;
1791: END IF;
1792: Write_Debug('Successfully Initalized Ego_Login_Items_Temp');
1793:
1794: Write_Debug('Initalizing FND Object Id');
1795: initialize_fnd_object_id(p_object_name => G_FND_OBJECT_NAME);
1796: Write_Debug('Initalizing All Users global var : G_ALL_USERS_PARTY_ID');
2567: AND eipi.created_by <> -99
2568: AND eipi.inventory_item_id IS NOT NULL
2569: AND NOT EXISTS
2570: (SELECT 'X'
2571: FROM EGO_LOGIN_ITEMS_TEMP
2572: WHERE inventory_item_id = eipi.inventory_item_id
2573: AND organization_id = eipi.organization_id
2574: AND conc_request_id = G_REQUEST_ID
2575: );