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 1221: p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

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

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

Line 1245: ar_receipt_classes rc

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

Line 1279: from ar_receipt_classes arc

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

Line 1345: FROM ar_receipt_classes rc,

1341: SELECT rc.creation_status,
1342: rc.creation_method_code
1343: INTO p_state,
1344: p_creation_method_code
1345: FROM ar_receipt_classes rc,
1346: ar_receipt_methods rm
1347: WHERE rc.receipt_class_id = rm.receipt_class_id
1348: AND rm.receipt_method_id = p_receipt_method_id;
1349:

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

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