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 613: from ar_cash_receipts

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

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

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

Line 1039: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1035: END Get_Method_Info_From_Cache;
1036:
1037:
1038: PROCEDURE Add_Exchange_Rate_To_Cache(
1039: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1040: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1041: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1042: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1043: p_index IN BINARY_INTEGER

Line 1040: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

1036:
1037:
1038: PROCEDURE Add_Exchange_Rate_To_Cache(
1039: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1040: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1041: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1042: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1043: p_index IN BINARY_INTEGER
1044: ) IS

Line 1041: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

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

Line 1042: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

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

Line 1131: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1127: END default_gl_date;
1128:
1129:
1130: FUNCTION Find_Cached_Exchange_Rate(
1131: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1132: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1133: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
1134: ) RETURN NUMBER IS
1135: l_count BINARY_INTEGER;

Line 1132: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

1128:
1129:
1130: FUNCTION Find_Cached_Exchange_Rate(
1131: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1132: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1133: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE
1134: ) RETURN NUMBER IS
1135: l_count BINARY_INTEGER;
1136: l_index_curr BINARY_INTEGER;

Line 1133: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE

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

Line 1213: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

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

Line 1214: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

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

Line 1215: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

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

Line 1224: p_currency_code ar_cash_receipts.currency_code%TYPE,

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

Line 1225: p_receipt_date ar_cash_receipts.receipt_date%TYPE,

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

Line 1227: p_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE) is

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

Line 1428: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,

1424:
1425: /* Bug fix 3315058
1426: Procedure which checks the validity of the different accounts of a payment method */
1427: PROCEDURE Validate_Receipt_Method_ccid(
1428: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
1429: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1430: p_gl_date IN DATE,
1431: p_return_status OUT NOCOPY VARCHAR2
1432: )IS

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

1631: raise;
1632: END Get_cross_rate;
1633:
1634: PROCEDURE Default_Currency_info(
1635: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1636: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1637: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1638: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1639: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,

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

1632: END Get_cross_rate;
1633:
1634: PROCEDURE Default_Currency_info(
1635: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1636: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1637: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1638: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1639: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1640: p_return_status OUT NOCOPY VARCHAR2

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

1633:
1634: PROCEDURE Default_Currency_info(
1635: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1636: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1637: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1638: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1639: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1640: p_return_status OUT NOCOPY VARCHAR2
1641: ) IS

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

1634: PROCEDURE Default_Currency_info(
1635: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1636: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1637: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1638: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1639: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1640: p_return_status OUT NOCOPY VARCHAR2
1641: ) IS
1642:

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

1635: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1636: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
1637: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
1638: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1639: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
1640: p_return_status OUT NOCOPY VARCHAR2
1641: ) IS
1642:
1643: l_euro_to_emu_rate NUMBER;

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

1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

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

1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */

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

1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

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

1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1769: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1770: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,

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

1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1769: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1770: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1771: p_receipt_date IN DATE,
1772: p_return_status OUT NOCOPY VARCHAR2,

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

1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1769: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1770: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1771: p_receipt_date IN DATE,
1772: p_return_status OUT NOCOPY VARCHAR2,
1773: p_default_site_use IN VARCHAR2 --4448307-4509459

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

1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1769: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
1770: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1771: p_receipt_date IN DATE,
1772: p_return_status OUT NOCOPY VARCHAR2,
1773: p_default_site_use IN VARCHAR2 --4448307-4509459
1774: )

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

2215:
2216: END Default_cash_ids;
2217:
2218: PROCEDURE Get_Cash_Defaults(
2219: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

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

2216: END Default_cash_ids;
2217:
2218: PROCEDURE Get_Cash_Defaults(
2219: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,

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

2217:
2218: PROCEDURE Get_Cash_Defaults(
2219: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

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

2218: PROCEDURE Get_Cash_Defaults(
2219: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,

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

2219: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,

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

2220: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,

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

2221: p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
2222: p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
2223: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,

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

2224: p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,

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

2225: p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

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

2226: p_gl_date IN OUT NOCOPY DATE,
2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2234: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,

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

2227: p_maturity_date IN OUT NOCOPY DATE,
2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2234: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2235: p_called_from IN VARCHAR2,

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

2228: p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
2229: p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2234: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2235: p_called_from IN VARCHAR2,
2236: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,

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

2230: p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2231: p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
2232: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
2234: p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
2235: p_called_from IN VARCHAR2,
2236: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,
2237: p_return_status OUT NOCOPY VARCHAR2
2238: )

Line 3401: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

3397: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3398: p_customer_trx_line_id IN NUMBER,
3399: p_show_closed_invoices IN VARCHAR2,
3400: p_cr_gl_date IN DATE,
3401: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
3402: p_cr_currency_code IN VARCHAR2,
3403: p_cr_payment_schedule_id IN NUMBER,
3404: p_cr_date IN DATE,
3405: p_called_from IN VARCHAR2,

Line 4007: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

4003: raise;
4004: END Default_Trx_Info;
4005:
4006: PROCEDURE Default_Receipt_Info(
4007: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4008: p_cr_gl_date OUT NOCOPY DATE,
4009: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4010: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4011: p_cr_currency_code OUT NOCOPY VARCHAR2,

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

4005:
4006: PROCEDURE Default_Receipt_Info(
4007: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4008: p_cr_gl_date OUT NOCOPY DATE,
4009: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4010: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4011: p_cr_currency_code OUT NOCOPY VARCHAR2,
4012: p_cr_exchange_rate OUT NOCOPY NUMBER,
4013: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

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

4006: PROCEDURE Default_Receipt_Info(
4007: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4008: p_cr_gl_date OUT NOCOPY DATE,
4009: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4010: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4011: p_cr_currency_code OUT NOCOPY VARCHAR2,
4012: p_cr_exchange_rate OUT NOCOPY NUMBER,
4013: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4014: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,

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

4009: p_cr_customer_id OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
4010: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4011: p_cr_currency_code OUT NOCOPY VARCHAR2,
4012: p_cr_exchange_rate OUT NOCOPY NUMBER,
4013: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4014: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
4015: p_cr_unapp_amount OUT NOCOPY NUMBER,
4016: p_cr_payment_schedule_id OUT NOCOPY NUMBER,
4017: p_remittance_bank_account_id OUT NOCOPY NUMBER,

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

4010: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4011: p_cr_currency_code OUT NOCOPY VARCHAR2,
4012: p_cr_exchange_rate OUT NOCOPY NUMBER,
4013: p_cr_cust_site_use_id OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
4014: p_cr_date OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
4015: p_cr_unapp_amount OUT NOCOPY NUMBER,
4016: p_cr_payment_schedule_id OUT NOCOPY NUMBER,
4017: p_remittance_bank_account_id OUT NOCOPY NUMBER,
4018: p_receipt_method_id OUT NOCOPY NUMBER,

Line 4049: FROM ar_cash_receipts cr,

4045: p_cr_exchange_rate,
4046: p_cr_payment_schedule_id,
4047: p_remittance_bank_account_id,
4048: p_receipt_method_id
4049: FROM ar_cash_receipts cr,
4050: ar_cash_receipt_history crh,
4051: ar_payment_schedules ps,
4052: ce_bank_acct_uses ba
4053: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and

Line 4084: FROM ar_cash_receipts cr,

4080: p_cr_exchange_rate,
4081: p_cr_payment_schedule_id,
4082: p_remittance_bank_account_id,
4083: p_receipt_method_id
4084: FROM ar_cash_receipts cr,
4085: ar_cash_receipt_history crh,
4086: ar_payment_schedules ps,
4087: ce_bank_acct_uses ba
4088: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and

Line 4433: FROM ar_cash_receipts

4429: THEN
4430: BEGIN
4431: SELECT cash_receipt_id
4432: INTO p_cash_receipt_id
4433: FROM ar_cash_receipts
4434: WHERE receipt_number = p_receipt_number;
4435: EXCEPTION
4436: WHEN no_data_found THEN
4437: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_INVALID');

Line 4628: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

4624: raise;
4625: END Default_appln_ids;
4626:
4627: PROCEDURE Default_application_info(
4628: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4629: p_cr_gl_date OUT NOCOPY DATE,
4630: p_cr_date OUT NOCOPY DATE,
4631: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4632: p_cr_unapp_amount OUT NOCOPY NUMBER,

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

4627: PROCEDURE Default_application_info(
4628: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
4629: p_cr_gl_date OUT NOCOPY DATE,
4630: p_cr_date OUT NOCOPY DATE,
4631: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4632: p_cr_unapp_amount OUT NOCOPY NUMBER,
4633: p_cr_currency_code OUT NOCOPY VARCHAR2,
4634: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
4635: p_installment IN OUT NOCOPY NUMBER,

Line 5832: FROM ar_cash_receipts cr,

5828: /*Get the receipt date and the status */
5829:
5830: SELECT cr.receipt_date, crh.status, cr.type
5831: INTO l_receipt_date, p_receipt_state, p_type
5832: FROM ar_cash_receipts cr,
5833: ar_cash_receipt_history crh
5834: WHERE cr.cash_receipt_id = crh.cash_receipt_id
5835: AND crh.current_record_flag = 'Y'
5836: AND cr.cash_receipt_id = p_cash_receipt_id;

Line 6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6582: p_return_status OUT NOCOPY VARCHAR2
6583: )IS

Line 7572: FROM ar_cash_receipts

7568: p_desc_flex_rec.attribute9, p_desc_flex_rec.attribute10,
7569: p_desc_flex_rec.attribute11, p_desc_flex_rec.attribute12,
7570: p_desc_flex_rec.attribute13, p_desc_flex_rec.attribute14,
7571: p_desc_flex_rec.attribute15
7572: FROM ar_cash_receipts
7573: WHERE cash_receipt_id = p_cash_receipt_id;
7574: END IF;
7575: IF PG_DEBUG in ('Y', 'C') THEN
7576: arp_util.debug('ar_receipt_lib_pvt.Default_Desc_Flexfield(-)');

Line 7898: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE

7894: RETURN NULL;
7895: END get_legal_entity;
7896:
7897: PROCEDURE default_refund_attributes (
7898: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
7899: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
7900: ,p_currency_code IN fnd_currencies.currency_code%TYPE
7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE

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

7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
7910: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
7911: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE

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

7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
7910: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
7911: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
7912: ,x_payment_method_name OUT NOCOPY VARCHAR2

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

7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
7910: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
7911: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
7912: ,x_payment_method_name OUT NOCOPY VARCHAR2
7913: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE

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

7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
7908: ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
7910: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
7911: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
7912: ,x_payment_method_name OUT NOCOPY VARCHAR2
7913: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE
7914:

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

7909: ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
7910: ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
7911: ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
7912: ,x_payment_method_name OUT NOCOPY VARCHAR2
7913: ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE
7914:
7915: ,x_bank_account_num OUT NOCOPY VARCHAR2
7916: ,x_payment_reason_code OUT NOCOPY ap_invoices.payment_reason_code%TYPE
7917: ,x_payment_reason_name OUT NOCOPY VARCHAR2

Line 7927: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;

7923: ,x_msg_data OUT NOCOPY VARCHAR2
7924: )
7925: IS
7926: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
7927: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7928: l_org_id ar_cash_receipts.org_id%TYPE;
7929: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
7931: l_party_id hz_parties.party_id%TYPE;

Line 7928: l_org_id ar_cash_receipts.org_id%TYPE;

7924: )
7925: IS
7926: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
7927: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7928: l_org_id ar_cash_receipts.org_id%TYPE;
7929: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
7931: l_party_id hz_parties.party_id%TYPE;
7932: l_party_site_id hz_parties.party_id%TYPE;

Line 7956: FROM ar_cash_receipts_all

7952: x_exchange_date,
7953: l_org_id,
7954: l_cust_acct_id,
7955: l_site_use_id
7956: FROM ar_cash_receipts_all
7957: WHERE cash_receipt_id = p_cash_receipt_id;
7958: exception when others then null;
7959: end;
7960: ELSE