139:
140: TYPE war_tbl IS TABLE OF war_rec_type
141: INDEX BY BINARY_INTEGER;
142:
143: TYPE l_line_tbl_type IS TABLE OF oks_extwarprgm_pvt.k_line_service_rec_type
144: INDEX BY BINARY_INTEGER;
145:
146: SUBTYPE l_covlvl_rec IS oks_extwarprgm_pvt.k_line_covered_level_rec_type;
147:
142:
143: TYPE l_line_tbl_type IS TABLE OF oks_extwarprgm_pvt.k_line_service_rec_type
144: INDEX BY BINARY_INTEGER;
145:
146: SUBTYPE l_covlvl_rec IS oks_extwarprgm_pvt.k_line_covered_level_rec_type;
147:
148: TYPE service_rec IS RECORD (
149: order_line_id NUMBER,
150: srv_ref_line_id NUMBER,
389: p_date IN DATE,
390: p_trxn_type IN VARCHAR2,
391: x_available_yn OUT NOCOPY VARCHAR2,
392: x_contract_tbl OUT NOCOPY contract_tbl_type,
393: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
394: --mmadhavi 4174921
395: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
396: x_return_status OUT NOCOPY VARCHAR2
397: );
391: x_available_yn OUT NOCOPY VARCHAR2,
392: x_contract_tbl OUT NOCOPY contract_tbl_type,
393: x_sales_credit_tbl_hdr OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
394: --mmadhavi 4174921
395: x_sales_credit_tbl_line OUT NOCOPY oks_extwarprgm_pvt.salescredit_tbl,
396: x_return_status OUT NOCOPY VARCHAR2
397: );
398:
399: FUNCTION get_k_hdr_id (p_order_hdr_id IN NUMBER)
421: );
422:
423: PROCEDURE get_transfer_detail (
424: p_cpid IN NUMBER,
425: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
426: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
427: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
428: x_return_status OUT NOCOPY VARCHAR2
429: );
422:
423: PROCEDURE get_transfer_detail (
424: p_cpid IN NUMBER,
425: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
426: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
427: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
428: x_return_status OUT NOCOPY VARCHAR2
429: );
430:
423: PROCEDURE get_transfer_detail (
424: p_cpid IN NUMBER,
425: x_hdr_rec OUT NOCOPY oks_extwarprgm_pvt.k_header_rec_type,
426: x_line_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_service_rec_type,
427: x_covd_rec OUT NOCOPY oks_extwarprgm_pvt.k_line_covered_level_rec_type,
428: x_return_status OUT NOCOPY VARCHAR2
429: );
430:
431: PROCEDURE update_timestamp (
434: p_service_line_id IN NUMBER,
435: x_status OUT NOCOPY VARCHAR2
436: );
437:
438: SUBTYPE salescredit_tbl IS oks_extwarprgm_pvt.salescredit_tbl;
439:
440: PROCEDURE salescredit (
441: p_order_line_id IN NUMBER,
442: x_salescredit_tbl OUT NOCOPY salescredit_tbl,
482: );
483:
484: PROCEDURE get_pricing_attributes (
485: p_order_line_id IN NUMBER,
486: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
487: x_return_status OUT NOCOPY VARCHAR2
488: );
489:
490: PROCEDURE get_k_pricing_attributes (
488: );
489:
490: PROCEDURE get_k_pricing_attributes (
491: p_k_line_id IN NUMBER,
492: x_pricing_att OUT NOCOPY oks_extwarprgm_pvt.pricing_attributes_type,
493: x_return_status OUT NOCOPY VARCHAR2
494: );
495:
496: FUNCTION oks_get_party (p_chr_id NUMBER, p_rle_code VARCHAR2)