DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_RECEIPT_CLASSES

Line 54: state ar_receipt_classes.creation_status%TYPE,

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,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,

Line 55: creation_method_code ar_receipt_classes.creation_method_code%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,
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,

Line 1217: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

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
1221: ) IS

Line 1218: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%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
1221: ) IS
1222: /*Bug 3518573 changing the logic to pick default remittance bank account */

Line 1240: ar_receipt_classes rc

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
1244: rm.start_date and

Line 1274: from ar_receipt_classes arc

1270: and ((nvl(p_called_from,'*&#$') <> 'MISC')
1271: or
1272: (rm.receipt_class_id not in (
1273: select arc.receipt_class_id
1274: from ar_receipt_classes arc
1275: where arc.notes_receivable='Y'
1276: or arc.bill_of_exchange_flag='Y')))
1277: order by
1278: decode(rma.primary_flag,'Y',1,'N',2,3),

Line 1338: FROM ar_receipt_classes rc,

1334: SELECT rc.creation_status,
1335: rc.creation_method_code
1336: INTO p_state,
1337: p_creation_method_code
1338: FROM ar_receipt_classes rc,
1339: ar_receipt_methods rm
1340: WHERE rc.receipt_class_id = rm.receipt_class_id
1341: AND rm.receipt_method_id = p_receipt_method_id;
1342:

Line 2233: p_state OUT NOCOPY ar_receipt_classes.creation_status%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,
2237: p_return_status OUT NOCOPY VARCHAR2

Line 2236: p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%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: )
2239: IS
2240: l_cr CONSTANT char(1) := '';