APPS.ARP_EXT_BANK_PKG dependencies on RA_CUST_RECEIPT_METHODS

Line 876: FROM ra_cust_receipt_methods rm

872: sql_stmt VARCHAR2(10000);
873:
874: site_sql_stmt VARCHAR2(4000) := '
875: SELECT cust_RECEIPT_METHOD_ID, NVL(site_use_id, -1)
876: FROM ra_cust_receipt_methods rm
877: WHERE rm.customer_id = :p_customer_id
878: AND rm.SITE_USE_ID = NVL(:p_site_use_id, -1)
879: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
880:

Line 884: FROM ra_cust_receipt_methods rm

880:
881: cust_sql_stmt VARCHAR2(4000) := '
882: UNION
883: SELECT cust_RECEIPT_METHOD_ID, NVL(site_use_id, -1)
884: FROM ra_cust_receipt_methods rm
885: WHERE rm.customer_id = :p_customer_id
886: AND rm.SITE_USE_ID IS NULL
887: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
888:

Line 970: /* 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. */

966: WHEN OTHERS THEN
967: RAISE;
968: END get_cust_pay_method;
969:
970: /* 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. */
971:
972: /*===========================================================================+
973: | FUNCTION process_cust_pay_method |
974: | |

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

973: | FUNCTION process_cust_pay_method |
974: | |
975: | DESCRIPTION |
976: | Check if the customer already has a payment method associated else it |
977: | will insert a record in ra_cust_receipt_methods. |
978: | |
979: | SCOPE - PUBLIC |
980: | |
981: | |

Line 999: l_primary_flag ra_cust_receipt_methods.primary_flag%type;

995: p_customer_id IN NUMBER,
996: p_site_use_id IN NUMBER DEFAULT null,
997: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE) ) RETURN NUMBER IS
998: l_cust_pay_method_id NUMBER;
999: l_primary_flag ra_cust_receipt_methods.primary_flag%type;
1000: --
1001: FUNCTION check_primary_method_exists (p_customer_id IN NUMBER,
1002: p_site_use_id IN NUMBER DEFAULT null,
1003: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN BOOLEAN IS

Line 1032: RA_CUST_RECEIPT_METHODS_S.NEXTVAL

1028: p_as_of_date=>NVL(p_as_of_date, TRUNC(SYSDATE)));
1029: IF l_cust_pay_method_id IS NULL THEN
1030: --
1031: SELECT
1032: RA_CUST_RECEIPT_METHODS_S.NEXTVAL
1033: INTO
1034: l_cust_pay_method_id
1035: FROM
1036: dual;

Line 1046: INSERT INTO ra_cust_receipt_methods

1042: ELSE
1043: l_primary_flag := 'Y';
1044: END IF;
1045: --
1046: INSERT INTO ra_cust_receipt_methods
1047: (customer_id,
1048: receipt_method_id,
1049: primary_flag,
1050: creation_date,