APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 4683: FROM okc_k_headers_b

4679:
4680: CURSOR get_contract_modifier_cur (p_chr_id NUMBER)
4681: IS
4682: SELECT contract_number_modifier
4683: FROM okc_k_headers_b
4684: WHERE id = p_chr_id;
4685:
4686:
4687: l_target_tbl copy_target_tbl;

Line 4713: l_contract_modifier okc_k_headers_b.contract_number_modifier%TYPE;

4709: l_oie_id okc_operation_instances.id%TYPE;
4710: --ADDED FOR Bug# 2364507
4711: l_select_renewal_flag BOOLEAN;
4712: l_operation_lines_tbl opn_lines_tbl;
4713: l_contract_modifier okc_k_headers_b.contract_number_modifier%TYPE;
4714: l_init_msg_list VARCHAR2(1000);
4715: l_curr_price_negotiated_amt NUMBER;
4716: l_curr_sum_negotiated_amt NUMBER;
4717:

Line 4776: FROM okc_k_headers_b

4772:
4773: CURSOR l_hdr_curr(p_chr_id IN NUMBER)
4774: IS
4775: SELECT currency_code
4776: FROM okc_k_headers_b
4777: WHERE id = p_chr_id;
4778:
4779: l_curr_code VARCHAR2(3);
4780:

Line 5210: UPDATE okc_k_headers_b

5206: );
5207:
5208: --Updating Header with the estimated_amount and cancelled_amount
5209:
5210: UPDATE okc_k_headers_b
5211: SET estimated_amount = l_curr_sum_negotiated_amt,
5212: cancelled_amount = l_curr_sum_cancelled_amt
5213: WHERE id = g_chr_id;
5214:

Line 5664: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;

5660:
5661:
5662: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
5663: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
5664: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
5665: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
5666:
5667: FUNCTION ship_to(p_cle_id IN NUMBER)
5668: RETURN NUMBER

Line 5665: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;

5661:
5662: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
5663: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
5664: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
5665: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
5666:
5667: FUNCTION ship_to(p_cle_id IN NUMBER)
5668: RETURN NUMBER
5669: IS

Line 6167: UPDATE okc_k_headers_b

6163: FOR i IN p_operation_lines_tbl.FIRST..p_operation_lines_tbl.LAST
6164: LOOP
6165: IF p_operation_lines_tbl(i).object_cle_id IS NULL
6166: THEN
6167: UPDATE okc_k_headers_b
6168: SET date_renewed = TRUNC(p_operation_lines_tbl(i).creation_date)
6169: WHERE id = p_operation_lines_tbl(i).object_chr_id;
6170: ELSE
6171: UPDATE okc_k_lines_b

Line 6710: FROM okc_k_headers_b

6706: PROCEDURE Get_Currency_Code(p_chr_id IN NUMBER
6707: , x_curr_code OUT NOCOPY VARCHAR2) IS
6708: CURSOR l_hdr_csr IS
6709: SELECT currency_code
6710: FROM okc_k_headers_b
6711: WHERE id = p_chr_id;
6712: BEGIN
6713: x_curr_code := NULL;
6714: OPEN l_hdr_csr;

Line 6724: l_header_id OKC_K_HEADERS_B.ID%TYPE;

6720: CURSOR l_hdr_csr IS
6721: SELECT dnz_chr_id
6722: FROM okc_k_lines_b
6723: WHERE id = p_contract_line_id;
6724: l_header_id OKC_K_HEADERS_B.ID%TYPE;
6725: BEGIN
6726: OPEN l_hdr_csr;
6727: FETCH l_hdr_csr INTO l_header_id;
6728: CLOSE l_hdr_csr;