APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_K_LINES_V

Line 4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;

4630: WHERE id = p_id;
4631:
4632: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4635:
4636:
4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)
4638: IS

Line 4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)

4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4635:
4636:
4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)
4638: IS
4639: tbl_index NUMBER := 1;
4640: CURSOR sll_cur(p_cle_id IN NUMBER) IS
4641: SELECT id

Line 4664: FROM OKS_K_LINES_V

4660: WHERE cle_id = p_cle_id;
4661:
4662: CURSOR get_bill_type_cur(p_cle_id IN NUMBER) IS
4663: SELECT billing_schedule_type
4664: FROM OKS_K_LINES_V
4665: WHERE cle_id = p_cle_id;
4666:
4667: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4668:

Line 4667: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;

4663: SELECT billing_schedule_type
4664: FROM OKS_K_LINES_V
4665: WHERE cle_id = p_cle_id;
4666:
4667: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4668:
4669: BEGIN
4670:
4671: OPEN get_bill_type_cur(p_cle_id);

Line 4873: FROM OKS_K_LINES_V

4869:
4870: CURSOR l_get_kln_id(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4871: IS
4872: SELECT id, object_version_number
4873: FROM OKS_K_LINES_V
4874: WHERE dnz_chr_id = p_dnz_chr_id
4875: AND cle_id = p_cle_id;
4876:
4877: /** Get tax values for each line for given contract id **/

Line 4881: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4877: /** Get tax values for each line for given contract id **/
4878: CURSOR l_get_tot_tax(p_dnz_chr_id IN NUMBER)
4879: IS
4880: SELECT cle.id, SUM(kln.tax_amount)
4881: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4882: WHERE cle.dnz_chr_id = p_dnz_chr_id
4883: AND cle.cle_id IS NULL
4884: AND kln.cle_id = cle.id;
4885:

Line 4891: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4887: /*** Get sum of taxes at subline level **/
4888: CURSOR l_get_tot_tax_subline(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4889: IS
4890: SELECT MAX(kln.tax_amount)
4891: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4892: WHERE cle.dnz_chr_id = p_dnz_chr_id
4893: AND cle.cle_id = p_cle_id
4894: AND kln.cle_id = cle.id;
4895:

Line 4903: l_kln_id OKS_K_LINES_V.id%TYPE;

4899: l_msg_data VARCHAR2(2000);
4900:
4901: l_object_version_number NUMBER;
4902: l_khr_id OKS_K_HEADERS_V.id%TYPE;
4903: l_kln_id OKS_K_LINES_V.id%TYPE;
4904: l_validate_yn VARCHAR2(1);
4905: --BUG#4066428 hkamdar 01/21/05 added object_version_number
4906: l_hdr_object_ver_num OKS_K_HEADERS_V.object_version_number%TYPE;
4907: