[Home] [Help]
358: -- Start of comments
359: -- API name : purge_login_items_table
360: -- TYPE : PRIVATE
361: -- Pre-reqs : None
362: -- FUNCTION : Delete the records from EGO_LOGIN_ITEMS_TEMP
363: --
364: -- Parameters:
365: -- IN : NONE
366: --
364: -- Parameters:
365: -- IN : NONE
366: --
367: BEGIN
368: DELETE EGO_LOGIN_ITEMS_TEMP WHERE CONC_REQUEST_ID = G_REQUEST_ID;
369: EXCEPTION
370: WHEN OTHERS THEN
371: NULL;
372: END purge_login_items_table;
511: RAISE;
512: END initialize_all_users;
513:
514: -----------------------------------------------------------
515: -- Populate temporary table EGO_LOGIN_ITEMS_TEMP with --
516: -- the itmes on which the user has 'EGO_ADD_ITEM_PEOPLE' --
517: -- privilege --
518: -----------------------------------------------------------
519: PROCEDURE Initialize_Access_Items
523: -- API name : Initialize_Access_Items
524: -- TYPE : PRIVATE
525: -- Pre-reqs : Valid user has logged in
526: --
527: -- FUNCTION : To populate temporary table EGO_LOGIN_ITEMS_TEMP
528: -- with the items onto which the user can give access
529: --
530: -- Parameters:
531: -- IN : NONE
550:
551: l_count NUMBER := 0;
552: l_select_sql VARCHAR2(32767);
553: -- Bug 13637215 comment out Start
554: -- Note: No more table ego_login_items_temp
555: -- l_insert_sql VARCHAR2(500);
556: -- cursor_insert INTEGER;
557: -- Bug 13637215 comment out End
558: cursor_select INTEGER;
572: -- Deleting the entire table, is avoided.
573: -- Now seeding Item rows striped with Concurrent Request ID.
574: -- Rows will be deleted, per Conc Req ID, at the end of processing.
575: -----------------------------------------------------------------------
576: -- DELETE EGO_LOGIN_ITEMS_TEMP;
577:
578: -- Bug 13599076 DBG Comment out start
579: -- EGO_DATA_SECURITY.get_security_predicate(
580: -- p_api_version => 1.0,
694: -- Bug 13599076 End
695:
696: --Bug 13637215 comment out start
697: /*
698: l_insert_sql := 'INSERT INTO EGO_LOGIN_ITEMS_TEMP (INVENTORY_ITEM_ID, ORGANIZATION_ID, CONC_REQUEST_ID) ';
699: l_insert_sql := l_insert_sql || ' VALUES (:l_item_id_table, :l_org_id_table, :l_conc_req_id_table) ';
700: */
701: --Bug 13637215 comment out end
702:
1849: -- --
1850: -- CURSOR c_get_grant_privileges (cp_inventory_item_id IN NUMBER
1851: -- ,cp_organization_id IN NUMBER) IS
1852: -- SELECT inventory_item_id
1853: -- FROM EGO_LOGIN_ITEMS_TEMP
1854: -- WHERE inventory_item_id = cp_inventory_item_id
1855: -- AND organization_id = cp_organization_id
1856: -- AND conc_request_id = G_REQUEST_ID;
1857: --
1926: l_log_return_status VARCHAR2(99);
1927: l_log_mesg_token_tbl ERROR_HANDLER.Mesg_Token_Tbl_Type;
1928:
1929: -- Bug 13637215 Start
1930: -- Note: No more ego_login_items_temp
1931: l_user_name VARCHAR2(80);
1932: l_group_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
1933: l_company_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
1934: l_object_id NUMBER;
2047: END IF;
2048:
2049: -- Bug 13637215 comment out start
2050: /*
2051: Write_Debug('Initalizing table Ego_Login_Items_Temp');
2052: initialize_access_items (p_login_person_id => l_login_party_id
2053: ,x_retcode => x_retcode);
2054: IF x_retcode = RETCODE_ERROR THEN
2055: Write_Debug('Error Initalizing Ego_Login_Items_Temp');
2051: Write_Debug('Initalizing table Ego_Login_Items_Temp');
2052: initialize_access_items (p_login_person_id => l_login_party_id
2053: ,x_retcode => x_retcode);
2054: IF x_retcode = RETCODE_ERROR THEN
2055: Write_Debug('Error Initalizing Ego_Login_Items_Temp');
2056: fnd_message.set_name('EGO', 'EGO_IPI_ERR_INIT_ITEMS');
2057: x_errbuff := fnd_message.get();
2058: -- conc_output (x_errbuff);
2059: purge_login_items_table();
2058: -- conc_output (x_errbuff);
2059: purge_login_items_table();
2060: RETURN;
2061: END IF;
2062: Write_Debug('Successfully Initalized Ego_Login_Items_Temp');
2063: */
2064: -- Bug 13637215 comment out end
2065:
2066: Write_Debug('Initalizing FND Object Id');