DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_PMT_CALLOUT_PKG

Line 1: PACKAGE BODY AP_PMT_CALLOUT_PKG AS

1: PACKAGE BODY AP_PMT_CALLOUT_PKG AS
2: /*$Header: apcnfrmb.pls 120.36.12010000.11 2009/02/13 08:35:30 amitmukh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PMT_CALLOUT_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PMT_CALLOUT_PKG';

1: PACKAGE BODY AP_PMT_CALLOUT_PKG AS
2: /*$Header: apcnfrmb.pls 120.36.12010000.11 2009/02/13 08:35:30 amitmukh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PMT_CALLOUT_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_PMT_CALLOUT_PKG.';
21:
22: FUNCTION get_user_rate (p_base_currency_code in varchar2,
23: p_payment_currency_code in varchar2,
24: p_checkrun_id in number) return number is

Line 57: l_rate := ap_pmt_callout_pkg.get_user_rate(p_base_currency_code,

53:
54: begin
55:
56: if p_exchange_rate_type = 'User' then
57: l_rate := ap_pmt_callout_pkg.get_user_rate(p_base_currency_code,
58: p_payment_currency_code,
59: p_checkrun_id);
60:
61:

Line 877: l_current_calling_sequence := 'AP_PMT_CALLOUT_PKG.payments_completed';

873:
874:
875: BEGIN
876: l_api_name := 'payments_completed';
877: l_current_calling_sequence := 'AP_PMT_CALLOUT_PKG.payments_completed';
878:
879: l_check_count :=0;
880: l_total_check_count :=0;
881: l_docs_count :=0;

Line 1158: ap_pmt_callout_pkg.get_user_rate(

1154: NULL,
1155: decode(l_base_currency_mac, null,
1156: round(new.payment_amount / orig.payment_cross_rate *
1157: decode(l_exchange_rate_type, 'User',
1158: ap_pmt_callout_pkg.get_user_rate(
1159: l_base_currency_code,
1160: ibypmts.payment_currency_code,
1161: l_checkrun_id),
1162: nvl(ap_utilities_pkg.get_exchange_rate(

Line 1171: ap_pmt_callout_pkg.get_user_rate(

1167: 'CONFIRM'),1)), l_base_currency_precision),
1168:
1169: round( (new.payment_amount / orig.payment_cross_rate *
1170: decode(l_exchange_rate_type, 'User',
1171: ap_pmt_callout_pkg.get_user_rate(
1172: l_base_currency_code,
1173: ibypmts.payment_currency_code,
1174: l_checkrun_id),
1175: nvl(ap_utilities_pkg.get_exchange_rate(

Line 1271: ap_pmt_callout_pkg.get_user_rate(

1267: NULL,
1268: decode(l_base_currency_mac, null,
1269: round(new.payment_amount / orig.payment_cross_rate *
1270: decode(l_exchange_rate_type, 'User',
1271: ap_pmt_callout_pkg.get_user_rate(
1272: l_base_currency_code,
1273: ibypmts.payment_currency_code,
1274: l_checkrun_id),
1275: nvl(ap_utilities_pkg.get_exchange_rate(

Line 1283: ap_pmt_callout_pkg.get_user_rate(

1279: l_check_date,
1280: 'CONFIRM'),1)), l_base_currency_precision),
1281: round( (new.payment_amount / orig.payment_cross_rate *
1282: decode(l_exchange_rate_type, 'User',
1283: ap_pmt_callout_pkg.get_user_rate(
1284: l_base_currency_code,
1285: ibypmts.payment_currency_code,
1286: l_checkrun_id),
1287: nvl(ap_utilities_pkg.get_exchange_rate(

Line 1622: ap_pmt_callout_pkg.get_user_rate(

1618: iby.payment_method_code,
1619: decode(iby.payment_currency_code, l_base_currency_code,
1620: null,
1621: decode(l_exchange_rate_type, 'User',
1622: ap_pmt_callout_pkg.get_user_rate(
1623: l_base_currency_code,
1624: iby.payment_currency_code,
1625: l_checkrun_id),
1626: ap_utilities_pkg.get_exchange_rate(

Line 1636: ap_pmt_callout_pkg.get_base_amount(l_base_currency_code,

1632: l_exchange_rate_type,
1633: l_check_date, --exchange rate date
1634: decode(iby.payment_currency_code, l_base_currency_code,
1635: null,
1636: ap_pmt_callout_pkg.get_base_amount(l_base_currency_code,
1637: iby.payment_currency_code,
1638: l_checkrun_id,
1639: l_exchange_rate_type,
1640: l_base_currency_mac,

Line 1652: ap_pmt_callout_pkg.get_user_rate(l_base_currency_code,

1648: iby.maturity_date)),
1649: l_exchange_rate_type,
1650: decode(iby.payment_currency_code, l_base_currency_code, NULL,
1651: decode(l_exchange_rate_type, 'User',
1652: ap_pmt_callout_pkg.get_user_rate(l_base_currency_code,
1653: iby.payment_currency_code,
1654: l_checkrun_id),
1655: ap_utilities_pkg.get_exchange_rate(
1656: iby.payment_currency_code,

Line 2064: ROUND((ibydocs.payment_amount * ap_pmt_callout_pkg.get_user_rate(

2060: null,
2061: ibydocs.payment_amount),
2062: decode(l_exchange_rate_type , 'User',
2063: decode(l_base_currency_mac, NULL,
2064: ROUND((ibydocs.payment_amount * ap_pmt_callout_pkg.get_user_rate(
2065: l_base_currency_code,
2066: ibydocs.payment_currency_code,
2067: l_checkrun_id))
2068: ,l_base_currency_precision),

Line 2069: ROUND((ibydocs.payment_amount * ap_pmt_callout_pkg.get_user_rate(

2065: l_base_currency_code,
2066: ibydocs.payment_currency_code,
2067: l_checkrun_id))
2068: ,l_base_currency_precision),
2069: ROUND((ibydocs.payment_amount * ap_pmt_callout_pkg.get_user_rate(
2070: l_base_currency_code,
2071: ibydocs.payment_currency_code,
2072: l_checkrun_id))
2073: / l_base_currency_mac)

Line 2866: END AP_PMT_CALLOUT_PKG;

2862: END Payment_Stop_Released;
2863:
2864: /* End of fix for bug 6756063 */
2865:
2866: END AP_PMT_CALLOUT_PKG;