2792: p_date IN DATE,
2793: p_trxn_type IN VARCHAR2,
2794: x_available_yn OUT NOCOPY VARCHAR2,
2795: x_contract_tbl OUT NOCOPY contract_tbl_type,
2796: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2797: --mmadhavi 4174921
2798: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2799: x_return_status OUT NOCOPY VARCHAR2
2800: )
2794: x_available_yn OUT NOCOPY VARCHAR2,
2795: x_contract_tbl OUT NOCOPY contract_tbl_type,
2796: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2797: --mmadhavi 4174921
2798: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2799: x_return_status OUT NOCOPY VARCHAR2
2800: )
2801: IS
2802: CURSOR get_hdr_csr (p_code VARCHAR2)
2973:
2974: FOR l_chr_rec IN get_hdr_csr (p_code)
2975: LOOP
2976: l_flag := 'F';
2977: oks_extwarprgm_pvt.get_sts_code (NULL,
2978: l_chr_rec.sts_code,
2979: l_ste_code,
2980: l_sts_code
2981: );
3659:
3660: ----------------------------------------------------------------------*/
3661: PROCEDURE get_transfer_detail (
3662: p_cpid IN NUMBER,
3663: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3664: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3665: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3666: x_return_status OUT NOCOPY VARCHAR2
3667: )
3660: ----------------------------------------------------------------------*/
3661: PROCEDURE get_transfer_detail (
3662: p_cpid IN NUMBER,
3663: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3664: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3665: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3666: x_return_status OUT NOCOPY VARCHAR2
3667: )
3668: IS
3661: PROCEDURE get_transfer_detail (
3662: p_cpid IN NUMBER,
3663: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3664: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3665: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3666: x_return_status OUT NOCOPY VARCHAR2
3667: )
3668: IS
3669: CURSOR cust_csr
4265: END;
4266:
4267: PROCEDURE get_pricing_attributes (
4268: p_order_line_id IN NUMBER,
4269: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
4270: x_return_status OUT NOCOPY VARCHAR2
4271: )
4272: IS
4273: CURSOR l_pricing_att_csr
4356: END;
4357:
4358: PROCEDURE get_k_pricing_attributes (
4359: p_k_line_id IN NUMBER,
4360: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
4361: x_return_status OUT NOCOPY VARCHAR2
4362: )
4363: IS
4364: CURSOR l_pricing_att_csr