APPS.IBY_UTILITY_PVT dependencies on IBY_PAY_DASHBOARD_GT

Line 1650: DELETE FROM IBY_PAY_DASHBOARD_GT;

1646:
1647: BEGIN
1648:
1649: -- Deleting all records from GT table
1650: DELETE FROM IBY_PAY_DASHBOARD_GT;
1651: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1652: iby_debug_pub.add(debug_msg => 'Deleted all records from GT table',
1653: debug_level => FND_LOG.LEVEL_STATEMENT,
1654: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

Line 1660: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1656:
1657:
1658: -- Inserting PPR's which need Action - 'NEED_ACTION_BY_ME'
1659:
1660: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1661: CHECKRUN_ID,
1662: CHECKRUN_NAME,
1663: STATE)
1664: SELECT iby.payment_service_request_id,

Line 1697: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1693: AND iby_utility_pvt.check_user_access(instr.payment_instruction_id) = 'Y'
1694: )
1695: );
1696:
1697: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1698: CHECKRUN_ID,
1699: CHECKRUN_NAME,
1700: STATE)
1701: SELECT null,

Line 1723: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1719: -- Inserting PPRs which are in Processing Status - 'PROCESSING'
1720: /*Modified the query for the Bug 7560766
1721: Added a condition to identify the PPRs which
1722: are waiting for the user action*/
1723: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1724: CHECKRUN_ID,
1725: CHECKRUN_NAME,
1726: STATE)
1727: SELECT iby.payment_service_request_id,

Line 1772: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1768: )
1769: );
1770:
1771:
1772: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1773: CHECKRUN_ID,
1774: CHECKRUN_NAME,
1775: STATE)
1776: SELECT null,

Line 1796: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1792: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1793: END IF;
1794:
1795: -- Inserting PPRs which are terminated by User --'USER_TERMINATED'
1796: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1797: CHECKRUN_ID,
1798: CHECKRUN_NAME,
1799: STATE)
1800: SELECT null,

Line 1814: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1810: AND iby.payment_service_request_status IN
1811: ('TERMINATED'))
1812: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1813:
1814: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1815: CHECKRUN_ID,
1816: CHECKRUN_NAME,
1817: STATE)
1818: SELECT null,

Line 1841: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1837:
1838:
1839: -- Inserting PPRs which are halted with Program Errors -'PROGRAM_ERRORS'
1840:
1841: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1842: CHECKRUN_ID,
1843: CHECKRUN_NAME,
1844: STATE)
1845: SELECT null,

Line 1868: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

1864: END IF;
1865:
1866: -- Insert PPRs which are completed - 'COMPLETED'
1867:
1868: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,
1869: CHECKRUN_ID,
1870: CHECKRUN_NAME,
1871: STATE)
1872: SELECT null,