[Home] [Help]
16: p_rule_code OKC_RULE_DEFS_B.rule_code%TYPE;
17: p_appl_id OKC_RULE_DEFS_B.application_id%TYPE;
18: p_dff_name OKC_RULE_DEFS_B.descriptive_flexfield_name%TYPE;
19:
20: PROCEDURE Set_QA_Message(p_chr_id IN OKC_K_LINES_V.chr_id%TYPE,
21: p_cle_id IN OKC_K_LINES_V.id%TYPE,
22: p_msg_name IN VARCHAR2,
23: p_token1 IN VARCHAR2 DEFAULT NULL,
24: p_token1_value IN VARCHAR2 DEFAULT NULL,
17: p_appl_id OKC_RULE_DEFS_B.application_id%TYPE;
18: p_dff_name OKC_RULE_DEFS_B.descriptive_flexfield_name%TYPE;
19:
20: PROCEDURE Set_QA_Message(p_chr_id IN OKC_K_LINES_V.chr_id%TYPE,
21: p_cle_id IN OKC_K_LINES_V.id%TYPE,
22: p_msg_name IN VARCHAR2,
23: p_token1 IN VARCHAR2 DEFAULT NULL,
24: p_token1_value IN VARCHAR2 DEFAULT NULL,
25: p_token2 IN VARCHAR2 DEFAULT NULL,
185: RTRIM(clev.name)) "LINE_NAME", currency_code,
186: clev.lse_id, --bug 2398639
187: clev.cle_id --bug 2398639
188: FROM OKC_LINE_STYLES_V lsev,
189: OKC_K_LINES_V clev
190: WHERE lsev.id = clev.lse_id
191: AND clev.dnz_chr_id = p_chr_id
192: AND clev.date_cancelled is NULL; --changes [llc]--
193:
193:
194:
195: --l_clev_rec l_clev_csr%ROWTYPE;
196:
197: TYPE chr15_tbl_type IS TABLE OF okc_k_lines_v.currency_code%TYPE INDEX BY BINARY_INTEGER;
198: TYPE chr450_tbl_type IS TABLE OF VARCHAR2(450) INDEX BY BINARY_INTEGER;
199: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
200:
201: l_line_name_tbl chr450_tbl_type;
1678: CURSOR l_clev_csr (p_cle_id NUMBER) IS
1679: SELECT Rtrim(Rtrim(cle.line_number) || ', ' || lse.name ||
1680: ' ' || cle.name) "LINE_NAME"
1681: FROM OKC_LINE_STYLES_TL lse,
1682: OKC_K_LINES_V cle
1683: WHERE cle.id = p_cle_id
1684: and lse.id = cle.lse_id
1685: and lse.language = userenv('LANG');
1686: