APPS.ARP_CASHBOOK dependencies on AR_BUS_EVENT_SUB_PVT

Line 74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;

70: l_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;
72:
73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
76: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
77: l_currency_tab ar_bus_event_sub_pvt.currency_type;
78: /* end 9363502 */

Line 75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;

71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;
72:
73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
76: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
77: l_currency_tab ar_bus_event_sub_pvt.currency_type;
78: /* end 9363502 */
79:

Line 76: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;

72:
73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
76: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
77: l_currency_tab ar_bus_event_sub_pvt.currency_type;
78: /* end 9363502 */
79:
80: BEGIN

Line 77: l_currency_tab ar_bus_event_sub_pvt.currency_type;

73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
76: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
77: l_currency_tab ar_bus_event_sub_pvt.currency_type;
78: /* end 9363502 */
79:
80: BEGIN
81:

Line 1003: ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,

999:
1000: /*bug 13858491 Starts*/
1001: -- Commented for bug 16229574
1002: /*If(p_module_name = 'CE_AUTO_BANK_REC') then
1003: ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,
1004: l_site_use_id_tab,
1005: l_currency_tab,
1006: l_org_id_tab,
1007: l_cr_rec.cash_receipt_id);

Line 1009: /*ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,

1005: l_currency_tab,
1006: l_org_id_tab,
1007: l_cr_rec.cash_receipt_id);
1008: else*/
1009: /*ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,
1010: l_site_use_id_tab,
1011: l_currency_tab,
1012: l_org_id_tab);
1013: */

Line 1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;

1524: l_cr_rec ar_cash_receipts%ROWTYPE;
1525: l_risk_event_rec arp_xla_events.xla_events_type;
1526:
1527: /* 9363502 - define tables used by refresh_at_risk_value */
1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
1529: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
1530: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
1531: l_currency_tab ar_bus_event_sub_pvt.currency_type;
1532: /* end 9363502 */

Line 1529: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;

1525: l_risk_event_rec arp_xla_events.xla_events_type;
1526:
1527: /* 9363502 - define tables used by refresh_at_risk_value */
1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
1529: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
1530: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
1531: l_currency_tab ar_bus_event_sub_pvt.currency_type;
1532: /* end 9363502 */
1533:

Line 1530: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;

1526:
1527: /* 9363502 - define tables used by refresh_at_risk_value */
1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
1529: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
1530: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
1531: l_currency_tab ar_bus_event_sub_pvt.currency_type;
1532: /* end 9363502 */
1533:
1534: BEGIN

Line 1531: l_currency_tab ar_bus_event_sub_pvt.currency_type;

1527: /* 9363502 - define tables used by refresh_at_risk_value */
1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
1529: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;
1530: l_org_id_tab ar_bus_event_sub_pvt.generic_id_type;
1531: l_currency_tab ar_bus_event_sub_pvt.currency_type;
1532: /* end 9363502 */
1533:
1534: BEGIN
1535:

Line 1747: ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,

1743: l_site_use_id_tab(0) := NVL(l_cr_rec.customer_site_use_id,-99);
1744: l_currency_tab(0) := l_cr_rec.currency_code;
1745: l_org_id_tab(0) := l_cr_rec.org_id;
1746:
1747: ar_bus_event_sub_pvt.refresh_at_risk_value(l_customer_id_tab,
1748: l_site_use_id_tab,
1749: l_currency_tab,
1750: l_org_id_tab);
1751: */

Line 2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

2792:
2793: -- Added for bug 16229574
2794: PROCEDURE refresh_risk_value IS
2795: BEGIN
2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800: