[Home] [Help]
214: ,scs_code
215: ,total_line_list_price
216: ,price_list_id
217: ,sign_by_date
218: FROM okc_k_headers_b
219: WHERE id = b_chr_id;
220:
221: CURSOR c_k_header(b_chr_id NUMBER) IS
222: SELECT
244: ks.cls_code ,
245: ks.meaning ,
246: kst.ste_code
247: FROM okc_statuses_b kst,
248: okc_k_headers_b kh,
249: okc_k_headers_b kh2,
250: okc_subclasses_v ks
251: WHERE kh.id = b_chr_id
252: AND ks.code = kh.scs_code
245: ks.meaning ,
246: kst.ste_code
247: FROM okc_statuses_b kst,
248: okc_k_headers_b kh,
249: okc_k_headers_b kh2,
250: okc_subclasses_v ks
251: WHERE kh.id = b_chr_id
252: AND ks.code = kh.scs_code
253: AND kst.code = kh.sts_code
626: -- table to hold the rules at a contract header level
627: --
628: TYPE rule_rec_typ IS RECORD
629: (
630: chr_id okc_k_headers_b.id%TYPE,
631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
648:
649:
650: TYPE bto_sto_rec_typ IS RECORD
651: (
652: chr_id okc_k_headers_b.id%TYPE,
653: cle_id okc_k_lines_b.id%TYPE,
654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
731: ,x_return_status OUT NOCOPY VARCHAR2
732: ,x_msg_count OUT NOCOPY NUMBER
733: ,x_msg_data OUT NOCOPY VARCHAR2
734: --
735: ,p_contract_id IN okc_k_headers_b.ID%TYPE
736: ,p_rel_type IN okc_k_rel_objs.rty_code%TYPE
737: --
738: ,p_trace_mode IN VARCHAR2
739: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
788: -- x_rule_tab Table of rule info except shipto and billto
789: -- x_bto_data_tab Table of billto rule info
790: -- x_sto_data_tab Table of shipto rule info
791: --
792: PROCEDURE build_k_rules( p_chr_id IN okc_k_headers_b.ID%TYPE,
793: p_cle_id IN okc_k_lines_v.id%TYPE,
794: x_rule_tab OUT NOCOPY rule_tbl_typ,
795: x_bto_data_rec OUT NOCOPY bto_sto_rec_typ,
796: x_sto_data_rec OUT NOCOPY bto_sto_rec_typ,
1494: -- used to pass to ASO APIs
1495: -- In Parameters: p_chr_id contract id
1496: -- Out Parameters: x_return_status standard return status
1497:
1498: PROCEDURE build_k_structures (p_chr_id IN okc_k_headers_b.ID%TYPE
1499: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1500: ,p_rel_code IN okc_k_rel_objs.rty_code%TYPE
1501: ,p_k_header_rec IN c_k_header%ROWTYPE
1502: ,x_return_status OUT NOCOPY VARCHAR2
2502: -- In/Out Parameters: px_qte_hdr_rec - the record to pass to ASO
2503:
2504: PROCEDURE build_qte_hdr(px_qte_hdr_rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_header_rec_type
2505: ,px_hd_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.shipment_tbl_type
2506: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2507: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
2508: ,p_rel_code IN OKC_K_REL_OBJS.rty_code%TYPE
2509: ,x_return_status OUT NOCOPY VARCHAR2
2510: ) IS
2786: -- px_qte_ln_shipment_tbl contains the shipment information
2787: --
2788: --
2789: PROCEDURE build_qte_line (
2790: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type
2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
3931: --
3932: PROCEDURE update_quote_from_k( p_api_version IN NUMBER
3933: ,p_init_msg_list IN VARCHAR2
3934: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
3935: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
3936: ,p_trace_mode IN VARCHAR2
3937: ,x_return_status OUT NOCOPY VARCHAR2
3938: ,x_msg_count OUT NOCOPY NUMBER
3939: ,x_msg_data OUT NOCOPY VARCHAR2