DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on AR_CASH_RECEIPT_HISTORY

Line 30: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

26:
27: ------------------------------------*/
28: PROCEDURE clear(
29: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
30: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
32: p_actual_value_date IN DATE,
33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

Line 31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

27: ------------------------------------*/
28: PROCEDURE clear(
29: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
30: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
32: p_actual_value_date IN DATE,
33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

Line 33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

29: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
30: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
32: p_actual_value_date IN DATE,
33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
36: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,

Line 34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

30: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
32: p_actual_value_date IN DATE,
33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
36: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,

Line 35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

31: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
32: p_actual_value_date IN DATE,
33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
36: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
39: p_module_name IN VARCHAR2,

Line 37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,

33: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
36: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2,
41: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

Line 38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,

34: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
35: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
36: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2,
41: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
42:

Line 41: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

37: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
38: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2,
41: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
42:
43: PROCEDURE unclear(
44: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
45: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

Line 45: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

41: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
42:
43: PROCEDURE unclear(
44: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
45: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
46: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
47: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
48: p_module_name IN VARCHAR2,
49: p_module_version IN VARCHAR2,

Line 46: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

42:
43: PROCEDURE unclear(
44: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
45: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
46: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
47: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
48: p_module_name IN VARCHAR2,
49: p_module_version IN VARCHAR2,
50: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

Line 50: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

46: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
47: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
48: p_module_name IN VARCHAR2,
49: p_module_version IN VARCHAR2,
50: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
51:
52: PROCEDURE risk_eliminate(
53: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
54: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

Line 54: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

50: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
51:
52: PROCEDURE risk_eliminate(
53: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
54: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
55: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
56: p_module_name IN VARCHAR2,
57: p_module_version IN VARCHAR2,
58: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

Line 55: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

51:
52: PROCEDURE risk_eliminate(
53: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
54: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
55: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
56: p_module_name IN VARCHAR2,
57: p_module_version IN VARCHAR2,
58: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
59:

Line 58: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

54: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
55: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
56: p_module_name IN VARCHAR2,
57: p_module_version IN VARCHAR2,
58: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
59:
60: PROCEDURE undo_risk_eliminate(
61: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
62: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

Line 62: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

58: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
59:
60: PROCEDURE undo_risk_eliminate(
61: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
62: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
63: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
64: p_module_name IN VARCHAR2,
65: p_module_version IN VARCHAR2,
66: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

Line 63: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

59:
60: PROCEDURE undo_risk_eliminate(
61: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
62: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
63: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
64: p_module_name IN VARCHAR2,
65: p_module_version IN VARCHAR2,
66: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
67:

Line 66: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );

62: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
63: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
64: p_module_name IN VARCHAR2,
65: p_module_version IN VARCHAR2,
66: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE );
67:
68: PROCEDURE ins_misc_txn(
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
70: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,

Line 72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

68: PROCEDURE ins_misc_txn(
69: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
70: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
71: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
74: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
75: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 77: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

73: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
74: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
75: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
78: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
79: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
80: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
81: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 78: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

74: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
75: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
78: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
79: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
80: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
81: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
82: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

Line 79: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

75: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
78: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
79: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
80: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
81: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
82: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
83: p_comments IN ar_cash_receipts.comments%TYPE,

Line 96: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

92: p_tax_rate IN NUMBER );
93:
94: PROCEDURE reverse(
95: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
96: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
97: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
98: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
99: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
100: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

Line 103: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE);

99: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
100: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
101: p_module_name IN VARCHAR2,
102: p_module_version IN VARCHAR2,
103: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE);
104:
105: PROCEDURE debit_memo_reversal(
106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,

Line 110: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
108: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
109: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
110: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
111: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
112: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
113: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
114: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 124: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,

120: p_module_version IN VARCHAR2);
121:
122: PROCEDURE Lock_Row(
123: P_BATCH_ID IN ar_batches.batch_id%TYPE,
124: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
125: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
126: P_NAME IN ar_batches.name%TYPE,
127: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
128: P_GL_DATE IN ar_batches.gl_date%TYPE,

Line 125: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,

121:
122: PROCEDURE Lock_Row(
123: P_BATCH_ID IN ar_batches.batch_id%TYPE,
124: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
125: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
126: P_NAME IN ar_batches.name%TYPE,
127: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
128: P_GL_DATE IN ar_batches.gl_date%TYPE,
129: P_STATUS IN ar_batches.status%TYPE,