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.

[Home] [Help]

APPS.AS_ATA_TOTAL_PUB dependencies on PRP_CHANGED_PROPOSALS

Line 537: FROM PRP_CHANGED_PROPOSALS;

533: AND sales_lead_id IS NULL;
534:
535: CURSOR del_proposal_changed IS
536: SELECT distinct proposal_id
537: FROM PRP_CHANGED_PROPOSALS;
538:
539: CURSOR del_quote_changed IS
540: SELECT distinct quote_number
541: FROM ASO_CHANGED_QUOTES;

Line 635: DELETE FROM PRP_CHANGED_PROPOSALS ACC

631: WHERE ACC.quote_number=l_entity_id(i);
632:
633: ELSIF p_entity = 'PROPOSAL' THEN
634: FORALL i in l_first..l_last
635: DELETE FROM PRP_CHANGED_PROPOSALS ACC
636: WHERE ACC.proposal_id=l_entity_id(i);
637:
638: END IF;
639: COMMIT;

Line 670: DELETE FROM PRP_CHANGED_PROPOSALS ACC

666: ELSIF p_entity = 'QUOTE' THEN
667: DELETE FROM ASO_CHANGED_QUOTES ACC
668: WHERE ACC.quote_number=l_entity_id(i);
669: ELSIF p_entity = 'PROPOSAL' THEN
670: DELETE FROM PRP_CHANGED_PROPOSALS ACC
671: WHERE ACC.proposal_id=l_entity_id(i);
672: END IF;
673: COMMIT;
674: EXCEPTION