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.OKC_CONTRACT_PVT dependencies on OKC_PH_LINE_BREAKS

Line 1787: Cursor l_okc_ph_line_breaks_v_csr Is

1783: SELECT id, object_version_number, dnz_chr_id
1784: FROM okc_k_sales_credits
1785: WHERE cle_id = p_clev_rec.id;
1786:
1787: Cursor l_okc_ph_line_breaks_v_csr Is
1788: SELECT id, object_version_number, cle_id
1789: FROM okc_ph_line_breaks
1790: WHERE cle_id = p_clev_rec.id;
1791:

Line 1789: FROM okc_ph_line_breaks

1785: WHERE cle_id = p_clev_rec.id;
1786:
1787: Cursor l_okc_ph_line_breaks_v_csr Is
1788: SELECT id, object_version_number, cle_id
1789: FROM okc_ph_line_breaks
1790: WHERE cle_id = p_clev_rec.id;
1791:
1792: -- Bug #3358872; Added condition dnz_chr_id to improve the
1793: -- performance of the sql.

Line 1808: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;

1804:
1805: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;
1806:
1807:
1808: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
1809: l_lse_id NUMBER; --linestyle
1810: l_dnz_chr_id NUMBER;
1811: l_ph_pricing_type VARCHAR2(30);
1812:

Line 1947: For c In l_okc_ph_line_breaks_v_csr

1943: IF l_ph_pricing_type = 'PRICE_BREAK' THEN
1944: --if the contract line being deleted is a Price Hold sub line with pricing type of 'Price Break'
1945: --we need to delete the price hold line breaks as well
1946:
1947: For c In l_okc_ph_line_breaks_v_csr
1948: Loop
1949: l_okc_ph_line_breaks_v_rec.id := c.id;
1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;

Line 1949: l_okc_ph_line_breaks_v_rec.id := c.id;

1945: --we need to delete the price hold line breaks as well
1946:
1947: For c In l_okc_ph_line_breaks_v_csr
1948: Loop
1949: l_okc_ph_line_breaks_v_rec.id := c.id;
1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1952:
1953: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(

Line 1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;

1946:
1947: For c In l_okc_ph_line_breaks_v_csr
1948: Loop
1949: l_okc_ph_line_breaks_v_rec.id := c.id;
1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1952:
1953: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1954: p_api_version => p_api_version,

Line 1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;

1947: For c In l_okc_ph_line_breaks_v_csr
1948: Loop
1949: l_okc_ph_line_breaks_v_rec.id := c.id;
1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1952:
1953: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1954: p_api_version => p_api_version,
1955: p_init_msg_list => p_init_msg_list,

Line 1953: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(

1949: l_okc_ph_line_breaks_v_rec.id := c.id;
1950: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1951: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1952:
1953: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1954: p_api_version => p_api_version,
1955: p_init_msg_list => p_init_msg_list,
1956: x_return_status => x_return_status,
1957: x_msg_count => x_msg_count,

Line 1959: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec

1955: p_init_msg_list => p_init_msg_list,
1956: x_return_status => x_return_status,
1957: x_msg_count => x_msg_count,
1958: x_msg_data => x_msg_data,
1959: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec
1960: );
1961: End Loop;
1962: End If;
1963: