APPS.IEX_TERR_ASSIGNMENT_CLEANUP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 114

 |      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;

Line: 153

SELECT  distinct trans_object_id
FROM JTF_TAE_1001_ACCOUNT_TRANS
WHERE worker_id=c_worker_id;

Line: 179

 |      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;

Line: 194

    TYPE last_update_date_list  is TABLE of DATE INDEX BY BINARY_INTEGER;

Line: 195

    TYPE last_updated_by_list   is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line: 198

    TYPE last_update_login_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line: 203

    l_last_update_date          last_update_date_list;

Line: 204

    l_last_updated_by           last_updated_by_list;

Line: 207

    l_last_update_login         last_update_login_list;