APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 5224: FROM okc_k_headers_b

5220:
5221: CURSOR get_contract_modifier_cur (p_chr_id NUMBER)
5222: IS
5223: SELECT contract_number_modifier
5224: FROM okc_k_headers_b
5225: WHERE id = p_chr_id;
5226:
5227:
5228: l_target_tbl copy_target_tbl;

Line 5254: l_contract_modifier okc_k_headers_b.contract_number_modifier%TYPE;

5250: l_oie_id okc_operation_instances.id%TYPE;
5251: --ADDED FOR Bug# 2364507
5252: l_select_renewal_flag BOOLEAN;
5253: l_operation_lines_tbl opn_lines_tbl;
5254: l_contract_modifier okc_k_headers_b.contract_number_modifier%TYPE;
5255: l_init_msg_list VARCHAR2(1000);
5256: l_curr_price_negotiated_amt NUMBER;
5257: l_curr_sum_negotiated_amt NUMBER;
5258:

Line 5317: FROM okc_k_headers_b

5313:
5314: CURSOR l_hdr_curr(p_chr_id IN NUMBER)
5315: IS
5316: SELECT currency_code
5317: FROM okc_k_headers_b
5318: WHERE id = p_chr_id;
5319:
5320: l_curr_code VARCHAR2(3);
5321:

Line 5824: UPDATE okc_k_headers_b

5820: );
5821:
5822: --Updating Header with the estimated_amount and cancelled_amount
5823:
5824: UPDATE okc_k_headers_b
5825: SET estimated_amount = l_curr_sum_negotiated_amt,
5826: cancelled_amount = l_curr_sum_cancelled_amt
5827: WHERE id = g_chr_id;
5828:

Line 6278: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;

6274:
6275:
6276: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
6277: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
6278: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
6279: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
6280:
6281: FUNCTION ship_to(p_cle_id IN NUMBER)
6282: RETURN NUMBER

Line 6279: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;

6275:
6276: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
6277: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
6278: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
6279: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
6280:
6281: FUNCTION ship_to(p_cle_id IN NUMBER)
6282: RETURN NUMBER
6283: IS

Line 6787: UPDATE okc_k_headers_b

6783: FOR i IN p_operation_lines_tbl.FIRST..p_operation_lines_tbl.LAST
6784: LOOP
6785: IF p_operation_lines_tbl(i).object_cle_id IS NULL
6786: THEN
6787: UPDATE okc_k_headers_b
6788: SET date_renewed = TRUNC(p_operation_lines_tbl(i).creation_date)
6789: WHERE id = p_operation_lines_tbl(i).object_chr_id;
6790: ELSE
6791: UPDATE okc_k_lines_b

Line 7352: FROM okc_k_headers_b

7348: PROCEDURE Get_Currency_Code(p_chr_id IN NUMBER
7349: , x_curr_code OUT NOCOPY VARCHAR2) IS
7350: CURSOR l_hdr_csr IS
7351: SELECT currency_code
7352: FROM okc_k_headers_b
7353: WHERE id = p_chr_id;
7354: BEGIN
7355: x_curr_code := NULL;
7356: OPEN l_hdr_csr;

Line 7366: l_header_id OKC_K_HEADERS_B.ID%TYPE;

7362: CURSOR l_hdr_csr IS
7363: SELECT dnz_chr_id
7364: FROM okc_k_lines_b
7365: WHERE id = p_contract_line_id;
7366: l_header_id OKC_K_HEADERS_B.ID%TYPE;
7367: BEGIN
7368: OPEN l_hdr_csr;
7369: FETCH l_hdr_csr INTO l_header_id;
7370: CLOSE l_hdr_csr;