APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_K_LINES_V

Line 4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;

4090: WHERE id = p_id;
4091:
4092: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4095:
4096:
4097: 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)
4098: IS

Line 4097: 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)

4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4095:
4096:
4097: 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)
4098: IS
4099: tbl_index NUMBER := 1;
4100: CURSOR sll_cur(p_cle_id IN NUMBER) IS
4101: SELECT id

Line 4124: FROM OKS_K_LINES_V

4120: WHERE cle_id = p_cle_id;
4121:
4122: CURSOR get_bill_type_cur(p_cle_id IN NUMBER) IS
4123: SELECT billing_schedule_type
4124: FROM OKS_K_LINES_V
4125: WHERE cle_id = p_cle_id;
4126:
4127: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4128:

Line 4127: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;

4123: SELECT billing_schedule_type
4124: FROM OKS_K_LINES_V
4125: WHERE cle_id = p_cle_id;
4126:
4127: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4128:
4129: BEGIN
4130:
4131: OPEN get_bill_type_cur(p_cle_id);

Line 4333: FROM OKS_K_LINES_V

4329:
4330: CURSOR l_get_kln_id(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4331: IS
4332: SELECT id, object_version_number
4333: FROM OKS_K_LINES_V
4334: WHERE dnz_chr_id = p_dnz_chr_id
4335: AND cle_id = p_cle_id;
4336:
4337: /** Get tax values for each line for given contract id **/

Line 4341: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4337: /** Get tax values for each line for given contract id **/
4338: CURSOR l_get_tot_tax(p_dnz_chr_id IN NUMBER)
4339: IS
4340: SELECT cle.id, SUM(kln.tax_amount)
4341: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4342: WHERE cle.dnz_chr_id = p_dnz_chr_id
4343: AND cle.cle_id IS NULL
4344: AND kln.cle_id = cle.id;
4345:

Line 4351: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4347: /*** Get sum of taxes at subline level **/
4348: CURSOR l_get_tot_tax_subline(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4349: IS
4350: SELECT MAX(kln.tax_amount)
4351: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4352: WHERE cle.dnz_chr_id = p_dnz_chr_id
4353: AND cle.cle_id = p_cle_id
4354: AND kln.cle_id = cle.id;
4355:

Line 4363: l_kln_id OKS_K_LINES_V.id%TYPE;

4359: l_msg_data VARCHAR2(2000);
4360:
4361: l_object_version_number NUMBER;
4362: l_khr_id OKS_K_HEADERS_V.id%TYPE;
4363: l_kln_id OKS_K_LINES_V.id%TYPE;
4364: l_validate_yn VARCHAR2(1);
4365: --BUG#4066428 hkamdar 01/21/05 added object_version_number
4366: l_hdr_object_ver_num OKS_K_HEADERS_V.object_version_number%TYPE;
4367: