The following lines contain the word 'select', 'insert', 'update' or 'delete':
| Updates the unqualified account records in as_accesses_all_all
| table.
|
| NOTES
|
|
| HISTORY
*-------------------------------------------------------------------------*/
PROCEDURE Perform_Account_Cleanup(
x_errbuf OUT NOCOPY VARCHAR2,
x_retcode OUT NOCOPY VARCHAR2,
p_terr_globals IN IEX_TERR_WINNERS_PUB.TERR_GLOBALS)
IS
TYPE customer_id_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;
SELECT distinct trans_object_id
FROM JTF_TAE_1001_ACCOUNT_TRANS
WHERE worker_id=c_worker_id;
| To delete all the records in as_changed_accounts_all
| where request_id is not null ( only in NEW mode )
|
| NOTES
|
|
| HISTORY
*-------------------------------------------------------------------------*/
PROCEDURE Perform_Chgd_Accts_Cleanup(
x_errbuf OUT NOCOPY VARCHAR2,
x_retcode OUT NOCOPY VARCHAR2,
p_terr_globals IN IEX_TERR_WINNERS_PUB.TERR_GLOBALS)
IS
TYPE customer_id_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;
TYPE last_update_date_list is TABLE of DATE INDEX BY BINARY_INTEGER;
TYPE last_updated_by_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;
TYPE last_update_login_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;
l_last_update_date last_update_date_list;
l_last_updated_by last_updated_by_list;
l_last_update_login last_update_login_list;