eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_ATA_NEW_PUB dependencies on AS_CHANGED_ACCOUNTS

Line 543: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');

539:
540: BEGIN
541: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
544: UPDATE AS_CHANGED_ACCOUNTS
545: SET REQUEST_ID = FND_GLOBAL.Conc_Request_Id
546: where REQUEST_ID IS NULL;
547:

Line 544: UPDATE AS_CHANGED_ACCOUNTS

540: BEGIN
541: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
544: UPDATE AS_CHANGED_ACCOUNTS
545: SET REQUEST_ID = FND_GLOBAL.Conc_Request_Id
546: where REQUEST_ID IS NULL;
547:
548: COMMIT;

Line 582: FROM AS_CHANGED_ACCOUNTS_ALL CHNG

578: p_entity_id entity_id_list;
579:
580: CURSOR del_acct_changed IS
581: SELECT distinct customer_id
582: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
583: WHERE CHNG.lead_id IS NULL
584: AND CHNG.sales_lead_id IS NULL
585: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_ACCOUNT_NM_TRANS TRANS
586: WHERE TRANS.TRANS_OBJECT_ID = CHNG.CUSTOMER_ID);

Line 590: FROM AS_CHANGED_ACCOUNTS_ALL CHNG

586: WHERE TRANS.TRANS_OBJECT_ID = CHNG.CUSTOMER_ID);
587:
588: CURSOR del_lead_changed IS
589: SELECT distinct sales_lead_id
590: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
591: WHERE lead_id IS NULL
592: AND sales_lead_id IS NOT NULL
593: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_LEAD_NM_TRANS TRANS
594: WHERE TRANS.TRANS_OBJECT_ID = CHNG.SALES_LEAD_ID);

Line 598: FROM AS_CHANGED_ACCOUNTS_ALL CHNG

594: WHERE TRANS.TRANS_OBJECT_ID = CHNG.SALES_LEAD_ID);
595:
596: CURSOR del_oppty_changed IS
597: SELECT distinct lead_id
598: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
599: WHERE lead_id IS NOT NULL
600: AND sales_lead_id IS NULL
601: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_OPPOR_NM_TRANS TRANS
602: WHERE TRANS.TRANS_OBJECT_ID = CHNG.LEAD_ID);

Line 618: FROM AS_CHANGED_ACCOUNTS_ALL;

614: WHERE trans.trans_object_id = chng.quote_number);
615:
616: CURSOR del_all_sales IS
617: SELECT distinct customer_id
618: FROM AS_CHANGED_ACCOUNTS_ALL;
619:
620: CURSOR del_all_quotes IS
621: SELECT distinct quote_number
622: FROM ASO_CHANGED_QUOTES;

Line 710: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

706:
707: BEGIN
708: IF p_entity = 'ACCOUNT' THEN
709: FORALL i in l_first..l_last
710: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
711: WHERE ACC.customer_id=p_entity_id(i)
712: AND ACC.lead_id IS NULL
713: AND ACC.sales_lead_id IS NULL;
714:

Line 717: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

713: AND ACC.sales_lead_id IS NULL;
714:
715: ELSIF p_entity = 'LEAD' THEN
716: FORALL i in l_first..l_last
717: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
718: WHERE ACC.sales_lead_id=p_entity_id(i)
719: AND ACC.lead_id IS NULL;
720:
721: ELSIF p_entity = 'OPPTY' THEN

Line 723: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

719: AND ACC.lead_id IS NULL;
720:
721: ELSIF p_entity = 'OPPTY' THEN
722: FORALL i in l_first..l_last
723: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
724: WHERE ACC.lead_id=p_entity_id(i)
725: AND ACC.change_type = 'OPPORTUNITY';
726:
727: --Fix for #4891555

Line 740: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

736: WHERE ACC.proposal_id=p_entity_id(i);
737:
738: ELSIF p_entity = 'ALL_SALES' THEN
739: FORALL i in l_first..l_last
740: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
741: WHERE ACC.customer_id=p_entity_id(i);
742:
743: ELSIF p_entity = 'ALL_QUOTES' THEN
744: FORALL i in l_first..l_last

Line 767: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

763: FOR i IN l_first .. l_last LOOP --{L5
764: BEGIN
765: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);
766: IF p_entity = 'ACCOUNT' THEN
767: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
768: WHERE ACC.customer_id=p_entity_id(i)
769: AND ACC.lead_id IS NULL
770: AND ACC.sales_lead_id IS NULL;
771: ELSIF p_entity = 'LEAD' THEN

Line 772: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

768: WHERE ACC.customer_id=p_entity_id(i)
769: AND ACC.lead_id IS NULL
770: AND ACC.sales_lead_id IS NULL;
771: ELSIF p_entity = 'LEAD' THEN
772: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
773: WHERE ACC.sales_lead_id=p_entity_id(i)
774: AND ACC.lead_id IS NULL;
775: ELSIF p_entity = 'OPPTY' THEN
776: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

Line 776: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

772: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
773: WHERE ACC.sales_lead_id=p_entity_id(i)
774: AND ACC.lead_id IS NULL;
775: ELSIF p_entity = 'OPPTY' THEN
776: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
777: WHERE ACC.lead_id=p_entity_id(i)
778: AND ACC.change_type = 'OPPORTUNITY';
779: --Fix for #4891555
780: ELSIF p_entity = 'QUOTE' THEN

Line 787: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

783: ELSIF p_entity = 'PROPOSAL' THEN
784: DELETE FROM PRP_CHANGED_PROPOSALS ACC
785: WHERE ACC.proposal_id=p_entity_id(i);
786: ELSIF p_entity = 'ALL_SALES' THEN
787: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
788: WHERE ACC.customer_id=p_entity_id(i);
789: ELSIF p_entity = 'ALL_QUOTES' THEN
790: DELETE FROM ASO_CHANGED_QUOTES ACC
791: WHERE ACC.quote_number=p_entity_id(i);

Line 871: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');

867:
868: BEGIN
869: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
872: UPDATE AS_CHANGED_ACCOUNTS
873: SET REQUEST_ID = NULL
874: WHERE REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
875:

Line 872: UPDATE AS_CHANGED_ACCOUNTS

868: BEGIN
869: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
872: UPDATE AS_CHANGED_ACCOUNTS
873: SET REQUEST_ID = NULL
874: WHERE REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
875:
876: COMMIT;