DBA Data[Home] [Help]

APPS.IEX_GAR_PUB dependencies on JTF_TAE_1001_ACCOUNT_TRANS

Line 390: --Fetch the p_prev_request_id from JTF_TAE_1001_ACCOUNT_TRANS

386: px_terr_globals.enable_dups_rs_del := 'Y';
387: px_terr_globals.disable_lead_processing := FND_PROFILE.Value('AS_DISABLE_BATCH_LEAD_TERR_ASSIGNMENT') ;
388:
389: IF p_run_mode = 'RESTART' THEN
390: --Fetch the p_prev_request_id from JTF_TAE_1001_ACCOUNT_TRANS
391: begin
392: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
393: where request_id is not null and rownum < 2 ;
394: exception

Line 392: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans

388:
389: IF p_run_mode = 'RESTART' THEN
390: --Fetch the p_prev_request_id from JTF_TAE_1001_ACCOUNT_TRANS
391: begin
392: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
393: where request_id is not null and rownum < 2 ;
394: exception
395: when others then
396: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');

Line 396: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');

392: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
393: where request_id is not null and rownum < 2 ;
394: exception
395: when others then
396: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: end;
399: px_terr_globals.prev_request_id := l_ata_request_id_of_failed_gar;
400: ELSE