eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_REVERSE_RECEIPT dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --
44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --
50: PROCEDURE insert_reversal_crh_record(

Line 47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,

43: --
44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --
50: PROCEDURE insert_reversal_crh_record(
51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

Line 52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --
50: PROCEDURE insert_reversal_crh_record(
51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
54: p_clear_batch_id IN VARCHAR2,
55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
56: );

Line 53: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,

49: --
50: PROCEDURE insert_reversal_crh_record(
51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
54: p_clear_batch_id IN VARCHAR2,
55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
56: );
57: --

Line 59: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,

55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
56: );
57: --
58: PROCEDURE insert_reversal_mcd_record(
59: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
60: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );
62: --
63: PROCEDURE insert_reversal_dist_rec(

Line 60: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

56: );
57: --
58: PROCEDURE insert_reversal_mcd_record(
59: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
60: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );
62: --
63: PROCEDURE insert_reversal_dist_rec(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

Line 61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );

57: --
58: PROCEDURE insert_reversal_mcd_record(
59: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
60: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );
62: --
63: PROCEDURE insert_reversal_dist_rec(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
65: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );

Line 161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
159: l_crh_rec ar_cash_receipt_history%ROWTYPE;
160: l_batches_rec ar_batches%ROWTYPE;
161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
162: /*CCR-add cursor for receipt method pkt */
163:
164: --
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

164: --
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;
170: l_rt_type ar_receivables_trx.type%TYPE;
171:
172: --

Line 227: FROM ar_misc_cash_distributions

223: ORDER BY decode(status,'APP',1,'ACTIVITY',2,'ACC',3,'OTHER ACC',4,'UNID',5,'UNAPP',6); --VAT 11.5 for pairing UNAPP records
224: --
225: CURSOR ar_mcd_C( p_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
226: SELECT *
227: FROM ar_misc_cash_distributions
228: WHERE cash_receipt_id = p_cr_id
229: AND reversal_gl_date is null;
230: --
231: /*CCRR- need to find the application id associated with the Negative Misc receipt pkt*/

Line 893: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

889: | |
890: +===========================================================================*/
891: PROCEDURE insert_reversal_crh_record(
892: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
893: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
894: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
895: p_clear_batch_id IN VARCHAR2,
896: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
897: ) IS

Line 894: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,

890: +===========================================================================*/
891: PROCEDURE insert_reversal_crh_record(
892: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
893: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
894: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
895: p_clear_batch_id IN VARCHAR2,
896: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
897: ) IS
898: --Bug#2750340

Line 1010: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

1006: | |
1007: +===========================================================================*/
1008: PROCEDURE update_current_crh_record(
1009: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
1010: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1011: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
1012: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1013:
1014: --Bug#2750340

Line 1011: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,

1007: +===========================================================================*/
1008: PROCEDURE update_current_crh_record(
1009: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
1010: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1011: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
1012: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1013:
1014: --Bug#2750340
1015: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 1067: | AR_MISC_CASH_DISTRIBUTIONS table|

1063: | SCOPE - PRIVATE |
1064: | |
1065: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1066: | arp_misc_cash_dist_pkg.insert_p - Insertion table handler for |
1067: | AR_MISC_CASH_DISTRIBUTIONS table|
1068: | |
1069: | ARGUMENTS : IN: |
1070: | p_mcd_rec - Misc cash distributions receord structure |
1071: | p_reversal_gl_date - Reversal GL date |

Line 1087: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,

1083: | created_from variables |
1084: | |
1085: +===========================================================================*/
1086: PROCEDURE insert_reversal_mcd_record(
1087: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
1088: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1089: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE ) IS
1090: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
1091: l_ae_doc_rec ae_doc_rec_type;

Line 1088: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

1084: | |
1085: +===========================================================================*/
1086: PROCEDURE insert_reversal_mcd_record(
1087: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
1088: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1089: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE ) IS
1090: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
1091: l_ae_doc_rec ae_doc_rec_type;
1092:

Line 1089: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE ) IS

1085: +===========================================================================*/
1086: PROCEDURE insert_reversal_mcd_record(
1087: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
1088: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1089: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE ) IS
1090: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
1091: l_ae_doc_rec ae_doc_rec_type;
1092:
1093: BEGIN

Line 1090: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

1086: PROCEDURE insert_reversal_mcd_record(
1087: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,
1088: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1089: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE ) IS
1090: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
1091: l_ae_doc_rec ae_doc_rec_type;
1092:
1093: BEGIN
1094: IF PG_DEBUG in ('Y', 'C') THEN