677:
678:
679: END;
680: -- now call rules engine
681: FUN_RULE_PUB.init_parameter_list;
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
678:
679: END;
680: -- now call rules engine
681: FUN_RULE_PUB.init_parameter_list;
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
679: END;
680: -- now call rules engine
681: FUN_RULE_PUB.init_parameter_list;
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
680: -- now call rules engine
681: FUN_RULE_PUB.init_parameter_list;
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
681: FUN_RULE_PUB.init_parameter_list;
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
682: FUN_RULE_PUB.add_parameter('AMOUNT_REQUESTED',l_amount );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
683: FUN_RULE_PUB.add_parameter('CREDIT_CLASSIFICATION', l_credit_classification);
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
684: FUN_RULE_PUB.add_parameter('CUSTOMER_PROFILE_CLASS',l_profile_class_name );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
685: FUN_RULE_PUB.add_parameter('COUNTRY',l_country );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
686: FUN_RULE_PUB.add_parameter('STATE',l_state );
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
687: FUN_RULE_PUB.add_parameter('PROVINCE',l_province );
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
695:
688: FUN_RULE_PUB.add_parameter('SIC_CODE',l_sic_code );
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
695:
696: p_credit_analyst_id := FUN_RULE_PUB.get_number;
689: FUN_RULE_PUB.add_parameter('CUSTOMER_NAME',l_party_id);
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
695:
696: p_credit_analyst_id := FUN_RULE_PUB.get_number;
697:
690: FUN_RULE_PUB.add_parameter('NUM_EMPLOYEE',l_employees_total );
691: FUN_RULE_PUB.add_parameter('REVIEW_TYPE',l_review_type );
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
695:
696: p_credit_analyst_id := FUN_RULE_PUB.get_number;
697:
698: EXCEPTION
692: FUN_RULE_PUB.add_parameter('CURRENCY',l_currency );
693: FUN_RULE_PUB.add_parameter('POSTAL_CODE',l_postal_code );
694: FUN_RULE_PUB.apply_rule('AR','OCM_CREDIT_ANALYST_ASSGN');
695:
696: p_credit_analyst_id := FUN_RULE_PUB.get_number;
697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: wf_core.context('AR_CMGT_WF_ENGINE','getCAFromRulesEngine',p_itemtype, p_credit_request_id,