APPS.QPR_DEAL_PVT dependencies on QPR_PN_REQUEST_HDRS_B

Line 556: update qpr_pn_request_hdrs_b

552: p_instance_id in number,
553: return_status out nocopy varchar2)
554: is
555: begin
556: update qpr_pn_request_hdrs_b
557: set request_status = 'CANCELLED'
558: where source_id = p_quote_origin
559: and source_ref_hdr_id = p_quote_header_id
560: and instance_id = p_instance_id

Line 606: from qpr_pn_request_hdrs_b req, qpr_pn_response_hdrs res

602: p_quote_header_id is null then
603: begin
604: select req.source_id, req.source_ref_hdr_id, req.instance_id
605: into quote_origin, quote_header_id, instance_id
606: from qpr_pn_request_hdrs_b req, qpr_pn_response_hdrs res
607: where req.request_header_id = res.request_header_id
608: and req.source_ref_hdr_id = nvl(p_quote_header_id, req.source_ref_hdr_id)
609: and req.source_id = nvl(p_quote_origin, req.source_id)
610: and req.request_header_id = nvl(p_request_header_id, req.request_header_id)

Line 699: update qpr_pn_request_hdrs_b

695: status varchar2)
696: is
697: begin
698: if status = 'CREATED' then
699: update qpr_pn_request_hdrs_b
700: set simulation_flag = 'N'
701: where request_header_id = p_request_header_id;
702: elsif status = 'ACCEPTED' then
703: update qpr_pn_request_hdrs_b

Line 703: update qpr_pn_request_hdrs_b

699: update qpr_pn_request_hdrs_b
700: set simulation_flag = 'N'
701: where request_header_id = p_request_header_id;
702: elsif status = 'ACCEPTED' then
703: update qpr_pn_request_hdrs_b
704: set request_status = 'CLOSED'
705: where request_header_id = p_request_header_id;
706: end if;
707: end;

Line 718: from qpr_pn_request_hdrs_b req

714: is
715: l_dummy varchar2(1);
716: begin
717: select 'Y' into l_dummy
718: from qpr_pn_request_hdrs_b req
719: where req.source_ref_hdr_id = p_quote_header_id
720: and req.source_id = p_quote_origin
721: and req.instance_id = p_instance_id
722: and nvl(req.request_status, 'ACTIVE') <> 'CANCELLED' ;

Line 738: from qpr_pn_request_hdrs_b req

734: is
735: l_dummy varchar2(1);
736: begin
737: select 'Y' into l_dummy
738: from qpr_pn_request_hdrs_b req
739: where req.source_ref_hdr_id = p_quote_header_id
740: and req.source_id = p_quote_origin
741: and req.instance_id = p_instance_id
742: and nvl(req.simulation_flag, 'Y') = 'N' ;

Line 758: from qpr_pn_request_hdrs_b req,

754: is
755: l_dummy number;
756: begin
757: select count(*) into l_dummy
758: from qpr_pn_request_hdrs_b req,
759: qpr_pn_response_hdrs res
760: where req.request_header_id = res.request_header_id
761: and req.source_ref_hdr_id = p_quote_header_id
762: and req.source_id = p_quote_origin

Line 790: from qpr_pn_request_hdrs_b req,

786: l_resource_id number;
787: begin
788: select req.source_id, req.source_ref_hdr_id, req.instance_id
789: into l_source_id, l_source_header_id, l_instance_id
790: from qpr_pn_request_hdrs_b req,
791: qpr_pn_response_hdrs res
792: where req.request_header_id = res.request_header_id
793: and res.response_header_id = p_response_hdr_id
794: and nvl(req.request_status, 'ACTIVE') <> 'CANCELLED';

Line 867: from qpr_pn_request_hdrs_b req,

863: begin
864: l_fnd_user := fnd_global.user_name;
865: select req.source_id, req.source_ref_hdr_id, req.instance_id
866: into l_source_id, l_source_header_id, l_instance_id
867: from qpr_pn_request_hdrs_b req,
868: qpr_pn_response_hdrs res
869: where req.request_header_id = res.request_header_id
870: and res.response_header_id = p_response_hdr_id
871: and nvl(req.request_status, 'ACTIVE') <> 'CANCELLED';