APPS.AS_ATA_NEW_PUB dependencies on PRP_CHANGED_PROPOSALS

Line 558: update PRP_CHANGED_PROPOSALS

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

Line 606: FROM PRP_CHANGED_PROPOSALS CHNG

602: WHERE TRANS.TRANS_OBJECT_ID = CHNG.LEAD_ID);
603:
604: CURSOR del_proposal_changed IS
605: SELECT distinct proposal_id
606: FROM PRP_CHANGED_PROPOSALS CHNG
607: WHERE EXISTS (SELECT 'X' FROM JTF_TAE_1001_PROP_NM_TRANS TRANS
608: WHERE trans.trans_object_id = chng.proposal_id);
609:
610: CURSOR del_quote_changed IS

Line 626: FROM PRP_CHANGED_PROPOSALS;

622: FROM ASO_CHANGED_QUOTES;
623:
624: CURSOR del_all_proposal IS
625: SELECT distinct proposal_id
626: FROM PRP_CHANGED_PROPOSALS;
627:
628: l_flag BOOLEAN;
629: l_first NUMBER;
630: l_last NUMBER;

Line 735: DELETE FROM PRP_CHANGED_PROPOSALS 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
735: DELETE FROM PRP_CHANGED_PROPOSALS 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

Line 750: DELETE FROM PRP_CHANGED_PROPOSALS 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
750: DELETE FROM PRP_CHANGED_PROPOSALS ACC
751: WHERE ACC.proposal_id=p_entity_id(i);
752:
753: END IF;
754: COMMIT;

Line 784: DELETE FROM PRP_CHANGED_PROPOSALS ACC

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);
786: ELSIF p_entity = 'ALL_SALES' THEN
787: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
788: WHERE ACC.customer_id=p_entity_id(i);

Line 793: DELETE FROM PRP_CHANGED_PROPOSALS ACC

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);
795: END IF;
796: COMMIT;
797: EXCEPTION

Line 886: update PRP_CHANGED_PROPOSALS

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