APPS.ARP_ACCT_MAIN dependencies on AR_DISTRIBUTIONS

Line 13: PROCEDURE Dump_Dist_Amts(p_ae_line_rec ar_distributions%ROWTYPE);

9: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ae_line_tbl_type);
10:
11: PROCEDURE Init_Curr_Details(p_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE);
12:
13: PROCEDURE Dump_Dist_Amts(p_ae_line_rec ar_distributions%ROWTYPE);
14:
15: /*========================================================================
16: | Public Functions/Procedures
17: *=======================================================================*/

Line 66: FROM ar_distributions

62: where xte.source_id_int_1 = ra.cash_receipt_id
63: AND xte.upg_batch_id IS NOT NULL)
64: AND NOT EXISTS
65: ( SELECT *
66: FROM ar_distributions
67: WHERE source_table = 'RA'
68: AND source_id = ra.receivable_application_id
69: )
70: AND EXISTS (SELECT 1

Line 159: FROM ar_distributions

155: (SELECT sum(nvl(amount, 0)) amount
156: FROM AR_CASH_BASIS_DISTS_ALL
157: WHERE receivable_application_id = l_miss_rec_app.receivable_application_id) a,
158: (Select sum(nvl(AMOUNT_CR, 0) - nvl(AMOUNT_DR, 0)) amount
159: FROM ar_distributions
160: WHERE source_table = 'RA'
161: AND source_id = l_miss_rec_app.receivable_application_id) b
162: WHERE a.amount = b.amount;
163:

Line 209: from ar_distributions dist

205: select 'N'
206: into l_create_acct
207: from dual
208: where exists (select 'X'
209: from ar_distributions dist
210: where dist.source_id = p_ae_doc_rec.source_id
211: and dist.source_table = p_ae_doc_rec.source_table);
212:
213: IF PG_DEBUG in ('Y', 'C') THEN

Line 1185: | Inserts into AR_DISTRIBUTIONS accounting lines

1181: /*========================================================================
1182: | PRIVATE PROCEDURE Insert_Ae_Lines
1183: |
1184: | DESCRIPTION
1185: | Inserts into AR_DISTRIBUTIONS accounting lines
1186: | ----------------------------------------------
1187: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
1188: | for a given document into the underlying table.
1189: |

Line 1187: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting

1183: |
1184: | DESCRIPTION
1185: | Inserts into AR_DISTRIBUTIONS accounting lines
1186: | ----------------------------------------------
1187: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
1188: | for a given document into the underlying table.
1189: |
1190: | PARAMETERS
1191: | p_ae_line_tbl IN Accounting lines table

Line 1195: l_ae_line_rec ar_distributions%ROWTYPE;

1191: | p_ae_line_tbl IN Accounting lines table
1192: *=======================================================================*/
1193: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ae_line_tbl_type) IS
1194:
1195: l_ae_line_rec ar_distributions%ROWTYPE;
1196: l_ae_line_rec_empty ar_distributions%ROWTYPE;
1197: l_dummy ar_distributions.line_id%TYPE;
1198:
1199: i BINARY_INTEGER := 1;

Line 1196: l_ae_line_rec_empty ar_distributions%ROWTYPE;

1192: *=======================================================================*/
1193: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ae_line_tbl_type) IS
1194:
1195: l_ae_line_rec ar_distributions%ROWTYPE;
1196: l_ae_line_rec_empty ar_distributions%ROWTYPE;
1197: l_dummy ar_distributions.line_id%TYPE;
1198:
1199: i BINARY_INTEGER := 1;
1200:

Line 1197: l_dummy ar_distributions.line_id%TYPE;

1193: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ae_line_tbl_type) IS
1194:
1195: l_ae_line_rec ar_distributions%ROWTYPE;
1196: l_ae_line_rec_empty ar_distributions%ROWTYPE;
1197: l_dummy ar_distributions.line_id%TYPE;
1198:
1199: i BINARY_INTEGER := 1;
1200:
1201: BEGIN

Line 1293: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS

1289: |
1290: | PARAMETERS
1291: | p_ae_line_rec IN Accounting lines record
1292: *==========================================================================*/
1293: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS
1294: BEGIN
1295:
1296: IF PG_DEBUG in ('Y', 'C') THEN
1297: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()+');