APPS.CN_SCA_CRRULEATTR_PVT dependencies on CN_SCA_RULE_ATTRIBUTES_S

Line 284: l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE :=0;

280: L_PROGRAM_TYPE VARCHAR2(30);
281: L_SECURITY_GROUP_ID NUMBER ;
282: l_credit_rule_attr_rec credit_rule_attr_rec;
283: l_value_set_id NUMBER;
284: l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE :=0;
285:
286:
287: /*-- CURSOR get_value_set_id IS
288: -- SELECT nvl(flex_value_set_id,0)

Line 365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;

361:
362: RAISE FND_API.G_EXC_ERROR;
363: END IF ;
364:
365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
366: -- API body
367:
368:
369: CN_SCA_CRRULEATTR_PKG.INSERT_ROW(

Line 511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;

507: l_end_date DATE;
508: l_null_date CONSTANT DATE := to_date('31-12-3000','DD-MM-YYYY');
509: l_dummy NUMBER;
510: l_old_ovn NUMBER;
511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;
512: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;
514:
515: -- CURSOR get_value_set_id IS