APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKC_K_HEADERS_B

Line 377: from okc_k_headers_b chr

373: --avsingh
374: Cursor l_lock_hdr_csr(ChrId IN NUMBER) is
375: Select chr.id,
376: chr.last_update_date
377: from okc_k_headers_b chr
378: where chr.id = ChrId
379: for update of chr.last_update_date nowait;
380:
381: l_chr_id number;

Line 760: FROM okc_k_headers_b khr

756: CURSOR l_bill_to_csr IS
757: SELECT term.printing_lead_days printing_lead_days,
758: khr.cust_acct_id,
759: khr.bill_to_site_use_id
760: FROM okc_k_headers_b khr
761: ,hz_customer_profiles cp
762: ,ra_terms term
763: WHERE khr.id = p_chr_id
764: AND khr.bill_to_site_use_id = cp.site_use_id

Line 1275: CURSOR get_header_terms_id (p_chr_id okc_k_headers_b.id%TYPE, p_rgd_code VARCHAR2) IS

1271: l_terms_id okc_rule_groups_b.id%TYPE;
1272: l_parameter_list WF_PARAMETER_LIST_T;
1273: -- cursor to get the rule group id from the header.
1274: -- if the Lien Terms and Conditions are updated at the contract level, then the cle_id is null
1275: CURSOR get_header_terms_id (p_chr_id okc_k_headers_b.id%TYPE, p_rgd_code VARCHAR2) IS
1276: SELECT id
1277: FROM okc_rule_groups_b
1278: WHERE dnz_chr_id = p_chr_id AND
1279: rgd_code = p_rgd_code AND

Line 1291: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,

1287: AND line.id = p_line_id;
1288:
1289: l_line_style okc_line_styles_b.lty_code%TYPE;
1290:
1291: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
1292: p_line_id okc_k_lines_b.id%TYPE) IS
1293: SELECT rlobj.object1_id1
1294: FROM okc_k_rel_objs_v rlobj
1295: WHERE rlobj.chr_id = p_chr_id

Line 1307: l_serv_contract_id okc_k_headers_b.id%TYPE;

1303: SELECT dnz_chr_id
1304: FROM okc_k_lines_b
1305: WHERE id = p_serv_top_line_id;
1306:
1307: l_serv_contract_id okc_k_headers_b.id%TYPE;
1308:
1309: -- sjalasut: aug 30, 04 added variables to support business events. END
1310:
1311: BEGIN