[Home] [Help]
195:
196:
197: l_tmp_lvl_mandatory_flag varchar2(1);
198:
199: TYPE outcome_rec_type IS RECORD (clause_id NUMBER,mandatory_yn OKC_XPRT_RULE_OUTCOMES.mandatory_yn%TYPE
200: , mandatory_rwa OKC_XPRT_RULE_OUTCOMES.mandatory_rwa%type);
201:
202: TYPE outcome_tbl_type IS TABLE OF outcome_rec_type INDEX BY PLS_INTEGER;
203:
196:
197: l_tmp_lvl_mandatory_flag varchar2(1);
198:
199: TYPE outcome_rec_type IS RECORD (clause_id NUMBER,mandatory_yn OKC_XPRT_RULE_OUTCOMES.mandatory_yn%TYPE
200: , mandatory_rwa OKC_XPRT_RULE_OUTCOMES.mandatory_rwa%type);
201:
202: TYPE outcome_tbl_type IS TABLE OF outcome_rec_type INDEX BY PLS_INTEGER;
203:
204: TYPE clause_id_tbl_type IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
267: AND rule.rule_type = ruletypelkup.lookup_code
268: AND org_id = l_org_id
269: AND intent = l_intent
270: AND org_wide_flag = 'Y') rule,
271: okc_xprt_rule_outcomes outcome
272: WHERE outcome.rule_id = rule.rule_id
273: AND outcome.object_type = 'CLAUSE';
274:
275: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN