[Home] [Help]
764: --
765:
766: CURSOR l_parameter_formula_csr IS
767: SELECT *
768: FROM psb_parameter_formulas
769: WHERE parameter_id = l_source_entity_id;
770:
771: --
772: CURSOR l_constraint_formula_csr IS
1343: END IF;-- checking entity subtype
1344:
1345: IF l_create_formula_flag = 'Y' THEN
1346:
1347: SELECT psb_parameter_formulas_s.nextval INTO l_parameter_formula_id
1348: FROM dual;
1349:
1350: debug('Processing formula' || l_para_formula_rec.parameter_formula_id);
1351:
1348: FROM dual;
1349:
1350: debug('Processing formula' || l_para_formula_rec.parameter_formula_id);
1351:
1352: PSB_PARAMETER_FORMULAS_PVT.INSERT_ROW
1353: ( p_api_version => 1.0,
1354: p_init_msg_list => null,
1355: p_commit => null,
1356: p_validation_level => null,
1808: (
1809: SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values
1815: WHERE assgn.entity_set_id = p_source_entity_set_id
1816: and assgn.entity_id = entity.entity_id