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.AR_RECEIPT_LIB_PVT dependencies on AR_CASH_RECEIPTS

Line 43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,

39: location hz_cust_site_uses.location%TYPE,
40: primary_flag VARCHAR2(1)
41: );
42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD
43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,
44: currency ar_cash_receipts.currency_code%TYPE,
45: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
46: exchange_date ar_cash_receipts.exchange_date%TYPE
47: );

Line 44: currency ar_cash_receipts.currency_code%TYPE,

40: primary_flag VARCHAR2(1)
41: );
42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD
43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,
44: currency ar_cash_receipts.currency_code%TYPE,
45: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
46: exchange_date ar_cash_receipts.exchange_date%TYPE
47: );
48:

Line 45: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,

41: );
42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD
43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,
44: currency ar_cash_receipts.currency_code%TYPE,
45: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
46: exchange_date ar_cash_receipts.exchange_date%TYPE
47: );
48:
49: TYPE Method_Info_Cache_Rec_Type IS RECORD

Line 46: exchange_date ar_cash_receipts.exchange_date%TYPE

42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD
43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,
44: currency ar_cash_receipts.currency_code%TYPE,
45: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
46: exchange_date ar_cash_receipts.exchange_date%TYPE
47: );
48:
49: TYPE Method_Info_Cache_Rec_Type IS RECORD
50: (receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,

Line 50: (receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,

46: exchange_date ar_cash_receipts.exchange_date%TYPE
47: );
48:
49: TYPE Method_Info_Cache_Rec_Type IS RECORD
50: (receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
51: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
52: currency_code ar_cash_receipts.currency_code%TYPE,
53: called_from VARCHAR2(200),
54: state ar_receipt_classes.creation_status%TYPE,

Line 51: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,

47: );
48:
49: TYPE Method_Info_Cache_Rec_Type IS RECORD
50: (receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
51: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
52: currency_code ar_cash_receipts.currency_code%TYPE,
53: called_from VARCHAR2(200),
54: state ar_receipt_classes.creation_status%TYPE,
55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,

Line 52: currency_code ar_cash_receipts.currency_code%TYPE,

48:
49: TYPE Method_Info_Cache_Rec_Type IS RECORD
50: (receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
51: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
52: currency_code ar_cash_receipts.currency_code%TYPE,
53: called_from VARCHAR2(200),
54: state ar_receipt_classes.creation_status%TYPE,
55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,
56: bau_end_date ce_bank_acct_uses.end_date%TYPE,

Line 616: from ar_cash_receipts

612: ELSIF (p_entity = 'REF_RECEIPT' ) THEN
613: --
614: select cash_receipt_id
615: into l_selected_id
616: from ar_cash_receipts
617: where receipt_number = p_value;
618: ELSIF (p_entity = 'REF_REMITTANCE' ) THEN
619: --
620: select batch_id

Line 994: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ) IS

990:
991:
992: PROCEDURE Get_Method_Info_From_Cache(
993: p_method_info_record IN OUT NOCOPY Method_Info_Cache_Rec_Type,
994: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ) IS
995: l_count BINARY_INTEGER;
996: l_index_curr BINARY_INTEGER;
997:
998: BEGIN

Line 1043: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1039: END Get_Method_Info_From_Cache;
1040:
1041:
1042: PROCEDURE Add_Exchange_Rate_To_Cache(
1043: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1044: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1045: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1046: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1047: p_index IN BINARY_INTEGER

Line 1044: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

1040:
1041:
1042: PROCEDURE Add_Exchange_Rate_To_Cache(
1043: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1044: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1045: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1046: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1047: p_index IN BINARY_INTEGER
1048: ) IS

Line 1045: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

1041:
1042: PROCEDURE Add_Exchange_Rate_To_Cache(
1043: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1044: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1045: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1046: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1047: p_index IN BINARY_INTEGER
1048: ) IS
1049: BEGIN

Line 1046: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

1042: PROCEDURE Add_Exchange_Rate_To_Cache(
1043: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1044: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1045: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1046: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1047: p_index IN BINARY_INTEGER
1048: ) IS
1049: BEGIN
1050:

Line 1135: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1131: END default_gl_date;
1132:
1133:
1134: FUNCTION Find_Cached_Exchange_Rate(
1135: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1136: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1137: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
1138: ) RETURN NUMBER IS
1139: l_count BINARY_INTEGER;

Line 1136: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

1132:
1133:
1134: FUNCTION Find_Cached_Exchange_Rate(
1135: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1136: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1137: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
1138: ) RETURN NUMBER IS
1139: l_count BINARY_INTEGER;
1140: l_index_curr BINARY_INTEGER;

Line 1137: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE

1133:
1134: FUNCTION Find_Cached_Exchange_Rate(
1135: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1136: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1137: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
1138: ) RETURN NUMBER IS
1139: l_count BINARY_INTEGER;
1140: l_index_curr BINARY_INTEGER;
1141: l_exchange_rate NUMBER;

Line 1217: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

1213: raise;
1214: END Find_Cached_Exchange_Rate;
1215:
1216: PROCEDURE Default_Receipt_Method_Info(
1217: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1218: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1219: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1220: p_remittance_bank_account_id IN OUT NOCOPY ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1221: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

Line 1218: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1214: END Find_Cached_Exchange_Rate;
1215:
1216: PROCEDURE Default_Receipt_Method_Info(
1217: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1218: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1219: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1220: p_remittance_bank_account_id IN OUT NOCOPY ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1221: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1222: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,

Line 1219: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

1215:
1216: PROCEDURE Default_Receipt_Method_Info(
1217: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1218: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1219: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1220: p_remittance_bank_account_id IN OUT NOCOPY ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1221: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1222: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,
1223: p_called_from IN VARCHAR2,

Line 1228: p_currency_code ar_cash_receipts.currency_code%TYPE,

1224: p_return_status OUT NOCOPY VARCHAR2
1225: ) IS
1226: /*Bug 3518573 changing the logic to pick default remittance bank account */
1227: CURSOR get_remit_bank_acct_id(
1228: p_currency_code ar_cash_receipts.currency_code%TYPE,
1229: p_receipt_date ar_cash_receipts.receipt_date%TYPE,
1230: p_called_from VARCHAR2,
1231: p_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE) is
1232: SELECT ba.bank_acct_use_id,

Line 1229: p_receipt_date ar_cash_receipts.receipt_date%TYPE,

1225: ) IS
1226: /*Bug 3518573 changing the logic to pick default remittance bank account */
1227: CURSOR get_remit_bank_acct_id(
1228: p_currency_code ar_cash_receipts.currency_code%TYPE,
1229: p_receipt_date ar_cash_receipts.receipt_date%TYPE,
1230: p_called_from VARCHAR2,
1231: p_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE) is
1232: SELECT ba.bank_acct_use_id,
1233: rc.creation_status,

Line 1231: p_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE) is

1227: CURSOR get_remit_bank_acct_id(
1228: p_currency_code ar_cash_receipts.currency_code%TYPE,
1229: p_receipt_date ar_cash_receipts.receipt_date%TYPE,
1230: p_called_from VARCHAR2,
1231: p_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE) is
1232: SELECT ba.bank_acct_use_id,
1233: rc.creation_status,
1234: rc.creation_method_code,
1235: rma.start_date rma_start_date,

Line 1435: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,

1431:
1432: /* Bug fix 3315058
1433: Procedure which checks the validity of the different accounts of a payment method */
1434: PROCEDURE Validate_Receipt_Method_ccid(
1435: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
1436: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1437: p_gl_date IN DATE,
1438: p_return_status OUT NOCOPY VARCHAR2
1439: )IS

Line 1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,

1638: raise;
1639: END Get_cross_rate;
1640:
1641: PROCEDURE Default_Currency_info(
1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,

Line 1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

1639: END Get_cross_rate;
1640:
1641: PROCEDURE Default_Currency_info(
1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1647: p_return_status OUT NOCOPY VARCHAR2

Line 1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,

1640:
1641: PROCEDURE Default_Currency_info(
1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1647: p_return_status OUT NOCOPY VARCHAR2
1648: ) IS

Line 1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,

1641: PROCEDURE Default_Currency_info(
1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1647: p_return_status OUT NOCOPY VARCHAR2
1648: ) IS
1649:

Line 1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,

1642: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1643: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1644: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1645: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1646: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1647: p_return_status OUT NOCOPY VARCHAR2
1648: ) IS
1649:
1650: l_euro_to_emu_rate NUMBER;

Line 1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,

1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

Line 1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,

1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */

Line 1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,

1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

Line 1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1777: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1777: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1778: p_receipt_date IN DATE,
1779: p_return_status OUT NOCOPY VARCHAR2,

Line 1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,

1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1777: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1778: p_receipt_date IN DATE,
1779: p_return_status OUT NOCOPY VARCHAR2,
1780: p_default_site_use IN VARCHAR2 --4448307-4509459

Line 1777: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,

1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1777: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1778: p_receipt_date IN DATE,
1779: p_return_status OUT NOCOPY VARCHAR2,
1780: p_default_site_use IN VARCHAR2 --4448307-4509459
1781: )

Line 2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,

2222:
2223: END Default_cash_ids;
2224:
2225: PROCEDURE Get_Cash_Defaults(
2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

Line 2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,

2223: END Default_cash_ids;
2224:
2225: PROCEDURE Get_Cash_Defaults(
2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,

Line 2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,

2224:
2225: PROCEDURE Get_Cash_Defaults(
2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

Line 2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,

2225: PROCEDURE Get_Cash_Defaults(
2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,

Line 2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

2226: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,

Line 2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,

2227: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,

Line 2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

2228: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2229: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2230: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,

Line 2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,

2231: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

Line 2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,

2232: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2240: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

Line 2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,

2233: p_gl_date IN OUT NOCOPY DATE,
2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2240: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2241: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,

Line 2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,

2234: p_maturity_date IN OUT NOCOPY DATE,
2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2240: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2241: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2242: p_called_from IN VARCHAR2,

Line 2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

2235: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2236: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2240: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2241: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2242: p_called_from IN VARCHAR2,
2243: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,

Line 2241: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,

2237: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2238: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2239: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2240: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2241: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2242: p_called_from IN VARCHAR2,
2243: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,
2244: p_return_status OUT NOCOPY VARCHAR2
2245: )

Line 3583: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

3579: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3580: p_customer_trx_line_id IN NUMBER,
3581: p_show_closed_invoices IN VARCHAR2,
3582: p_cr_gl_date IN DATE,
3583: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
3584: p_cr_currency_code IN VARCHAR2,
3585: p_cr_payment_schedule_id IN NUMBER,
3586: p_cr_date IN DATE,
3587: p_called_from IN VARCHAR2,

Line 4236: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

4232: raise;
4233: END Default_Trx_Info;
4234:
4235: PROCEDURE Default_Receipt_Info(
4236: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4237: p_cr_gl_date OUT NOCOPY DATE,
4238: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4240: p_cr_currency_code OUT NOCOPY VARCHAR2,

Line 4238: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,

4234:
4235: PROCEDURE Default_Receipt_Info(
4236: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4237: p_cr_gl_date OUT NOCOPY DATE,
4238: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4240: p_cr_currency_code OUT NOCOPY VARCHAR2,
4241: p_cr_exchange_rate OUT NOCOPY NUMBER,
4242: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

Line 4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,

4235: PROCEDURE Default_Receipt_Info(
4236: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4237: p_cr_gl_date OUT NOCOPY DATE,
4238: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4240: p_cr_currency_code OUT NOCOPY VARCHAR2,
4241: p_cr_exchange_rate OUT NOCOPY NUMBER,
4242: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4243: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

Line 4242: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

4238: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4240: p_cr_currency_code OUT NOCOPY VARCHAR2,
4241: p_cr_exchange_rate OUT NOCOPY NUMBER,
4242: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4243: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
4244: p_cr_unapp_amount OUT NOCOPY NUMBER,
4245: p_cr_payment_schedule_id OUT NOCOPY NUMBER,
4246: p_remittance_bank_account_id OUT NOCOPY NUMBER,

Line 4243: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

4239: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4240: p_cr_currency_code OUT NOCOPY VARCHAR2,
4241: p_cr_exchange_rate OUT NOCOPY NUMBER,
4242: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4243: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
4244: p_cr_unapp_amount OUT NOCOPY NUMBER,
4245: p_cr_payment_schedule_id OUT NOCOPY NUMBER,
4246: p_remittance_bank_account_id OUT NOCOPY NUMBER,
4247: p_receipt_method_id OUT NOCOPY NUMBER,

Line 4278: FROM ar_cash_receipts cr,

4274: p_cr_exchange_rate,
4275: p_cr_payment_schedule_id,
4276: p_remittance_bank_account_id,
4277: p_receipt_method_id
4278: FROM ar_cash_receipts cr,
4279: ar_cash_receipt_history crh,
4280: ar_payment_schedules ps,
4281: ce_bank_acct_uses ba
4282: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and

Line 4313: FROM ar_cash_receipts cr,

4309: p_cr_exchange_rate,
4310: p_cr_payment_schedule_id,
4311: p_remittance_bank_account_id,
4312: p_receipt_method_id
4313: FROM ar_cash_receipts cr,
4314: ar_cash_receipt_history crh,
4315: ar_payment_schedules ps,
4316: ce_bank_acct_uses ba
4317: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and

Line 4662: FROM ar_cash_receipts

4658: THEN
4659: BEGIN
4660: SELECT cash_receipt_id
4661: INTO p_cash_receipt_id
4662: FROM ar_cash_receipts
4663: WHERE receipt_number = p_receipt_number;
4664: EXCEPTION
4665: WHEN no_data_found THEN
4666: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_INVALID');

Line 4857: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

4853: raise;
4854: END Default_appln_ids;
4855:
4856: PROCEDURE Default_application_info(
4857: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4858: p_cr_gl_date OUT NOCOPY DATE,
4859: p_cr_date OUT NOCOPY DATE,
4860: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4861: p_cr_unapp_amount OUT NOCOPY NUMBER,

Line 4860: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,

4856: PROCEDURE Default_application_info(
4857: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4858: p_cr_gl_date OUT NOCOPY DATE,
4859: p_cr_date OUT NOCOPY DATE,
4860: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4861: p_cr_unapp_amount OUT NOCOPY NUMBER,
4862: p_cr_currency_code OUT NOCOPY VARCHAR2,
4863: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
4864: p_installment IN OUT NOCOPY NUMBER,

Line 6104: FROM ar_cash_receipts cr,

6100: /*Get the receipt date and the status */
6101:
6102: SELECT cr.receipt_date, crh.status, cr.type
6103: INTO l_receipt_date, p_receipt_state, p_type
6104: FROM ar_cash_receipts cr,
6105: ar_cash_receipt_history crh
6106: WHERE cr.cash_receipt_id = crh.cash_receipt_id
6107: AND crh.current_record_flag = 'Y'
6108: AND cr.cash_receipt_id = p_cash_receipt_id;

Line 6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6869: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6870: p_return_status OUT NOCOPY VARCHAR2
6871: )IS

Line 7871: FROM ar_cash_receipts

7867: p_desc_flex_rec.attribute9, p_desc_flex_rec.attribute10,
7868: p_desc_flex_rec.attribute11, p_desc_flex_rec.attribute12,
7869: p_desc_flex_rec.attribute13, p_desc_flex_rec.attribute14,
7870: p_desc_flex_rec.attribute15
7871: FROM ar_cash_receipts
7872: WHERE cash_receipt_id = p_cash_receipt_id;
7873: END IF;
7874: IF PG_DEBUG in ('Y', 'C') THEN
7875: arp_util.debug('ar_receipt_lib_pvt.Default_Desc_Flexfield(-)');

Line 8197: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE

8193: RETURN NULL;
8194: END get_legal_entity;
8195:
8196: PROCEDURE default_refund_attributes (
8197: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
8198: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8199: ,p_currency_code IN fnd_currencies.currency_code%TYPE
8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE

Line 8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE

8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
8210: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE

Line 8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE

8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
8210: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
8211: ,x_payment_method_name OUT NOCOPY VARCHAR2

Line 8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE

8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
8210: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
8211: ,x_payment_method_name OUT NOCOPY VARCHAR2
8212: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE

Line 8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE

8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
8207: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
8210: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
8211: ,x_payment_method_name OUT NOCOPY VARCHAR2
8212: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE
8213:

Line 8212: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE

8208: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
8209: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
8210: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
8211: ,x_payment_method_name OUT NOCOPY VARCHAR2
8212: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE
8213:
8214: ,x_bank_account_num OUT NOCOPY VARCHAR2
8215: ,x_payment_reason_code OUT NOCOPY ap_invoices.payment_reason_code%TYPE
8216: ,x_payment_reason_name OUT NOCOPY VARCHAR2

Line 8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;

8222: ,x_msg_data OUT NOCOPY VARCHAR2
8223: )
8224: IS
8225: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;

Line 8227: l_org_id ar_cash_receipts.org_id%TYPE;

8223: )
8224: IS
8225: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;
8231: l_party_site_id hz_parties.party_id%TYPE;

Line 8255: FROM ar_cash_receipts_all

8251: x_exchange_date,
8252: l_org_id,
8253: l_cust_acct_id,
8254: l_site_use_id
8255: FROM ar_cash_receipts_all
8256: WHERE cash_receipt_id = p_cash_receipt_id;
8257: exception when others then null;
8258: end;
8259: ELSE