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 ASO_CHANGED_QUOTES

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

546: where REQUEST_ID IS NULL;
547:
548: COMMIT;
549:
550: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
551: update ASO_CHANGED_QUOTES
552: set CONC_REQUEST_ID = FND_GLOBAL.Conc_Request_Id
553: where CONC_REQUEST_ID IS NULL;
554:

Line 551: update ASO_CHANGED_QUOTES

547:
548: COMMIT;
549:
550: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
551: update ASO_CHANGED_QUOTES
552: set CONC_REQUEST_ID = FND_GLOBAL.Conc_Request_Id
553: where CONC_REQUEST_ID IS NULL;
554:
555: COMMIT;

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

553: where CONC_REQUEST_ID IS NULL;
554:
555: COMMIT;
556:
557: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
558: update PRP_CHANGED_PROPOSALS
559: set REQUEST_ID = FND_GLOBAL.Conc_Request_Id
560: where REQUEST_ID IS NULL;
561: COMMIT;

Line 612: FROM ASO_CHANGED_QUOTES CHNG

608: WHERE trans.trans_object_id = chng.proposal_id);
609:
610: CURSOR del_quote_changed IS
611: SELECT distinct quote_number
612: FROM ASO_CHANGED_QUOTES CHNG
613: WHERE EXISTS (SELECT 'X' FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS
614: WHERE trans.trans_object_id = chng.quote_number);
615:
616: CURSOR del_all_sales IS

Line 622: FROM ASO_CHANGED_QUOTES;

618: FROM AS_CHANGED_ACCOUNTS_ALL;
619:
620: CURSOR del_all_quotes IS
621: SELECT distinct quote_number
622: FROM ASO_CHANGED_QUOTES;
623:
624: CURSOR del_all_proposal IS
625: SELECT distinct proposal_id
626: FROM PRP_CHANGED_PROPOSALS;

Line 730: DELETE FROM ASO_CHANGED_QUOTES ACC

726:
727: --Fix for #4891555
728: ELSIF p_entity = 'QUOTE' THEN
729: FORALL i in l_first..l_last
730: DELETE FROM ASO_CHANGED_QUOTES ACC
731: WHERE ACC.quote_number=p_entity_id(i);
732:
733: ELSIF p_entity = 'PROPOSAL' THEN
734: FORALL i in l_first..l_last

Line 745: DELETE FROM ASO_CHANGED_QUOTES 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
745: DELETE FROM ASO_CHANGED_QUOTES ACC
746: WHERE ACC.quote_number=p_entity_id(i);
747:
748: ELSIF p_entity = 'ALL_PROPOSALS' THEN
749: FORALL i in l_first..l_last

Line 781: DELETE FROM ASO_CHANGED_QUOTES 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
781: DELETE FROM ASO_CHANGED_QUOTES ACC
782: WHERE ACC.quote_number=p_entity_id(i);
783: ELSIF p_entity = 'PROPOSAL' THEN
784: DELETE FROM PRP_CHANGED_PROPOSALS ACC
785: WHERE ACC.proposal_id=p_entity_id(i);

Line 790: DELETE FROM ASO_CHANGED_QUOTES ACC

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);
792: ELSIF p_entity = 'ALL_PROPOSALS' THEN
793: DELETE FROM PRP_CHANGED_PROPOSALS ACC
794: WHERE ACC.proposal_id=p_entity_id(i);

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

874: WHERE REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
875:
876: COMMIT;
877:
878: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
879: update ASO_CHANGED_QUOTES
880: set CONC_REQUEST_ID = NULL
881: where CONC_REQUEST_ID =FND_GLOBAL.Conc_Request_Id;
882:

Line 879: update ASO_CHANGED_QUOTES

875:
876: COMMIT;
877:
878: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
879: update ASO_CHANGED_QUOTES
880: set CONC_REQUEST_ID = NULL
881: where CONC_REQUEST_ID =FND_GLOBAL.Conc_Request_Id;
882:
883: COMMIT;

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

881: where CONC_REQUEST_ID =FND_GLOBAL.Conc_Request_Id;
882:
883: COMMIT;
884:
885: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
886: update PRP_CHANGED_PROPOSALS
887: set REQUEST_ID = NULL
888: where REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
889: COMMIT;