APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 628: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.ORG_PAYMENT_METHOD_NAME%TYPE := p_payment_method_name;

624: IS
625:
626: -- In Variables
627: l_effective_date DATE := p_effective_date;
628: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.ORG_PAYMENT_METHOD_NAME%TYPE := p_payment_method_name;
629: l_payment_type_id PAY_ORG_PAYMENT_METHODS_F.PAYMENT_TYPE_ID%TYPE;
630: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
631: l_verify_payment_method NUMBER;
632:

Line 629: l_payment_type_id PAY_ORG_PAYMENT_METHODS_F.PAYMENT_TYPE_ID%TYPE;

625:
626: -- In Variables
627: l_effective_date DATE := p_effective_date;
628: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.ORG_PAYMENT_METHOD_NAME%TYPE := p_payment_method_name;
629: l_payment_type_id PAY_ORG_PAYMENT_METHODS_F.PAYMENT_TYPE_ID%TYPE;
630: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
631: l_verify_payment_method NUMBER;
632:
633:

Line 671: FROM PAY_ORG_PAYMENT_METHODS_F

667: CLOSE csr_currency_code;
668:
669:
670: SELECT COUNT(*) INTO l_verify_payment_method
671: FROM PAY_ORG_PAYMENT_METHODS_F
672: WHERE org_payment_method_name = p_payment_method_name
673: AND business_group_id = p_bg_id;
674:
675: IF (l_verify_payment_method <> 0) THEN

Line 681: FROM PAY_ORG_PAYMENT_METHODS_F

677: p_errbuff := 'Warning : CRP Default Program may not function properly as Payment Method under the name ' || p_payment_method_name || ' already exists(continuing creation of other data) for business group ID = ';
678: write_log(1,p_errbuff,p_bg_id);
679:
680: SELECT distinct org_payment_method_id into p_org_payment_method_id
681: FROM PAY_ORG_PAYMENT_METHODS_F
682: WHERE org_payment_method_name = p_payment_method_name
683: AND business_group_id = p_bg_id;
684:
685: ELSE