2838: p_date IN DATE,
2839: p_trxn_type IN VARCHAR2,
2840: x_available_yn OUT NOCOPY VARCHAR2,
2841: x_contract_tbl OUT NOCOPY contract_tbl_type,
2842: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2843: --mmadhavi 4174921
2844: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2845: x_return_status OUT NOCOPY VARCHAR2
2846: )
2840: x_available_yn OUT NOCOPY VARCHAR2,
2841: x_contract_tbl OUT NOCOPY contract_tbl_type,
2842: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2843: --mmadhavi 4174921
2844: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
2845: x_return_status OUT NOCOPY VARCHAR2
2846: )
2847: IS
2848: CURSOR get_hdr_csr (p_code VARCHAR2)
3019:
3020: FOR l_chr_rec IN get_hdr_csr (p_code)
3021: LOOP
3022: l_flag := 'F';
3023: oks_extwarprgm_pvt.get_sts_code (NULL,
3024: l_chr_rec.sts_code,
3025: l_ste_code,
3026: l_sts_code
3027: );
3705:
3706: ----------------------------------------------------------------------*/
3707: PROCEDURE get_transfer_detail (
3708: p_cpid IN NUMBER,
3709: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3710: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3711: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3712: x_return_status OUT NOCOPY VARCHAR2
3713: )
3706: ----------------------------------------------------------------------*/
3707: PROCEDURE get_transfer_detail (
3708: p_cpid IN NUMBER,
3709: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3710: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3711: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3712: x_return_status OUT NOCOPY VARCHAR2
3713: )
3714: IS
3707: PROCEDURE get_transfer_detail (
3708: p_cpid IN NUMBER,
3709: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
3710: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
3711: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
3712: x_return_status OUT NOCOPY VARCHAR2
3713: )
3714: IS
3715: CURSOR cust_csr
4311: END;
4312:
4313: PROCEDURE get_pricing_attributes (
4314: p_order_line_id IN NUMBER,
4315: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
4316: x_return_status OUT NOCOPY VARCHAR2
4317: )
4318: IS
4319: CURSOR l_pricing_att_csr
4402: END;
4403:
4404: PROCEDURE get_k_pricing_attributes (
4405: p_k_line_id IN NUMBER,
4406: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
4407: x_return_status OUT NOCOPY VARCHAR2
4408: )
4409: IS
4410: CURSOR l_pricing_att_csr