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

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

160: p_adj_rec IN ar_adjustments%ROWTYPE );
161:
162: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
163:
164: PROCEDURE Dump_Dist_Amts(p_ae_line_rec ar_distributions%ROWTYPE);
165:
166: FUNCTION source_exec(p_process_ed_adj IN VARCHAR2,
167: p_process_uned IN VARCHAR2,
168: p_process_pay IN VARCHAR2,

Line 5328: l_actual_account ar_distributions.code_combination_id%TYPE ;

5324: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
5325:
5326: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5327: l_ctr BINARY_INTEGER ;
5328: l_actual_account ar_distributions.code_combination_id%TYPE ;
5329: l_source_type ar_distributions.source_type%TYPE ;
5330:
5331: --PL/SQL table object,this collection is used for bulk processing of inserts
5332: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;

Line 5329: l_source_type ar_distributions.source_type%TYPE ;

5325:
5326: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5327: l_ctr BINARY_INTEGER ;
5328: l_actual_account ar_distributions.code_combination_id%TYPE ;
5329: l_source_type ar_distributions.source_type%TYPE ;
5330:
5331: --PL/SQL table object,this collection is used for bulk processing of inserts
5332: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
5333: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;

Line 5833: l_actual_account ar_distributions.code_combination_id%TYPE ;

5829:
5830: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5831: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
5832: l_ctr BINARY_INTEGER ;
5833: l_actual_account ar_distributions.code_combination_id%TYPE ;
5834: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;
5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;
5836: l_taxable_amt NUMBER;
5837: l_taxable_acctd_amt NUMBER;

Line 5834: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;

5830: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5831: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
5832: l_ctr BINARY_INTEGER ;
5833: l_actual_account ar_distributions.code_combination_id%TYPE ;
5834: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;
5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;
5836: l_taxable_amt NUMBER;
5837: l_taxable_acctd_amt NUMBER;
5838:

Line 5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;

5831: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
5832: l_ctr BINARY_INTEGER ;
5833: l_actual_account ar_distributions.code_combination_id%TYPE ;
5834: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;
5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;
5836: l_taxable_amt NUMBER;
5837: l_taxable_acctd_amt NUMBER;
5838:
5839: l_source_type_secondary ar_distributions.source_type_secondary%TYPE;

Line 5839: l_source_type_secondary ar_distributions.source_type_secondary%TYPE;

5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;
5836: l_taxable_amt NUMBER;
5837: l_taxable_acctd_amt NUMBER;
5838:
5839: l_source_type_secondary ar_distributions.source_type_secondary%TYPE;
5840:
5841: --PL/SQL table object,this collection is used for bulk processing of inserts
5842: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
5843: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;

Line 6990: l_actual_account ar_distributions.code_combination_id%TYPE ;

6986: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,
6987: p_build_all IN BOOLEAN ) IS
6988:
6989: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
6990: l_actual_account ar_distributions.code_combination_id%TYPE ;
6991: l_line_tax_amt NUMBER := 0;
6992: l_line_tax_acctd_amt NUMBER := 0;
6993:
6994: BEGIN

Line 7695: INSERT INTO ar_distributions (

7691: --Bulk processing of distribution records [Bug 6454022]
7692: IF NVL(g_simul_app,'N') = 'N' THEN
7693: IF (NVL(g_ae_sys_rec.sob_type,'P') = 'P') THEN
7694:
7695: INSERT INTO ar_distributions (
7696: line_id,
7697: source_id,
7698: source_table,
7699: source_type,

Line 7741: SELECT ar_distributions_s.nextval,

7737: activity_bucket,
7738: ref_dist_ccid,
7739: ref_mf_dist_flag
7740: )
7741: SELECT ar_distributions_s.nextval,
7742: al.ae_source_id,
7743: al.ae_source_table,
7744: al.ae_line_type,
7745: al.ae_line_type_secondary,

Line 8324: | Inserts into AR_DISTRIBUTIONS accounting lines

8320: /*========================================================================
8321: | PRIVATE PROCEDURE Insert_Ae_Lines
8322: |
8323: | DESCRIPTION
8324: | Inserts into AR_DISTRIBUTIONS accounting lines
8325: | ----------------------------------------------
8326: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
8327: | for a given document into the underlying table.
8328: |

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

8322: |
8323: | DESCRIPTION
8324: | Inserts into AR_DISTRIBUTIONS accounting lines
8325: | ----------------------------------------------
8326: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
8327: | for a given document into the underlying table.
8328: |
8329: | PARAMETERS
8330: | p_ae_line_tbl IN Accounting lines table

Line 8336: l_ae_line_rec ar_distributions%ROWTYPE;

8332: | 24-NOV-2003 Herve Yu Distributions in the receipt currency
8333: *=======================================================================*/
8334: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8335:
8336: l_ae_line_rec ar_distributions%ROWTYPE;
8337: l_ae_line_rec_empty ar_distributions%ROWTYPE;
8338: l_dummy ar_distributions.line_id%TYPE;
8339:
8340: BEGIN

Line 8337: l_ae_line_rec_empty ar_distributions%ROWTYPE;

8333: *=======================================================================*/
8334: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8335:
8336: l_ae_line_rec ar_distributions%ROWTYPE;
8337: l_ae_line_rec_empty ar_distributions%ROWTYPE;
8338: l_dummy ar_distributions.line_id%TYPE;
8339:
8340: BEGIN
8341:

Line 8338: l_dummy ar_distributions.line_id%TYPE;

8334: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8335:
8336: l_ae_line_rec ar_distributions%ROWTYPE;
8337: l_ae_line_rec_empty ar_distributions%ROWTYPE;
8338: l_dummy ar_distributions.line_id%TYPE;
8339:
8340: BEGIN
8341:
8342: arp_standard.debug( 'ARP_ALLOCATION_PKG.Insert_Ae_Lines()+');

Line 8389: --Insert into ar_distributions

8385: l_ae_line_rec.ref_line_id := p_ae_line_tbl.ae_ref_line_id;
8386:
8387: Dump_Dist_Amts(l_ae_line_rec);
8388:
8389: --Insert into ar_distributions
8390: IF (NVL(g_ae_sys_rec.sob_type,'P') = 'P') THEN
8391:
8392: arp_distributions_pkg.insert_p(l_ae_line_rec, l_dummy);
8393: --{BUG#4301323

Line 8405: -- select ar_distributions_s.nextval

8401: -- arp_standard.debug('source type = ' || l_ae_line_rec.source_type);
8402: -- if (l_ae_line_rec.source_type = 'EXCH_GAIN' or
8403: -- l_ae_line_rec.source_type = 'EXCH_LOSS' or
8404: -- l_ae_line_rec.source_type = 'CURR_ROUND' ) THEN
8405: -- select ar_distributions_s.nextval
8406: -- into l_ae_line_rec.line_id
8407: -- from dual;
8408: -- ELSE
8409: -- BEGIN

Line 8412: -- from ar_distributions

8408: -- ELSE
8409: -- BEGIN
8410: -- select line_id
8411: -- into l_ae_line_rec.line_id
8412: -- from ar_distributions
8413: -- where source_id = l_ae_line_rec.source_id
8414: -- and source_table = l_ae_line_rec.source_table
8415: -- and source_type = l_ae_line_rec.source_type
8416: -- and (source_type_secondary =

Line 8427: -- select ar_distributions_s.nextval

8423: -- and code_combination_id = l_ae_line_rec.code_combination_id;
8424: -- EXCEPTION
8425: -- WHEN OTHERS THEN
8426: -- arp_standard.debug('Can not determine Line id so created new one');
8427: -- select ar_distributions_s.nextval
8428: -- into l_ae_line_rec.line_id
8429: -- from dual;
8430: -- END;
8431: -- arp_standard.debug('line id = ' || to_char(l_ae_line_rec.line_id));

Line 8448: | Inserts into AR_DISTRIBUTIONS accounting lines

8444: /*========================================================================
8445: | PRIVATE PROCEDURE Cache_Ae_Lines
8446: |
8447: | DESCRIPTION
8448: | Inserts into AR_DISTRIBUTIONS accounting lines
8449: | ----------------------------------------------
8450: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
8451: | for a given document into the underlying table.
8452: |

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

8446: |
8447: | DESCRIPTION
8448: | Inserts into AR_DISTRIBUTIONS accounting lines
8449: | ----------------------------------------------
8450: | Calls the table handler for AR_DISTRIBUTIONS to insert accounting
8451: | for a given document into the underlying table.
8452: |
8453: | PARAMETERS
8454: | p_ae_line_tbl IN Accounting lines table

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

8826: |
8827: | PARAMETERS
8828: | p_ae_line_rec IN Accounting lines record
8829: *==========================================================================*/
8830: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS
8831: BEGIN
8832:
8833: IF PG_DEBUG in ('Y', 'C') THEN
8834: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Dist_Amts()+');