APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_K_REL_OBJS

Line 526: okc_k_rel_objs krel

522: b_rlt_code VARCHAR, b_rlt_type VARCHAR) IS
523: SELECT
524: krel.object1_id1
525: FROM
526: okc_k_rel_objs krel
527: WHERE
528: krel.chr_id = b_kh_id
529: AND ((krel.cle_id IS NULL AND b_kl_id IS NULL
530: AND krel.object1_id1 = DECODE(NVL(b_qh_id,OKC_API.G_MISS_NUM),OKC_API.G_MISS_NUM, krel.object1_id1, b_qh_id))

Line 703: p_rel_code okc_k_rel_objs.rty_code%TYPE ;

699: l_covlvl_info_tab covlvl_info_tab_typ;
700:
701: l_ktq_flag VARCHAR2(1) ;
702:
703: p_rel_code okc_k_rel_objs.rty_code%TYPE ;
704:
705: --
706: l_cust c_cust%ROWTYPE;
707: l_customer c_cust%ROWTYPE;

Line 736: ,p_rel_type IN okc_k_rel_objs.rty_code%TYPE

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
740: )

Line 1292: l_object_id1 okc_k_rel_objs.object1_id1%TYPE;

1288: p_rlt_type IN VARCHAR2
1289: ) RETURN VARCHAR2 IS
1290:
1291: l_retval VARCHAR2(1) := OKC_API.G_TRUE;
1292: l_object_id1 okc_k_rel_objs.object1_id1%TYPE;
1293:
1294: BEGIN
1295: OPEN c_q_k_rel(p_chr_id,p_cle_id,p_qh_id,p_rlt_code,p_rlt_type);
1296: FETCH c_q_k_rel INTO l_object_id1;

Line 1332: l_object_id1 okc_k_rel_objs.object1_id1%TYPE;

1328: e_exit exception;
1329: e_exit2 exception;
1330: l_msg_count NUMBER := 0;
1331: l_msg_data VARCHAR2(1000);
1332: l_object_id1 okc_k_rel_objs.object1_id1%TYPE;
1333: l_quot_exp_date okx_quote_headers_v.quote_expiration_date%TYPE;
1334:
1335:
1336: BEGIN

Line 1500: ,p_rel_code IN okc_k_rel_objs.rty_code%TYPE

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
1503: ) IS
1504:

Line 2508: ,p_rel_code IN OKC_K_REL_OBJS.rty_code%TYPE

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
2511:
2512: e_exit exception; -- used to exit processing

Line 2822: l_quote_line_id okc_k_rel_objs.object1_id1%TYPE;

2818: l_id1 okx_quote_line_detail_v.id1%TYPE;
2819: --
2820: l_k_ship_found VARCHAR2(1) := 'N';
2821: l_value VARCHAR2(1) := 'N';
2822: l_quote_line_id okc_k_rel_objs.object1_id1%TYPE;
2823: l_qt_found VARCHAR2(1) := 'N';
2824: l_k2q_found VARCHAR2(1) := 'N';
2825: l_qdl_a_found VARCHAR2(1) := 'N';
2826: l_qdl_b_found VARCHAR2(1) := 'N';