APPS.OKL_RULE_EXTRACT_PVT dependencies on OKC_K_LINES_B

Line 723: p_line_id IN OKC_K_LINES_B.ID%TYPE,

719: p_rgd_code IN VARCHAR2,
720: p_rgs_code IN VARCHAR2,
721: p_buy_or_sell IN VARCHAR2,
722: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE,
723: p_line_id IN OKC_K_LINES_B.ID%TYPE,
724: p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE,
725: p_template_table IN VARCHAR2,
726: p_rule_id_column IN VARCHAR2,
727: p_entity_column IN VARCHAR2,

Line 743: l_line_id OKC_K_LINES_B.ID%TYPE := p_line_id;

739: l_object_code VARCHAR2(240) default null;
740: l_object_code1 VARCHAR2(240) default null;
741:
742: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_contract_id;
743: l_line_id OKC_K_LINES_B.ID%TYPE := p_line_id;
744: l_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE := p_party_id;
745: process_type VARCHAR2(30) := '';
746: x_name VARCHAR2(3000);
747: x_desc VARCHAR2(3000);

Line 766: P_LINE_ID IN OKC_K_LINES_B.ID%TYPE,

762: AND RG.ID = RL.RGP_ID
763: AND RL.RULE_INFORMATION_CATEGORY = P_RULE_CODE;
764:
765: CURSOR LINE_RULE_CSR(P_CONTRACT_ID IN OKC_K_HEADERS_B.ID%TYPE,
766: P_LINE_ID IN OKC_K_LINES_B.ID%TYPE,
767: P_RGD_CODE IN VARCHAR2, P_RULE_CODE IN VARCHAR2) IS
768: SELECT RL.*
769: FROM OKC_RULE_GROUPS_B RG, OKC_RULES_B RL
770: WHERE RG.DNZ_CHR_ID = P_CONTRACT_ID