APPS.ARP_EXT_BANK_PKG dependencies on RA_CUST_RECEIPT_METHODS

Line 897: FROM ra_cust_receipt_methods rm

893: sql_stmt VARCHAR2(10000);
894:
895: site_sql_stmt VARCHAR2(4000) := '
896: SELECT cust_RECEIPT_METHOD_ID, NVL(site_use_id, -1)
897: FROM ra_cust_receipt_methods rm
898: WHERE rm.customer_id = :p_customer_id
899: AND rm.SITE_USE_ID = NVL(:p_site_use_id, -1)
900: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
901:

Line 905: FROM ra_cust_receipt_methods rm

901:
902: cust_sql_stmt VARCHAR2(4000) := '
903: UNION
904: SELECT cust_RECEIPT_METHOD_ID, NVL(site_use_id, -1)
905: FROM ra_cust_receipt_methods rm
906: WHERE rm.customer_id = :p_customer_id
907: AND rm.SITE_USE_ID IS NULL
908: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
909:

Line 991: /* bug 6121157 Function "process_cust_pay_method()" added to check if the customer already has a payment method associated else it will insert a record in ra_cust_receipt_methods. */

987: WHEN OTHERS THEN
988: RAISE;
989: END get_cust_pay_method;
990:
991: /* bug 6121157 Function "process_cust_pay_method()" added to check if the customer already has a payment method associated else it will insert a record in ra_cust_receipt_methods. */
992:
993: /*===========================================================================+
994: | FUNCTION process_cust_pay_method |
995: | |

Line 998: | will insert a record in ra_cust_receipt_methods. |

994: | FUNCTION process_cust_pay_method |
995: | |
996: | DESCRIPTION |
997: | Check if the customer already has a payment method associated else it |
998: | will insert a record in ra_cust_receipt_methods. |
999: | |
1000: | SCOPE - PUBLIC |
1001: | |
1002: | |

Line 1020: l_primary_flag ra_cust_receipt_methods.primary_flag%type;

1016: p_customer_id IN NUMBER,
1017: p_site_use_id IN NUMBER DEFAULT null,
1018: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE) ) RETURN NUMBER IS
1019: l_cust_pay_method_id NUMBER;
1020: l_primary_flag ra_cust_receipt_methods.primary_flag%type;
1021: --
1022: FUNCTION check_primary_method_exists (p_customer_id IN NUMBER,
1023: p_site_use_id IN NUMBER DEFAULT null,
1024: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN BOOLEAN IS

Line 1053: RA_CUST_RECEIPT_METHODS_S.NEXTVAL

1049: p_as_of_date=>NVL(p_as_of_date, TRUNC(SYSDATE)));
1050: IF l_cust_pay_method_id IS NULL THEN
1051: --
1052: SELECT
1053: RA_CUST_RECEIPT_METHODS_S.NEXTVAL
1054: INTO
1055: l_cust_pay_method_id
1056: FROM
1057: dual;

Line 1066: INSERT INTO ra_cust_receipt_methods

1062:
1063: l_primary_flag := 'N';
1064:
1065: --
1066: INSERT INTO ra_cust_receipt_methods
1067: (customer_id,
1068: receipt_method_id,
1069: primary_flag,
1070: creation_date,