DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,

55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,
56: bau_end_date ce_bank_acct_uses.end_date%TYPE,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,
59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,
60: rma_end_date ar_receipt_method_accounts.end_date%TYPE
61: );
62:
63: TYPE Id_Cache_Rec_Type IS RECORD

Line 60: rma_end_date ar_receipt_method_accounts.end_date%TYPE

56: bau_end_date ce_bank_acct_uses.end_date%TYPE,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,
59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,
60: rma_end_date ar_receipt_method_accounts.end_date%TYPE
61: );
62:
63: TYPE Id_Cache_Rec_Type IS RECORD
64: ( id VARCHAR2(100),

Line 1216: p_remittance_bank_account_id IN OUT NOCOPY ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,

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,
1220: p_return_status OUT NOCOPY VARCHAR2

Line 1239: ar_receipt_method_accounts rma ,

1235: ba.end_Date bau_end_date
1236: FROM ar_receipt_methods rm,
1237: ce_bank_accounts cba,
1238: ce_bank_acct_uses ba,
1239: ar_receipt_method_accounts rma ,
1240: ar_receipt_classes rc
1241: WHERE rm.receipt_method_id = p_receipt_method_id
1242: and (p_receipt_date
1243: between

Line 1429: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,

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
1433: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;

Line 1434: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;

1430: p_gl_date IN DATE,
1431: p_return_status OUT NOCOPY VARCHAR2
1432: )IS
1433: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1434: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;
1435: l_cash_ccid gl_code_combinations.code_combination_id%type;
1436: l_earned_ccid gl_code_combinations.code_combination_id%type;
1437: l_on_account_ccid gl_code_combinations.code_combination_id%type;
1438: l_unapplied_ccid gl_code_combinations.code_combination_id%type;

Line 1465: FROM ar_receipt_method_accounts rma,

1461: INTO l_cash_ccid,l_earned_ccid,l_on_account_ccid,
1462: l_unapplied_ccid,l_unearned_ccid,l_unidentified_ccid,
1463: l_bank_charges_ccid,l_factor_ccid,l_remittance_ccid,
1464: l_receipt_clearing_ccid,l_short_term_debt_ccid
1465: FROM ar_receipt_method_accounts rma,
1466: ar_receivables_trx art1, ar_receivables_trx art2
1467: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
1468: AND receipt_method_id = p_receipt_method_id
1469: AND art1.receivables_trx_id = rma.edisc_receivables_trx_id