APPS.QPR_DEAL_ETL dependencies on QPR_PN_INT_HEADERS

Line 751: from qpr_pn_int_headers

747: p_response_id out nocopy number,
748: p_is_deal_compliant out nocopy varchar2) is
749: cursor c_int_header is
750: select *
751: from qpr_pn_int_headers
752: where pn_int_header_id = p_int_header_id;
753:
754: cursor c_int_lines(p_src_id number) is
755: select *

Line 1553: select * from qpr_pn_int_headers

1549: and source_id = p_src_id
1550: and pn_req_line_status_flag = 'I';
1551:
1552: cursor c_int_hdr is
1553: select * from qpr_pn_int_headers
1554: where pn_int_header_id = p_pn_int_hdr_id
1555: and instance_id = l_deal_instance
1556: and rownum < 2;
1557:

Line 1795: from qpr_pn_int_headers

1791: t_src_id num_type;
1792:
1793: cursor i_header is
1794: select source_ref_header_id, pn_int_header_id, instance_id, source_id
1795: from qpr_pn_int_headers
1796: where request_id = l_request_id;
1797:
1798: l_count_lines number := 0;
1799:

Line 1805: update qpr_pn_int_headers rih

1801: log_debug('Starting..');
1802:
1803: l_request_id := fnd_global.conc_request_id;
1804:
1805: update qpr_pn_int_headers rih
1806: set rih.request_id = l_request_id
1807: where rih.source_ref_header_id between
1808: nvl(f_source_ref_id, rih.source_ref_header_id)
1809: and nvl(t_source_ref_id, rih.source_ref_header_id)

Line 1855: update qpr_pn_int_headers

1851: end if;
1852: if nvl(retcode, 0) = 2 then
1853: rollback to deal_processing;
1854:
1855: update qpr_pn_int_headers
1856: set request_id = null,
1857: pn_req_header_status_flag = 'F'
1858: where pn_int_header_id = t_pn_int_hdr(i);
1859:

Line 1863: delete qpr_pn_int_headers where pn_int_header_id = t_pn_int_hdr(i);

1859:
1860: commit;
1861:
1862: else
1863: delete qpr_pn_int_headers where pn_int_header_id = t_pn_int_hdr(i);
1864:
1865: delete qpr_pn_int_lines where source_ref_hdr_id = t_src_hdr_id(i)
1866: and source_id = t_src_id(i);
1867:

Line 1905: from qpr_pn_int_headers

1901: l_count_lines number := 0;
1902:
1903: cursor i_header is
1904: select source_ref_header_id, pn_int_header_id, instance_id
1905: from qpr_pn_int_headers
1906: where source_ref_header_id = p_quote_header_id
1907: and source_id = p_source_id
1908: and instance_id = p_instance_id
1909: and pn_req_header_status_flag = 'I'

Line 1971: delete qpr_pn_int_headers where pn_int_header_id = l_pn_int_hdr;

1967: end if;
1968: end loop;
1969: end if;
1970:
1971: delete qpr_pn_int_headers where pn_int_header_id = l_pn_int_hdr;
1972:
1973: delete qpr_pn_int_lines where source_ref_hdr_id = l_src_hdr_id
1974: and source_id = p_source_id;
1975: