DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on IBY_PAYMENTS_ALL_S

Line 236: source_product IBY_PAYMENTS_ALL.source_product%TYPE

232: l_remit_tbl l_remit_tbl_type;
233:
234: TYPE l_ppr_rec IS RECORD(
235: payment_process_request_name IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
236: source_product IBY_PAYMENTS_ALL.source_product%TYPE
237: );
238:
239: TYPE l_ppr_tbl_type IS TABLE OF l_ppr_rec INDEX BY BINARY_INTEGER;
240: l_ppr_tbl l_ppr_tbl_type;

Line 372: l_settlement_pr iby_payments_all.SETTLEMENT_PRIORITY%type;

368: l_trx_audit_index IN BINARY_INTEGER
369: )
370: IS
371: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||'.updateCommonAttribues';
372: l_settlement_pr iby_payments_all.SETTLEMENT_PRIORITY%type;
373:
374: BEGIN
375: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
376: print_debuginfo(l_module_name, 'ENTER');

Line 9352: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID

9348: IS
9349:
9350: BEGIN
9351:
9352: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID
9353: FROM DUAL;
9354:
9355: END getNextPaymentID;
9356:

Line 23044: update iby_payments_all set payment_amount = l_pmt_amount,

23040: IF( l_paymentTab(i).payment_status = PAY_STATUS_MODIFIED) THEN
23041: l_paymentTab(i).payment_status := PAY_STATUS_CREATED;
23042: END IF;
23043:
23044: update iby_payments_all set payment_amount = l_pmt_amount,
23045: payment_status = l_paymentTab(i).payment_status
23046: where payment_id = l_paymentTab(i).payment_id;
23047:
23048: END LOOP;