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_CONFIRMATION dependencies on AR_DISTRIBUTIONS

Line 146: -- this receipt. This call will also create a new ar_distributions

142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;
144:
145: -- update the ar_cash_receipt_history_table with a new record for
146: -- this receipt. This call will also create a new ar_distributions
147: -- record.
148:
149: update_cr_history_confirm( l_cr_rec,
150: p_confirm_gl_date,

Line 289: -- this receipt. This call will also create a new ar_distributions

285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;
287:
288: -- update the ar_cash_receipt_history_table with a new record for
289: -- this receipt. This call will also create a new ar_distributions
290: -- record to reverse the 'confirm' record.
291:
292: update_cr_history_unconfirm( l_cr_rec,
293: p_confirm_gl_date,

Line 808: --confirmed APP record in ar_distributions. In this case we create

804: arp_standard.debug('-- MRC ra record updated if necessary');
805:
806: --
807: --Release 11.5 VAT changes, create the application accounting for
808: --confirmed APP record in ar_distributions. In this case we create
809: --the APP directly as only confirmed APP records have accounting created
810: --basically we dont require the module below to be called in update mode
811: --(delete + create)
812: --

Line 1014: | 'CONFIRMED'. Also creates an ar_distributions record for |

1010: | |
1011: | DESCRIPTION |
1012: | Creates a new entry for the cash_receipt_history table. |
1013: | It will have the updated receipt amount and the status |
1014: | 'CONFIRMED'. Also creates an ar_distributions record for |
1015: | the new history record. |
1016: | |
1017: | SCOPE - PRIVATE |
1018: | |

Line 1055: l_dist_rec ar_distributions%ROWTYPE;

1051: --
1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1054: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1055: l_dist_rec ar_distributions%ROWTYPE;
1056: l_dist_line_id ar_distributions.line_id%TYPE;
1057:
1058: --
1059: BEGIN

Line 1056: l_dist_line_id ar_distributions.line_id%TYPE;

1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1054: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1055: l_dist_rec ar_distributions%ROWTYPE;
1056: l_dist_line_id ar_distributions.line_id%TYPE;
1057:
1058: --
1059: BEGIN
1060:

Line 1119: -- create ar_distributions record for new history record:

1115: arp_cr_history_pkg.update_p(l_crh_rec_old);
1116:
1117: arp_standard.debug('-- previous record updated');
1118:
1119: -- create ar_distributions record for new history record:
1120:
1121: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);
1122: l_dist_rec.source_id := l_crh_id_new;
1123: l_dist_rec.source_table := 'CRH';

Line 1164: p_table_name => 'AR_DISTRIBUTIONS',

1160: mrc engine */
1161:
1162: ar_mrc_engine2.maintain_mrc_data2(
1163: p_event_mode => 'INSERT',
1164: p_table_name => 'AR_DISTRIBUTIONS',
1165: p_mode => 'SINGLE',
1166: p_key_value => l_dist_line_id,
1167: p_row_info => l_dist_rec);
1168:

Line 1312: --id is required to create the accounting in the AR_DISTRIBUTIONS table

1308: BEGIN
1309:
1310: --
1311: --Release 11.5 VAT changes retrieve the unconfirmed UNAPP record as the application
1312: --id is required to create the accounting in the AR_DISTRIBUTIONS table
1313: --moved where clause from update to select
1314:
1315: SELECT app.receivable_application_id
1316: INTO l_receivable_application_id

Line 1345: --confirmed UNAPP record in ar_distributions. In this case we create

1341: l_receivable_application_id);
1342:
1343: --
1344: --Release 11.5 VAT changes, create the application accounting for
1345: --confirmed UNAPP record in ar_distributions. In this case we create
1346: --the UNAPP directly as only confirmed UNAPP records have accounting created
1347: --
1348: l_ae_doc_rec.document_type := 'RECEIPT';
1349: l_ae_doc_rec.document_id := p_cr_id;

Line 1423: cursor to PAIR the UNAPP record in ar_distributions to the APP record correctly

1419: in such cases the previous insert was failing with a Unique constraint
1420: voilation on the receivable application id.
1421: With this modification the p_app_id passed as a parameter is effectively
1422: unncessary, and instead using the rec_app_id of the APP record from the
1423: cursor to PAIR the UNAPP record in ar_distributions to the APP record correctly
1424: */
1425:
1426: CURSOR get_rec_records IS
1427: SELECT app.receivable_application_id app_id,

Line 1609: --confirmed UNAPP record in ar_distributions. In this case we create

1605: p_rec_app_id => l_unapp_rec.app_id,
1606: p_rec_unapp_id => l_unapp_id);
1607: --
1608: --Release 11.5 VAT changes, create the application accounting for
1609: --confirmed UNAPP record in ar_distributions. In this case we create
1610: --the UNAPP directly as only confirmed UNAPP records have accounting created
1611: --basically we dont require the module below to be called in update mode
1612: --(delete + create)
1613:

Line 1700: | 'APPROVED'. Also creates an ar_distributions record for |

1696: | |
1697: | DESCRIPTION |
1698: | Creates a new entry for the cash_receipt_history table. |
1699: | It will have the updated receipt amount and the status |
1700: | 'APPROVED'. Also creates an ar_distributions record for |
1701: | the new history record. |
1702: | |
1703: | SCOPE - PRIVATE |
1704: | |

Line 1745: l_dist_rec ar_distributions%ROWTYPE;

1741:
1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1746: l_dist_line_id ar_distributions.line_id%TYPE;

1742: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1743: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1744: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1745: l_dist_rec ar_distributions%ROWTYPE;
1746: l_dist_line_id ar_distributions.line_id%TYPE;
1747: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1748: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1750:

Line 1818: -- create ar_distributions record for new history record.

1814: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_id_new;
1815: arp_cr_history_pkg.update_p(l_crh_rec_old);
1816:
1817:
1818: -- create ar_distributions record for new history record.
1819: -- first fetch record that was created for the history table
1820: -- record to be reversed:
1821:
1822: arp_distributions_pkg.fetch_pk(l_crh_id_rev,

Line 1860: p_table_name => 'AR_DISTRIBUTIONS',

1856: mrc engine */
1857:
1858: ar_mrc_engine2.maintain_mrc_data2(
1859: p_event_mode => 'INSERT',
1860: p_table_name => 'AR_DISTRIBUTIONS',
1861: p_mode => 'SINGLE',
1862: p_key_value => l_dist_line_id,
1863: p_row_info => l_dist_rec);
1864:

Line 2254: --confirmed records in ar_distributions.

2250:
2251:
2252: --
2253: --Release 11.5 VAT changes, reverse the application accounting for
2254: --confirmed records in ar_distributions.
2255: --
2256: l_ae_doc_rec.document_type := 'RECEIPT';
2257: l_ae_doc_rec.document_id := p_cr_rec.cash_receipt_id;
2258: l_ae_doc_rec.accounting_entity_level := 'ONE';