APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_PAYMENTS_ALL

Line 899: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,

895: | NOTES:
896: |
897: *---------------------------------------------------------------------*/
898: PROCEDURE createPmtErrorRecord(
899: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
900: p_pmt_status IN IBY_PAYMENTS_ALL.
901: payment_status%TYPE,
902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
903: DEFAULT NULL,

Line 900: p_pmt_status IN IBY_PAYMENTS_ALL.

896: |
897: *---------------------------------------------------------------------*/
898: PROCEDURE createPmtErrorRecord(
899: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
900: p_pmt_status IN IBY_PAYMENTS_ALL.
901: payment_status%TYPE,
902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
903: DEFAULT NULL,
904: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE

Line 1684: IBY_PAYMENTS_ALL pmt

1680: );
1681:
1682: END IF;
1683: UPDATE
1684: IBY_PAYMENTS_ALL pmt
1685: SET
1686: pmt.payment_status = PAY_STATUS_CREATED
1687: WHERE
1688: pmt.payment_id = p_trxn_id

Line 1766: IBY_PAYMENTS_ALL

1762: (
1763: SELECT
1764: payment_id
1765: FROM
1766: IBY_PAYMENTS_ALL
1767: WHERE
1768: payment_service_request_id = p_payment_request_id AND
1769: payment_status IN
1770: (

Line 1815: IBY_PAYMENTS_ALL

1811: * Reset the status of payments that are to be re-validated to
1812: * 'CREATED'.
1813: */
1814: UPDATE
1815: IBY_PAYMENTS_ALL
1816: SET
1817: payment_status = PAY_STATUS_CREATED
1818: WHERE
1819: payment_service_request_id = p_payment_request_id AND