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: org_id ar_receipt_method_accounts.org_id%TYPE
62: );
63:

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: org_id ar_receipt_method_accounts.org_id%TYPE
62: );
63:
64: TYPE Id_Cache_Rec_Type IS RECORD

Line 61: org_id ar_receipt_method_accounts.org_id%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: org_id ar_receipt_method_accounts.org_id%TYPE
62: );
63:
64: TYPE Id_Cache_Rec_Type IS RECORD
65: ( id VARCHAR2(100),

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

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

Line 1244: ar_receipt_method_accounts rma ,

1240: rma.org_id rma_org_id
1241: FROM ar_receipt_methods rm,
1242: ce_bank_accounts cba,
1243: ce_bank_acct_uses ba,
1244: ar_receipt_method_accounts rma ,
1245: ar_receipt_classes rc
1246: WHERE rm.receipt_method_id = p_receipt_method_id
1247: and (p_receipt_date
1248: between

Line 1436: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,

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

Line 1441: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;

1437: p_gl_date IN DATE,
1438: p_return_status OUT NOCOPY VARCHAR2
1439: )IS
1440: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1441: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;
1442: l_cash_ccid gl_code_combinations.code_combination_id%type;
1443: l_earned_ccid gl_code_combinations.code_combination_id%type;
1444: l_on_account_ccid gl_code_combinations.code_combination_id%type;
1445: l_unapplied_ccid gl_code_combinations.code_combination_id%type;

Line 1472: FROM ar_receipt_method_accounts rma,

1468: INTO l_cash_ccid,l_earned_ccid,l_on_account_ccid,
1469: l_unapplied_ccid,l_unearned_ccid,l_unidentified_ccid,
1470: l_bank_charges_ccid,l_factor_ccid,l_remittance_ccid,
1471: l_receipt_clearing_ccid,l_short_term_debt_ccid
1472: FROM ar_receipt_method_accounts rma,
1473: ar_receivables_trx art1, ar_receivables_trx art2
1474: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
1475: AND receipt_method_id = p_receipt_method_id
1476: AND art1.receivables_trx_id = rma.edisc_receivables_trx_id