APPS.OKC_CONTRACT_PVT dependencies on OKC_PH_LINE_BREAKS

Line 1729: Cursor l_okc_ph_line_breaks_v_csr Is

1725: SELECT id, object_version_number, dnz_chr_id
1726: FROM okc_k_sales_credits
1727: WHERE cle_id = p_clev_rec.id;
1728:
1729: Cursor l_okc_ph_line_breaks_v_csr Is
1730: SELECT id, object_version_number, cle_id
1731: FROM okc_ph_line_breaks
1732: WHERE cle_id = p_clev_rec.id;
1733:

Line 1731: FROM okc_ph_line_breaks

1727: WHERE cle_id = p_clev_rec.id;
1728:
1729: Cursor l_okc_ph_line_breaks_v_csr Is
1730: SELECT id, object_version_number, cle_id
1731: FROM okc_ph_line_breaks
1732: WHERE cle_id = p_clev_rec.id;
1733:
1734: -- Bug #3358872; Added condition dnz_chr_id to improve the
1735: -- performance of the sql.

Line 1750: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;

1746:
1747: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;
1748:
1749:
1750: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
1751: l_lse_id NUMBER; --linestyle
1752: l_dnz_chr_id NUMBER;
1753: l_ph_pricing_type VARCHAR2(30);
1754:

Line 1889: For c In l_okc_ph_line_breaks_v_csr

1885: IF l_ph_pricing_type = 'PRICE_BREAK' THEN
1886: --if the contract line being deleted is a Price Hold sub line with pricing type of 'Price Break'
1887: --we need to delete the price hold line breaks as well
1888:
1889: For c In l_okc_ph_line_breaks_v_csr
1890: Loop
1891: l_okc_ph_line_breaks_v_rec.id := c.id;
1892: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1893: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;

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

1887: --we need to delete the price hold line breaks as well
1888:
1889: For c In l_okc_ph_line_breaks_v_csr
1890: Loop
1891: l_okc_ph_line_breaks_v_rec.id := c.id;
1892: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1893: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1894:
1895: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(

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

1888:
1889: For c In l_okc_ph_line_breaks_v_csr
1890: Loop
1891: l_okc_ph_line_breaks_v_rec.id := c.id;
1892: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1893: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1894:
1895: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1896: p_api_version => p_api_version,

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

1889: For c In l_okc_ph_line_breaks_v_csr
1890: Loop
1891: l_okc_ph_line_breaks_v_rec.id := c.id;
1892: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1893: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1894:
1895: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1896: p_api_version => p_api_version,
1897: p_init_msg_list => p_init_msg_list,

Line 1895: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(

1891: l_okc_ph_line_breaks_v_rec.id := c.id;
1892: l_okc_ph_line_breaks_v_rec.object_version_number := c.object_version_number;
1893: l_okc_ph_line_breaks_v_rec.cle_id := c.cle_id;
1894:
1895: OKC_PH_LINE_BREAKS_PUB.delete_Price_Hold_Line_Breaks(
1896: p_api_version => p_api_version,
1897: p_init_msg_list => p_init_msg_list,
1898: x_return_status => x_return_status,
1899: x_msg_count => x_msg_count,

Line 1901: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec

1897: p_init_msg_list => p_init_msg_list,
1898: x_return_status => x_return_status,
1899: x_msg_count => x_msg_count,
1900: x_msg_data => x_msg_data,
1901: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec
1902: );
1903: End Loop;
1904: End If;
1905: