18: );
19:
20: PROCEDURE insert_crh_rec(
21: p_cr_rec IN ar_cash_receipts%ROWTYPE,
22: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
23: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
24: p_factor_discount_amount IN
25: ar_cash_receipt_history.factor_discount_amount%TYPE,
26: p_acctd_factor_discount_amount IN
19:
20: PROCEDURE insert_crh_rec(
21: p_cr_rec IN ar_cash_receipts%ROWTYPE,
22: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
23: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
24: p_factor_discount_amount IN
25: ar_cash_receipt_history.factor_discount_amount%TYPE,
26: p_acctd_factor_discount_amount IN
27: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
21: p_cr_rec IN ar_cash_receipts%ROWTYPE,
22: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
23: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
24: p_factor_discount_amount IN
25: ar_cash_receipt_history.factor_discount_amount%TYPE,
26: p_acctd_factor_discount_amount IN
27: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
28: p_gl_date IN DATE,
29: p_creation_status IN VARCHAR2,
23: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
24: p_factor_discount_amount IN
25: ar_cash_receipt_history.factor_discount_amount%TYPE,
26: p_acctd_factor_discount_amount IN
27: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
28: p_gl_date IN DATE,
29: p_creation_status IN VARCHAR2,
30: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
31: p_ccid IN
26: p_acctd_factor_discount_amount IN
27: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
28: p_gl_date IN DATE,
29: p_creation_status IN VARCHAR2,
30: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
31: p_ccid IN
32: ar_cash_receipt_history.account_code_combination_id%TYPE,
33: p_bank_charges_ccid IN
34: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
28: p_gl_date IN DATE,
29: p_creation_status IN VARCHAR2,
30: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
31: p_ccid IN
32: ar_cash_receipt_history.account_code_combination_id%TYPE,
33: p_bank_charges_ccid IN
34: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
35: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
36: );
30: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
31: p_ccid IN
32: ar_cash_receipt_history.account_code_combination_id%TYPE,
33: p_bank_charges_ccid IN
34: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
35: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
36: );
37:
38: PROCEDURE insert_ra_rec_cash(
31: p_ccid IN
32: ar_cash_receipt_history.account_code_combination_id%TYPE,
33: p_bank_charges_ccid IN
34: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
35: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
36: );
37:
38: PROCEDURE insert_ra_rec_cash(
39: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
54: );
55:
56: PROCEDURE insert_dist_rec(
57: p_amount IN ar_cash_receipts.amount%TYPE,
58: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
59: p_crh_id IN
60: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
61: p_source_type IN ar_distributions.source_type%TYPE,
62: p_ccid IN ar_distributions.code_combination_id%TYPE
56: PROCEDURE insert_dist_rec(
57: p_amount IN ar_cash_receipts.amount%TYPE,
58: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
59: p_crh_id IN
60: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
61: p_source_type IN ar_distributions.source_type%TYPE,
62: p_ccid IN ar_distributions.code_combination_id%TYPE
63: );
64:
68:
69:
70: PROCEDURE insert_misc_dist(
71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
84:
85: PROCEDURE update_misc_dist(
86: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
98: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
102:
103: PROCEDURE create_mcd_recs(
104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
113: );
115:
116: PROCEDURE update_manual_dist(
117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
124: );
125:
126: