eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on ARP_CASHBOOK

Line 664: arp_cashbook.risk_eliminate ( v_cr_id,

660: --
661: -- Call Risk Handler
662: --
663: IF ( locked AND p_crh_rec.current_record_flag = 'Y' ) THEN
664: arp_cashbook.risk_eliminate ( v_cr_id,
665: v_trx_date,
666: v_gl_date,
667: v_mod_name,
668: v_mod_vers,

Line 680: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

676: END LOOP;
677: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
678: store the records in the plsql table and invoke it at at time.
679: invoking the refresh_at_risk here*/
680: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
681: ARP_CASHBOOK.g_site_use_id_tab,
682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:

Line 681: ARP_CASHBOOK.g_site_use_id_tab,

677: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
678: store the records in the plsql table and invoke it at at time.
679: invoking the refresh_at_risk here*/
680: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
681: ARP_CASHBOOK.g_site_use_id_tab,
682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;

Line 682: ARP_CASHBOOK.g_currency_tab,

678: store the records in the plsql table and invoke it at at time.
679: invoking the refresh_at_risk here*/
680: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
681: ARP_CASHBOOK.g_site_use_id_tab,
682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;

Line 683: ARP_CASHBOOK.g_org_id_tab);

679: invoking the refresh_at_risk here*/
680: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
681: ARP_CASHBOOK.g_site_use_id_tab,
682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;

Line 685: ARP_CASHBOOK.g_customer_id_tab.delete;

681: ARP_CASHBOOK.g_site_use_id_tab,
682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;
688: ARP_CASHBOOK.g_org_id_tab.delete;
689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

Line 686: ARP_CASHBOOK.g_site_use_id_tab.delete;

682: ARP_CASHBOOK.g_currency_tab,
683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;
688: ARP_CASHBOOK.g_org_id_tab.delete;
689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
690:

Line 687: ARP_CASHBOOK.g_currency_tab.delete;

683: ARP_CASHBOOK.g_org_id_tab);
684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;
688: ARP_CASHBOOK.g_org_id_tab.delete;
689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
690:
691: ELSE

Line 688: ARP_CASHBOOK.g_org_id_tab.delete;

684:
685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;
688: ARP_CASHBOOK.g_org_id_tab.delete;
689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
690:
691: ELSE
692: LOOP

Line 689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

685: ARP_CASHBOOK.g_customer_id_tab.delete;
686: ARP_CASHBOOK.g_site_use_id_tab.delete;
687: ARP_CASHBOOK.g_currency_tab.delete;
688: ARP_CASHBOOK.g_org_id_tab.delete;
689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
690:
691: ELSE
692: LOOP
693: IF dbms_sql.fetch_rows(c) > 0 THEN

Line 748: arp_standard.debug('Before calling arp_cashbook.clear');

744: nvl(v_ex_rate,1),
745: NULL,NULL );
746: END IF;
747:
748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

Line 761: arp_cashbook.clear( v_cr_id,

757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);
760:
761: arp_cashbook.clear( v_cr_id,
762: v_trx_date,
763: v_gl_date,
764: NULL, -- value date parameter
765: v_ex_date,

Line 814: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

810: END LOOP;
811: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
812: store the records in the plsql table and invoke it at at time.
813: invoking the refresh_at_risk here*/
814: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
815: ARP_CASHBOOK.g_site_use_id_tab,
816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:

Line 815: ARP_CASHBOOK.g_site_use_id_tab,

811: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
812: store the records in the plsql table and invoke it at at time.
813: invoking the refresh_at_risk here*/
814: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
815: ARP_CASHBOOK.g_site_use_id_tab,
816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;

Line 816: ARP_CASHBOOK.g_currency_tab,

812: store the records in the plsql table and invoke it at at time.
813: invoking the refresh_at_risk here*/
814: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
815: ARP_CASHBOOK.g_site_use_id_tab,
816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;

Line 817: ARP_CASHBOOK.g_org_id_tab);

813: invoking the refresh_at_risk here*/
814: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
815: ARP_CASHBOOK.g_site_use_id_tab,
816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;

Line 819: ARP_CASHBOOK.g_customer_id_tab.delete;

815: ARP_CASHBOOK.g_site_use_id_tab,
816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;
822: ARP_CASHBOOK.g_org_id_tab.delete;
823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

Line 820: ARP_CASHBOOK.g_site_use_id_tab.delete;

816: ARP_CASHBOOK.g_currency_tab,
817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;
822: ARP_CASHBOOK.g_org_id_tab.delete;
823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
824:

Line 821: ARP_CASHBOOK.g_currency_tab.delete;

817: ARP_CASHBOOK.g_org_id_tab);
818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;
822: ARP_CASHBOOK.g_org_id_tab.delete;
823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
824:
825: END IF;

Line 822: ARP_CASHBOOK.g_org_id_tab.delete;

818:
819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;
822: ARP_CASHBOOK.g_org_id_tab.delete;
823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
824:
825: END IF;
826: --

Line 823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

819: ARP_CASHBOOK.g_customer_id_tab.delete;
820: ARP_CASHBOOK.g_site_use_id_tab.delete;
821: ARP_CASHBOOK.g_currency_tab.delete;
822: ARP_CASHBOOK.g_org_id_tab.delete;
823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
824:
825: END IF;
826: --
827: dbms_sql.close_cursor(c);

Line 1684: arp_cashbook.risk_eliminate ( v_cr_id,

1680: --
1681: -- Call Risk Handler
1682: --
1683: IF ( locked AND p_crh_rec.current_record_flag = 'Y' ) THEN
1684: arp_cashbook.risk_eliminate ( v_cr_id,
1685: v_trx_date,
1686: v_gl_date,
1687: v_mod_name,
1688: v_mod_vers,

Line 1700: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

1696: END LOOP;
1697: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
1698: store the records in the plsql table and invoke it at at time.
1699: invoking the refresh_at_risk here*/
1700: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1701: ARP_CASHBOOK.g_site_use_id_tab,
1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:

Line 1701: ARP_CASHBOOK.g_site_use_id_tab,

1697: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
1698: store the records in the plsql table and invoke it at at time.
1699: invoking the refresh_at_risk here*/
1700: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1701: ARP_CASHBOOK.g_site_use_id_tab,
1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;

Line 1702: ARP_CASHBOOK.g_currency_tab,

1698: store the records in the plsql table and invoke it at at time.
1699: invoking the refresh_at_risk here*/
1700: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1701: ARP_CASHBOOK.g_site_use_id_tab,
1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;

Line 1703: ARP_CASHBOOK.g_org_id_tab);

1699: invoking the refresh_at_risk here*/
1700: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1701: ARP_CASHBOOK.g_site_use_id_tab,
1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;

Line 1705: ARP_CASHBOOK.g_customer_id_tab.delete;

1701: ARP_CASHBOOK.g_site_use_id_tab,
1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;
1708: ARP_CASHBOOK.g_org_id_tab.delete;
1709:

Line 1706: ARP_CASHBOOK.g_site_use_id_tab.delete;

1702: ARP_CASHBOOK.g_currency_tab,
1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;
1708: ARP_CASHBOOK.g_org_id_tab.delete;
1709:
1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

Line 1707: ARP_CASHBOOK.g_currency_tab.delete;

1703: ARP_CASHBOOK.g_org_id_tab);
1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;
1708: ARP_CASHBOOK.g_org_id_tab.delete;
1709:
1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1711: ELSE

Line 1708: ARP_CASHBOOK.g_org_id_tab.delete;

1704:
1705: ARP_CASHBOOK.g_customer_id_tab.delete;
1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;
1708: ARP_CASHBOOK.g_org_id_tab.delete;
1709:
1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1711: ELSE
1712: LOOP

Line 1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

1706: ARP_CASHBOOK.g_site_use_id_tab.delete;
1707: ARP_CASHBOOK.g_currency_tab.delete;
1708: ARP_CASHBOOK.g_org_id_tab.delete;
1709:
1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1711: ELSE
1712: LOOP
1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);

Line 1765: arp_standard.debug('Before calling arp_cashbook.clear');

1761: ARP_GLOBAL.functional_currency,
1762: nvl(v_ex_rate,1),
1763: NULL,NULL );
1764: END IF;
1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

Line 1778: arp_cashbook.clear( v_cr_id,

1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);
1777:
1778: arp_cashbook.clear( v_cr_id,
1779: v_trx_date,
1780: v_gl_date,
1781: NULL, -- value date parameter
1782: v_ex_date,

Line 1832: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

1828: END LOOP;
1829: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
1830: store the records in the plsql table and invoke it at at time.
1831: invoking the refresh_at_risk here*/
1832: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1833: ARP_CASHBOOK.g_site_use_id_tab,
1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:

Line 1833: ARP_CASHBOOK.g_site_use_id_tab,

1829: /*bug 14553712, instead of invoking the refersh_at_risk procedure,
1830: store the records in the plsql table and invoke it at at time.
1831: invoking the refresh_at_risk here*/
1832: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1833: ARP_CASHBOOK.g_site_use_id_tab,
1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;

Line 1834: ARP_CASHBOOK.g_currency_tab,

1830: store the records in the plsql table and invoke it at at time.
1831: invoking the refresh_at_risk here*/
1832: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1833: ARP_CASHBOOK.g_site_use_id_tab,
1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;

Line 1835: ARP_CASHBOOK.g_org_id_tab);

1831: invoking the refresh_at_risk here*/
1832: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
1833: ARP_CASHBOOK.g_site_use_id_tab,
1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;

Line 1837: ARP_CASHBOOK.g_customer_id_tab.delete;

1833: ARP_CASHBOOK.g_site_use_id_tab,
1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;
1840: ARP_CASHBOOK.g_org_id_tab.delete;
1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

Line 1838: ARP_CASHBOOK.g_site_use_id_tab.delete;

1834: ARP_CASHBOOK.g_currency_tab,
1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;
1840: ARP_CASHBOOK.g_org_id_tab.delete;
1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1842:

Line 1839: ARP_CASHBOOK.g_currency_tab.delete;

1835: ARP_CASHBOOK.g_org_id_tab);
1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;
1840: ARP_CASHBOOK.g_org_id_tab.delete;
1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1842:
1843: END IF;

Line 1840: ARP_CASHBOOK.g_org_id_tab.delete;

1836:
1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;
1840: ARP_CASHBOOK.g_org_id_tab.delete;
1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1842:
1843: END IF;
1844: --

Line 1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

1837: ARP_CASHBOOK.g_customer_id_tab.delete;
1838: ARP_CASHBOOK.g_site_use_id_tab.delete;
1839: ARP_CASHBOOK.g_currency_tab.delete;
1840: ARP_CASHBOOK.g_org_id_tab.delete;
1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1842:
1843: END IF;
1844: --
1845: dbms_sql.close_cursor(c);