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 147: -- this receipt. This call will also create a new ar_distributions

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

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

302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;
304:
305: -- update the ar_cash_receipt_history_table with a new record for
306: -- this receipt. This call will also create a new ar_distributions
307: -- record to reverse the 'confirm' record.
308:
309: update_cr_history_unconfirm( l_cr_rec,
310: p_confirm_gl_date,

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

821: arp_standard.debug('-- MRC ra record updated if necessary');
822:
823: --
824: --Release 11.5 VAT changes, create the application accounting for
825: --confirmed APP record in ar_distributions. In this case we create
826: --the APP directly as only confirmed APP records have accounting created
827: --basically we dont require the module below to be called in update mode
828: --(delete + create)
829: --

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

1027: | |
1028: | DESCRIPTION |
1029: | Creates a new entry for the cash_receipt_history table. |
1030: | It will have the updated receipt amount and the status |
1031: | 'CONFIRMED'. Also creates an ar_distributions record for |
1032: | the new history record. |
1033: | |
1034: | SCOPE - PRIVATE |
1035: | |

Line 1072: l_dist_rec ar_distributions%ROWTYPE;

1068: --
1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1071: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1072: l_dist_rec ar_distributions%ROWTYPE;
1073: l_dist_line_id ar_distributions.line_id%TYPE;
1074:
1075: --
1076: BEGIN

Line 1073: l_dist_line_id ar_distributions.line_id%TYPE;

1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1071: l_crh_id_new ar_cash_receipts.cash_receipt_id%TYPE;
1072: l_dist_rec ar_distributions%ROWTYPE;
1073: l_dist_line_id ar_distributions.line_id%TYPE;
1074:
1075: --
1076: BEGIN
1077:

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

1132: arp_cr_history_pkg.update_p(l_crh_rec_old);
1133:
1134: arp_standard.debug('-- previous record updated');
1135:
1136: -- create ar_distributions record for new history record:
1137:
1138: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);
1139: l_dist_rec.source_id := l_crh_id_new;
1140: l_dist_rec.source_table := 'CRH';

Line 1181: p_table_name => 'AR_DISTRIBUTIONS',

1177: mrc engine */
1178:
1179: ar_mrc_engine2.maintain_mrc_data2(
1180: p_event_mode => 'INSERT',
1181: p_table_name => 'AR_DISTRIBUTIONS',
1182: p_mode => 'SINGLE',
1183: p_key_value => l_dist_line_id,
1184: p_row_info => l_dist_rec);
1185:

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

1325: BEGIN
1326:
1327: --
1328: --Release 11.5 VAT changes retrieve the unconfirmed UNAPP record as the application
1329: --id is required to create the accounting in the AR_DISTRIBUTIONS table
1330: --moved where clause from update to select
1331:
1332: SELECT app.receivable_application_id
1333: INTO l_receivable_application_id

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

1358: l_receivable_application_id);
1359:
1360: --
1361: --Release 11.5 VAT changes, create the application accounting for
1362: --confirmed UNAPP record in ar_distributions. In this case we create
1363: --the UNAPP directly as only confirmed UNAPP records have accounting created
1364: --
1365: l_ae_doc_rec.document_type := 'RECEIPT';
1366: l_ae_doc_rec.document_id := p_cr_id;

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

1436: in such cases the previous insert was failing with a Unique constraint
1437: voilation on the receivable application id.
1438: With this modification the p_app_id passed as a parameter is effectively
1439: unncessary, and instead using the rec_app_id of the APP record from the
1440: cursor to PAIR the UNAPP record in ar_distributions to the APP record correctly
1441: */
1442:
1443: CURSOR get_rec_records IS
1444: SELECT app.receivable_application_id app_id,

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

1622: p_rec_app_id => l_unapp_rec.app_id,
1623: p_rec_unapp_id => l_unapp_id);
1624: --
1625: --Release 11.5 VAT changes, create the application accounting for
1626: --confirmed UNAPP record in ar_distributions. In this case we create
1627: --the UNAPP directly as only confirmed UNAPP records have accounting created
1628: --basically we dont require the module below to be called in update mode
1629: --(delete + create)
1630:

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

1713: | |
1714: | DESCRIPTION |
1715: | Creates a new entry for the cash_receipt_history table. |
1716: | It will have the updated receipt amount and the status |
1717: | 'APPROVED'. Also creates an ar_distributions record for |
1718: | the new history record. |
1719: | |
1720: | SCOPE - PRIVATE |
1721: | |

Line 1762: l_dist_rec ar_distributions%ROWTYPE;

1758:
1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1763: l_dist_line_id ar_distributions.line_id%TYPE;

1759: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1760: l_crh_rec_prev_stat ar_cash_receipt_history%ROWTYPE;
1761: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1762: l_dist_rec ar_distributions%ROWTYPE;
1763: l_dist_line_id ar_distributions.line_id%TYPE;
1764: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
1765: l_crh_id_rev ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:

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

1831: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_id_new;
1832: arp_cr_history_pkg.update_p(l_crh_rec_old);
1833:
1834:
1835: -- create ar_distributions record for new history record.
1836: -- first fetch record that was created for the history table
1837: -- record to be reversed:
1838:
1839: arp_distributions_pkg.fetch_pk(l_crh_id_rev,

Line 1877: p_table_name => 'AR_DISTRIBUTIONS',

1873: mrc engine */
1874:
1875: ar_mrc_engine2.maintain_mrc_data2(
1876: p_event_mode => 'INSERT',
1877: p_table_name => 'AR_DISTRIBUTIONS',
1878: p_mode => 'SINGLE',
1879: p_key_value => l_dist_line_id,
1880: p_row_info => l_dist_rec);
1881:

Line 2271: --confirmed records in ar_distributions.

2267:
2268:
2269: --
2270: --Release 11.5 VAT changes, reverse the application accounting for
2271: --confirmed records in ar_distributions.
2272: --
2273: l_ae_doc_rec.document_type := 'RECEIPT';
2274: l_ae_doc_rec.document_id := p_cr_rec.cash_receipt_id;
2275: l_ae_doc_rec.accounting_entity_level := 'ONE';