APPS.CN_SCA_RULES_ONLINE_GEN_PVT dependencies on CN_SCA_RULE_ATTRIBUTES

Line 274: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)

270:
271: -- create the code of the procedure get_winning rule
272: PROCEDURE get_winning_rule (spec_code IN OUT NOCOPY cn_utils.code_type,
273: body_code IN OUT NOCOPY cn_utils.code_type ,
274: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
275: IS
276: procedure_name cn_obj_procedures_v.name%TYPE;
277: procedure_desc cn_obj_procedures_v.description%TYPE;
278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

Line 285: CURSOR cn_sca_rule_attributes IS

281: l_attrib_counter NUMBER := 1;
282: l_rule_counter NUMBER := 1;
283:
284: -- ganesh uncomment out enabled flag .
285: CURSOR cn_sca_rule_attributes IS
286: SELECT *
287: FROM cn_sca_rule_attributes csra
288: WHERE transaction_source = x_transaction_source
289: -- codeCheck: This condition is not required when inner has it.

Line 287: FROM cn_sca_rule_attributes csra

283:
284: -- ganesh uncomment out enabled flag .
285: CURSOR cn_sca_rule_attributes IS
286: SELECT *
287: FROM cn_sca_rule_attributes csra
288: WHERE transaction_source = x_transaction_source
289: -- codeCheck: This condition is not required when inner has it.
290: AND org_id = g_org_id
291: -- AND enabled_flag = 'Y'

Line 371: FOR attributes in cn_sca_rule_attributes LOOP

367: cn_utils.appendcr(body_code, ''' BETWEEN a.start_date AND NVL(a.end_date,cshi.processed_date) ''||');
368: cn_utils.appendcr(body_code, ''' AND ( ''||');
369:
370: -- loop for all attributes and generate the necessary or condition.
371: FOR attributes in cn_sca_rule_attributes LOOP
372: IF l_attrib_counter > 1 THEN
373: cn_utils.appendcr(body_code, ''' OR ''||');
374: END IF;
375:

Line 505: (x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)

501:
502:
503:
504: FUNCTION create_sca_rules_online_dyn
505: (x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
506: RETURN BOOLEAN IS
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;

Line 556: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE

552: p_org_id IN NUMBER,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE
557: ) IS
558:
559: l_api_name CONSTANT VARCHAR2(30) := 'gen_sca_rules_onln_dyn';
560: l_api_version CONSTANT NUMBER :=1.0;