APPS.OKC_OC_INT_KTQ_PVT dependencies on OKX_QUOTE_HEADERS_V

Line 199: FROM okx_quote_headers_v

195: --
196: CURSOR c_qhr(b_qhr_id NUMBER) IS
197: SELECT quote_number
198: ,quote_version
199: FROM okx_quote_headers_v
200: WHERE id1 = b_qhr_id;
201:
202: --
203: -- cursor for contract header information

Line 739: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE

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: )
741: IS
742: BEGIN
743:

Line 1286: p_qh_id IN okx_quote_headers_v.id1%TYPE,

1282: --
1283: --
1284: FUNCTION is_kl_linked_to_ql(p_chr_id IN NUMBER,
1285: p_cle_id IN okc_k_lines_b.id%TYPE,
1286: p_qh_id IN okx_quote_headers_v.id1%TYPE,
1287: p_rlt_code IN VARCHAR2,
1288: p_rlt_type IN VARCHAR2
1289: ) RETURN VARCHAR2 IS
1290:

Line 1315: ,p_quote_id IN okx_quote_headers_v.id1%TYPE

1311: --
1312: -- Out Parameters: x_return_status standard return status
1313:
1314: PROCEDURE validate_k_eligibility( p_k_header_rec IN c_k_header%ROWTYPE
1315: ,p_quote_id IN okx_quote_headers_v.id1%TYPE
1316: ,x_return_status OUT NOCOPY VARCHAR2
1317: ) IS
1318:
1319: --

Line 1325: FROM okx_quote_headers_v

1321: --
1322:
1323: CURSOR c_qh_expiration(b_qh_id NUMBER) IS
1324: SELECT quote_expiration_date
1325: FROM okx_quote_headers_v
1326: WHERE id1 = b_qh_id;
1327:
1328: e_exit exception;
1329: e_exit2 exception;

Line 1333: l_quot_exp_date okx_quote_headers_v.quote_expiration_date%TYPE;

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
1337:

Line 1499: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

Line 2507: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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
2511:

Line 2540: okx_quote_headers_v

2536: quote_number
2537: -- status,
2538: -- b_status status_code
2539: FROM
2540: okx_quote_headers_v
2541: WHERE
2542: id1 = b_qh_id;
2543: */
2544:

Line 2551: okx_quote_headers_v

2547: id1 quote_header_id,
2548: quote_number,
2549: last_update_date
2550: FROM
2551: okx_quote_headers_v
2552: WHERE
2553: id1=b_qh_id;
2554:
2555: l_qte_hdr c_qte_hdr%ROWTYPE;

Line 3934: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

3930: -- p_quote_id Id of quote to be renewed
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