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_AE_ALLOC_REC_GT

Line 126: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );

122:
123: PROCEDURE Build_Rev(p_gl_account_source IN ar_receivables_trx.gl_account_source%TYPE ,
124: p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
125: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
126: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );
127:
128: PROCEDURE Build_Tax(p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
129: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
130: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );

Line 130: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );

126: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );
127:
128: PROCEDURE Build_Tax(p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
129: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
130: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );
131:
132: PROCEDURE Build_Charges_Freight_All(p_type_acct IN VARCHAR2 ,
133: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,
134: p_build_all IN BOOLEAN );

Line 133: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,

129: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
130: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE );
131:
132: PROCEDURE Build_Charges_Freight_All(p_type_acct IN VARCHAR2 ,
133: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,
134: p_build_all IN BOOLEAN );
135:
136: PROCEDURE Create_Debits_Credits(p_amount IN NUMBER ,
137: p_acctd_amount IN NUMBER ,

Line 142: p_ae_line_rec IN OUT NOCOPY ar_ae_alloc_rec_gt%ROWTYPE,

138: p_taxable_amount IN NUMBER ,
139: p_taxable_acctd_amount IN NUMBER ,
140: p_from_amount IN NUMBER ,
141: p_from_acctd_amount IN NUMBER ,
142: p_ae_line_rec IN OUT NOCOPY ar_ae_alloc_rec_gt%ROWTYPE,
143: p_paired_flag IN VARCHAR2 DEFAULT NULL,
144: p_calling_point IN VARCHAR2 DEFAULT NULL);
145:
146:

Line 151: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);

147: PROCEDURE Summarize_Accounting_Lines;
148:
149: PROCEDURE Summarize_Acct_Lines_Hdr_Level;
150:
151: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
152:
153: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
154:
155: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);

Line 153: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);

149: PROCEDURE Summarize_Acct_Lines_Hdr_Level;
150:
151: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
152:
153: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
154:
155: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
156:
157: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2,

Line 155: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);

151: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
152:
153: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
154:
155: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
156:
157: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2,
158: p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
159:

Line 158: p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE);

154:
155: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE);
156:
157: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2,
158: p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE);
159:
160: PROCEDURE Dump_Init_Amts(p_type_acct IN VARCHAR2 ,
161: p_app_rec IN ar_receivable_applications%ROWTYPE ,
162: p_adj_rec IN ar_adjustments%ROWTYPE );

Line 164: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE);

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

Line 798: -- we should initializing the amount in ar_ae_alloc_rec_gt Init_Rev_Tax_Tab;

794: --}
795: /*------------------------------------------------------------------------------+
796: | Initialise Revenue table to reuse cells for allocating line amounts |
797: +------------------------------------------------------------------------------*/
798: -- we should initializing the amount in ar_ae_alloc_rec_gt Init_Rev_Tax_Tab;
799:
800: /*----------------------------------------------------------------------------+
801: | Process for Unearned discounts |
802: +----------------------------------------------------------------------------*/

Line 826: -- we should initializing the amount in ar_ae_alloc_rec_gt Init_Rev_Tax_Tab;

822: --}
823: /*------------------------------------------------------------------------------+
824: | Initialise Revenue table to reuse cells for allocating line amounts |
825: +------------------------------------------------------------------------------*/
826: -- we should initializing the amount in ar_ae_alloc_rec_gt Init_Rev_Tax_Tab;
827: -- g_exec := NULL;
828: -- g_exec := source_exec(p_type_acct => 'PAY',
829: -- p_source_table => g_ae_doc_rec.source_table);
830: --}

Line 963: DELETE FROM ar_ae_alloc_rec_gt;

959: l_cnt := SQL%ROWCOUNT;
960: arp_standard.debug('No of rows deleted from ar_line_app_detail_gt : '||l_cnt);
961: END IF;
962:
963: DELETE FROM ar_ae_alloc_rec_gt;
964: IF PG_DEBUG in ('Y', 'C') THEN
965: l_cnt := SQL%ROWCOUNT;
966: arp_standard.debug('No of rows deleted from ar_ae_alloc_rec_gt : '||l_cnt);
967: END IF;

Line 966: arp_standard.debug('No of rows deleted from ar_ae_alloc_rec_gt : '||l_cnt);

962:
963: DELETE FROM ar_ae_alloc_rec_gt;
964: IF PG_DEBUG in ('Y', 'C') THEN
965: l_cnt := SQL%ROWCOUNT;
966: arp_standard.debug('No of rows deleted from ar_ae_alloc_rec_gt : '||l_cnt);
967: END IF;
968: END IF;
969:
970: <>

Line 1190: SELECT /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) /

1186: p_process_uned IN VARCHAR2,
1187: p_process_pay IN VARCHAR2 ) IS
1188:
1189: CURSOR get_group_data_tax IS
1190: SELECT /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
1191: decode(ae_collected_tax_ccid,
1192: '',ae_account_class,
1193: 'DEFTAX') ae_account_class ,
1194: SUM(ae_amount) sum_ae_amount ,

Line 1200: FROM ar_ae_alloc_rec_gt

1196: max(ae_code_combination_id) ae_code_combination_id,
1197: max(decode(ae_override_ccid1,'',2,1)) ae_override_ccid1 ,
1198: max(decode(ae_override_ccid2,'',2,1)) ae_override_ccid2 ,
1199: count(ae_account_class) ae_count
1200: FROM ar_ae_alloc_rec_gt
1201: WHERE ae_id = g_id
1202: GROUP BY decode(ae_collected_tax_ccid,
1203: '',ae_account_class,
1204: 'DEFTAX');

Line 1207: SELECT /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) /

1203: '',ae_account_class,
1204: 'DEFTAX');
1205:
1206: CURSOR get_group_data_rev IS
1207: SELECT /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
1208: ae_account_class ae_account_class ,
1209: SUM(ae_amount) sum_ae_amount ,
1210: SUM(ae_acctd_amount) sum_ae_acctd_amount ,
1211: max(ae_code_combination_id) ae_code_combination_id,

Line 1215: FROM ar_ae_alloc_rec_gt

1211: max(ae_code_combination_id) ae_code_combination_id,
1212: '' ae_override_ccid1 ,
1213: '' ae_override_ccid2 ,
1214: count(ae_account_class) ae_count
1215: FROM ar_ae_alloc_rec_gt
1216: WHERE ae_id = g_id
1217: AND ae_account_class <> 'TAX'
1218: GROUP BY ae_account_class;
1219:

Line 1221: SELECT /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N1) / *

1217: AND ae_account_class <> 'TAX'
1218: GROUP BY ae_account_class;
1219:
1220: CURSOR l_rev_unearn(p_type IN VARCHAR2, p_trx_line_id IN NUMBER) IS
1221: SELECT /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N1) */ *
1222: FROM ar_ae_alloc_rec_gt
1223: WHERE ae_id = g_id
1224: AND ae_account_class = p_type
1225: AND ae_customer_trx_line_id = p_trx_line_id

Line 1222: FROM ar_ae_alloc_rec_gt

1218: GROUP BY ae_account_class;
1219:
1220: CURSOR l_rev_unearn(p_type IN VARCHAR2, p_trx_line_id IN NUMBER) IS
1221: SELECT /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N1) */ *
1222: FROM ar_ae_alloc_rec_gt
1223: WHERE ae_id = g_id
1224: AND ae_account_class = p_type
1225: AND ae_customer_trx_line_id = p_trx_line_id
1226: AND ae_customer_trx_id = p_invoice_id;

Line 1230: l_inv_assign ar_ae_alloc_rec_gt%ROWTYPE;

1226: AND ae_customer_trx_id = p_invoice_id;
1227:
1228:
1229: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
1230: l_inv_assign ar_ae_alloc_rec_gt%ROWTYPE;
1231:
1232: l_rev_ctr BINARY_INTEGER ;
1233: l_ctr BINARY_INTEGER ;
1234: l_ctr1 BINARY_INTEGER ;

Line 1250: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;

1246: l_msg_count NUMBER ;
1247: l_msg_data VARCHAR2(2000);
1248: l_mesg VARCHAR2(2000) := '';
1249:
1250: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
1251: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;
1252: l_override1 VARCHAR2(1) := 'N';
1253: l_override2 VARCHAR2(1) := 'N';
1254: l_gl_account_source ar_receivables_trx.gl_account_source%TYPE ;

Line 1251: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;

1247: l_msg_data VARCHAR2(2000);
1248: l_mesg VARCHAR2(2000) := '';
1249:
1250: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
1251: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;
1252: l_override1 VARCHAR2(1) := 'N';
1253: l_override2 VARCHAR2(1) := 'N';
1254: l_gl_account_source ar_receivables_trx.gl_account_source%TYPE ;
1255: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE ;

Line 1266: ar_ae_alloc_rec_gt ctl

1262: max(decode(b.account_class,'REV',b.code_combination_id,0))
1263: ),
1264: ctl.ae_cust_trx_line_gl_dist_id
1265: FROM ra_cust_trx_line_gl_dist b,
1266: ar_ae_alloc_rec_gt ctl
1267: WHERE ctl.ae_tax_link_id = b.customer_trx_line_id
1268: AND ctl.ae_account_class = 'TAX'
1269: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;
1270:

Line 1302: insert into ar_ae_alloc_rec_gt (

1298: /*----------------------------------------------------------------------------+
1299: | Insert Tax distributions |
1300: | MRC Trigger Replacement. Modified to insert currency sensitive columns |
1301: +----------------------------------------------------------------------------*/
1302: insert into ar_ae_alloc_rec_gt (
1303: ae_id ,
1304: ae_account_class ,
1305: ae_customer_trx_id ,
1306: ae_customer_trx_line_id ,

Line 1520: UPDATE ar_ae_alloc_rec_gt

1516: l_ctlgd_tab;
1517: CLOSE crevccid;
1518: IF l_ctlgd_tab.COUNT > 0 THEN
1519: FORALL k IN l_ccid_tab.FIRST .. l_ccid_tab.LAST
1520: UPDATE ar_ae_alloc_rec_gt
1521: SET ae_code_combination_id = l_ccid_tab(k)
1522: WHERE ae_cust_trx_line_gl_dist_id = l_ctlgd_tab(k);
1523: END IF;
1524: END IF;

Line 1528: insert into ar_ae_alloc_rec_gt (

1524: END IF;
1525:
1526:
1527:
1528: insert into ar_ae_alloc_rec_gt (
1529: ae_id ,
1530: ae_account_class ,
1531: ae_customer_trx_id ,
1532: ae_customer_trx_line_id ,

Line 1846: insert into ar_ae_alloc_rec_gt (

1842: -- since UNBILL and UNEARN
1843: --always have a customer_trx_line_id
1844:
1845: -- MRC Trigger Replacement: get currency sensitive data
1846: insert into ar_ae_alloc_rec_gt (
1847: ae_id ,
1848: ae_account_class ,
1849: ae_customer_trx_id ,
1850: ae_customer_trx_line_id ,

Line 2030: from ar_ae_alloc_rec_gt b4

2026: 'TAX_CODE_ON_INVOICE', decode(g_ae_doc_rec.source_table,
2027: 'RA', b4.ae_unedisc_ccid,
2028: ''),
2029: '')) override_ccid2
2030: from ar_ae_alloc_rec_gt b4
2031: where b4.rowid IN
2032: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2033: min(b3.rowid)
2034: from ar_ae_alloc_rec_gt b3

Line 2032: (select /+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) /

2028: ''),
2029: '')) override_ccid2
2030: from ar_ae_alloc_rec_gt b4
2031: where b4.rowid IN
2032: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2033: min(b3.rowid)
2034: from ar_ae_alloc_rec_gt b3
2035: where b3.ae_id = g_id
2036: and b3.ae_account_class = 'TAX'

Line 2034: from ar_ae_alloc_rec_gt b3

2030: from ar_ae_alloc_rec_gt b4
2031: where b4.rowid IN
2032: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2033: min(b3.rowid)
2034: from ar_ae_alloc_rec_gt b3
2035: where b3.ae_id = g_id
2036: and b3.ae_account_class = 'TAX'
2037: and (((decode(g_ae_doc_rec.source_table,
2038: 'RA', decode(b3.ae_edisc_ccid,

Line 2098: (select /+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) /

2094: and ctl.customer_trx_id = p_invoice_id
2095: and ctl.rowid in
2096: (select min(ctl1.rowid)
2097: from ra_customer_trx_lines ctl1,
2098: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2099: count(*) tax_count
2100: from ar_ae_alloc_rec_gt b3
2101: where b3.ae_id = g_id
2102: and b3.ae_account_class = 'TAX') tx

Line 2100: from ar_ae_alloc_rec_gt b3

2096: (select min(ctl1.rowid)
2097: from ra_customer_trx_lines ctl1,
2098: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2099: count(*) tax_count
2100: from ar_ae_alloc_rec_gt b3
2101: where b3.ae_id = g_id
2102: and b3.ae_account_class = 'TAX') tx
2103: where ctl1.customer_trx_id = p_invoice_id
2104: and ctl1.line_type = 'TAX'

Line 2153: insert into ar_ae_alloc_rec_gt (

2149: ctl.customer_trx_id ,
2150: ctl.customer_trx_line_id ; */
2151:
2152:
2153: insert into ar_ae_alloc_rec_gt (
2154: ae_id ,
2155: ae_account_class ,
2156: ae_customer_trx_id ,
2157: ae_customer_trx_line_id ,

Line 2313: from ar_ae_alloc_rec_gt b4

2309: 'TAX_CODE_ON_INVOICE', decode(g_ae_doc_rec.source_table,
2310: 'RA', b4.ae_unedisc_ccid,
2311: ''),
2312: '')) override_ccid2
2313: from ar_ae_alloc_rec_gt b4
2314: where b4.rowid IN
2315: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2316: min(b3.rowid)
2317: from ar_ae_alloc_rec_gt b3

Line 2315: (select /+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) /

2311: ''),
2312: '')) override_ccid2
2313: from ar_ae_alloc_rec_gt b4
2314: where b4.rowid IN
2315: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2316: min(b3.rowid)
2317: from ar_ae_alloc_rec_gt b3
2318: where b3.ae_id = g_id
2319: and b3.ae_account_class = 'TAX'

Line 2317: from ar_ae_alloc_rec_gt b3

2313: from ar_ae_alloc_rec_gt b4
2314: where b4.rowid IN
2315: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2316: min(b3.rowid)
2317: from ar_ae_alloc_rec_gt b3
2318: where b3.ae_id = g_id
2319: and b3.ae_account_class = 'TAX'
2320: and (((decode(g_ae_doc_rec.source_table,
2321: 'RA', decode(b3.ae_edisc_ccid,

Line 2381: (select /+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) /

2377: and ctl.customer_trx_id = p_invoice_id
2378: and ctl.rowid in
2379: (select min(ctl1.rowid)
2380: from ra_customer_trx_lines ctl1,
2381: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2382: count(*) tax_count
2383: from ar_ae_alloc_rec_gt b3
2384: where b3.ae_id = g_id
2385: and b3.ae_account_class = 'TAX') tx

Line 2383: from ar_ae_alloc_rec_gt b3

2379: (select min(ctl1.rowid)
2380: from ra_customer_trx_lines ctl1,
2381: (select /*+ INDEX(b3 AR_AE_ALLOC_REC_GT_N3) */
2382: count(*) tax_count
2383: from ar_ae_alloc_rec_gt b3
2384: where b3.ae_id = g_id
2385: and b3.ae_account_class = 'TAX') tx
2386: where ctl1.customer_trx_id = p_invoice_id
2387: and ctl1.line_type = 'TAX'

Line 2570: --and the ar_ae_alloc_rec_gt table

2566: IF g_ae_unearn_rev_ctr > 0
2567: AND l_ra_dist_tbl(l_ctr2).account_class = 'REV' THEN
2568:
2569: --later on convert this into a join between the dist temp table
2570: --and the ar_ae_alloc_rec_gt table
2571: FOR g_ae_alloc_unearn_rev_tbl IN
2572: l_rev_unearn('REVUNEARN', l_ra_dist_tbl(l_ctr2).customer_trx_line_id) LOOP
2573: l_ae_tax_id := g_ae_alloc_unearn_rev_tbl.ae_tax_id;
2574: EXIT;

Line 2646: -- UPDATE /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3 / ar_ae_alloc_rec_gt

2642: ELSE
2643:
2644: IF g_ae_unearn_rev_ctr > 0 THEN
2645: */
2646: -- UPDATE /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3 */ ar_ae_alloc_rec_gt
2647: /*
2648: SET ae_account_class = 'REVEARN'
2649: WHERE ae_id = g_id
2650: AND ae_account_class = 'REVUNEARN';

Line 2671: UPDATE /+ INDEX(b1 AR_AE_ALLOC_REC_GT_N3) /

2667: /*----------------------------------------------------------------------------------+
2668: | Set the tax link id's for the revenue lines - we do this here since ram api is |
2669: | called after the insert of original revenue, hence all link ids set at one time. |
2670: +----------------------------------------------------------------------------------*/
2671: UPDATE /*+ INDEX(b1 AR_AE_ALLOC_REC_GT_N3) */
2672: ar_ae_alloc_rec_gt b1
2673: SET (b1.ae_tax_link_id, b1.ae_tax_link_id_ed_adj, b1.ae_tax_link_id_uned) =
2674: (select /*+ INDEX(b8 AR_AE_ALLOC_REC_GT_N3) */
2675: max(b8.ae_tax_link_id) ae_tax_link_id,

Line 2672: ar_ae_alloc_rec_gt b1

2668: | Set the tax link id's for the revenue lines - we do this here since ram api is |
2669: | called after the insert of original revenue, hence all link ids set at one time. |
2670: +----------------------------------------------------------------------------------*/
2671: UPDATE /*+ INDEX(b1 AR_AE_ALLOC_REC_GT_N3) */
2672: ar_ae_alloc_rec_gt b1
2673: SET (b1.ae_tax_link_id, b1.ae_tax_link_id_ed_adj, b1.ae_tax_link_id_uned) =
2674: (select /*+ INDEX(b8 AR_AE_ALLOC_REC_GT_N3) */
2675: max(b8.ae_tax_link_id) ae_tax_link_id,
2676: max(b8.ae_tax_link_id_ed_adj) ae_tax_link_id_ed_adj,

Line 2674: (select /+ INDEX(b8 AR_AE_ALLOC_REC_GT_N3) /

2670: +----------------------------------------------------------------------------------*/
2671: UPDATE /*+ INDEX(b1 AR_AE_ALLOC_REC_GT_N3) */
2672: ar_ae_alloc_rec_gt b1
2673: SET (b1.ae_tax_link_id, b1.ae_tax_link_id_ed_adj, b1.ae_tax_link_id_uned) =
2674: (select /*+ INDEX(b8 AR_AE_ALLOC_REC_GT_N3) */
2675: max(b8.ae_tax_link_id) ae_tax_link_id,
2676: max(b8.ae_tax_link_id_ed_adj) ae_tax_link_id_ed_adj,
2677: max(b8.ae_tax_link_id_uned) ae_tax_link_id_uned
2678: from ar_ae_alloc_rec_gt b8

Line 2678: from ar_ae_alloc_rec_gt b8

2674: (select /*+ INDEX(b8 AR_AE_ALLOC_REC_GT_N3) */
2675: max(b8.ae_tax_link_id) ae_tax_link_id,
2676: max(b8.ae_tax_link_id_ed_adj) ae_tax_link_id_ed_adj,
2677: max(b8.ae_tax_link_id_uned) ae_tax_link_id_uned
2678: from ar_ae_alloc_rec_gt b8
2679: where b8.ae_id = g_id
2680: and b8.ae_account_class = 'TAX'
2681: and b8.ae_link_to_cust_trx_line_id = b1.ae_customer_trx_line_id)
2682: WHERE b1.ae_id = g_id

Line 2684: AND EXISTS (select /+ INDEX(b2 AR_AE_ALLOC_REC_GT_N3) /

2680: and b8.ae_account_class = 'TAX'
2681: and b8.ae_link_to_cust_trx_line_id = b1.ae_customer_trx_line_id)
2682: WHERE b1.ae_id = g_id
2683: AND b1.ae_account_class IN ('REVEARN','REVUNEARN') --MAINTAINTAXLINKID
2684: AND EXISTS (select /*+ INDEX(b2 AR_AE_ALLOC_REC_GT_N3) */
2685: 'x'
2686: from ar_ae_alloc_rec_gt b2
2687: where b2.ae_id = g_id
2688: and b2.ae_account_class = 'TAX'

Line 2686: from ar_ae_alloc_rec_gt b2

2682: WHERE b1.ae_id = g_id
2683: AND b1.ae_account_class IN ('REVEARN','REVUNEARN') --MAINTAINTAXLINKID
2684: AND EXISTS (select /*+ INDEX(b2 AR_AE_ALLOC_REC_GT_N3) */
2685: 'x'
2686: from ar_ae_alloc_rec_gt b2
2687: where b2.ae_id = g_id
2688: and b2.ae_account_class = 'TAX'
2689: and b2.ae_link_to_cust_trx_line_id = b1.ae_customer_trx_line_id);
2690:

Line 2707: UPDATE /+ INDEX(at1 AR_AE_ALLOC_REC_GT_N3) /

2703: OR ((g_ae_doc_rec.source_table = 'ADJ') AND (g_ae_rule_rec.tax_code_source1 = 'NONE')
2704: AND (nvl(p_adj_rec.tax_adjusted,0) <> 0))) AND (g_ae_rev_ctr > 0)
2705: THEN
2706:
2707: UPDATE /*+ INDEX(at1 AR_AE_ALLOC_REC_GT_N3) */
2708: ar_ae_alloc_rec_gt at1
2709: SET (at1.ae_inv_line ,
2710: at1.ae_sum_rev_amt ,
2711: at1.ae_sum_rev_acctd_amt,

Line 2708: ar_ae_alloc_rec_gt at1

2704: AND (nvl(p_adj_rec.tax_adjusted,0) <> 0))) AND (g_ae_rev_ctr > 0)
2705: THEN
2706:
2707: UPDATE /*+ INDEX(at1 AR_AE_ALLOC_REC_GT_N3) */
2708: ar_ae_alloc_rec_gt at1
2709: SET (at1.ae_inv_line ,
2710: at1.ae_sum_rev_amt ,
2711: at1.ae_sum_rev_acctd_amt,
2712: at1.ae_count) =

Line 2713: (SELECT /+ INDEX(at2 AR_AE_ALLOC_REC_GT_N1) /

2709: SET (at1.ae_inv_line ,
2710: at1.ae_sum_rev_amt ,
2711: at1.ae_sum_rev_acctd_amt,
2712: at1.ae_count) =
2713: (SELECT /*+ INDEX(at2 AR_AE_ALLOC_REC_GT_N1) */
2714: at2.ae_customer_trx_line_id,
2715: sum(at2.ae_amount),
2716: sum(at2.ae_acctd_amount),
2717: count(at2.ae_customer_trx_line_id)

Line 2718: FROM ar_ae_alloc_rec_gt at2

2714: at2.ae_customer_trx_line_id,
2715: sum(at2.ae_amount),
2716: sum(at2.ae_acctd_amount),
2717: count(at2.ae_customer_trx_line_id)
2718: FROM ar_ae_alloc_rec_gt at2
2719: WHERE at2.ae_id = g_id
2720: AND at2.ae_customer_trx_line_id = at1.ae_customer_trx_line_id
2721: AND at2.ae_account_class IN ('REVEARN','REVUNEARN') --MAINTAINTAXLINKID
2722: GROUP BY at2.ae_customer_trx_line_id)

Line 2838: select /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) /

2834: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE ;
2835: l_tax_recoverable_flag ar_receivables_trx.tax_recoverable_flag%TYPE ;
2836:
2837: cursor get_tax IS
2838: select /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
2839: ae_link_to_cust_trx_line_id
2840: from ar_ae_alloc_rec_gt
2841: where ae_id = g_id
2842: and ae_account_class = 'TAX'

Line 2840: from ar_ae_alloc_rec_gt

2836:
2837: cursor get_tax IS
2838: select /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
2839: ae_link_to_cust_trx_line_id
2840: from ar_ae_alloc_rec_gt
2841: where ae_id = g_id
2842: and ae_account_class = 'TAX'
2843: group by ae_link_to_cust_trx_line_id
2844: order by ae_link_to_cust_trx_line_id;

Line 2958: update /+ INDEX(art3 AR_AE_ALLOC_REC_GT_N4) /

2954: arp_standard.debug('Get_Tax_Link_Id: ' || 'Link Id l_link_ctr1 ' || l_link_ctr1);
2955: arp_standard.debug('Get_Tax_Link_Id: ' || 'inv_line_tbl(' || i || ') = '|| inv_line_tbl(i));
2956: END IF;
2957:
2958: update /*+ INDEX(art3 AR_AE_ALLOC_REC_GT_N4) */
2959: ar_ae_alloc_rec_gt art3
2960: set art3.ae_tax_link_id = decode(l_set_pay_link,
2961: 'Y', l_link_ctr,
2962: ''),

Line 2959: ar_ae_alloc_rec_gt art3

2955: arp_standard.debug('Get_Tax_Link_Id: ' || 'inv_line_tbl(' || i || ') = '|| inv_line_tbl(i));
2956: END IF;
2957:
2958: update /*+ INDEX(art3 AR_AE_ALLOC_REC_GT_N4) */
2959: ar_ae_alloc_rec_gt art3
2960: set art3.ae_tax_link_id = decode(l_set_pay_link,
2961: 'Y', l_link_ctr,
2962: ''),
2963: art3.ae_tax_link_id_ed_adj = decode(l_set_ed_adj_link,

Line 2978: select /+ INDEX(art1 AR_AE_ALLOC_REC_GT_N4) INDEX(art2 AR_AE_ALLOC_REC_GT_N2) /

2974: and art3.ae_counted_flag = 'N'
2975: and art3.ae_link_to_cust_trx_line_id IN
2976: (select to_line
2977: from(
2978: select /*+ INDEX(art1 AR_AE_ALLOC_REC_GT_N4) INDEX(art2 AR_AE_ALLOC_REC_GT_N2) */
2979: art1.ae_link_to_cust_trx_line_id from_line ,
2980: art2.ae_link_to_cust_trx_line_id to_line ,
2981: max(art1.ae_tax_line_count) tax_line_count ,
2982: 1 hit_count

Line 2983: from ar_ae_alloc_rec_gt art1,

2979: art1.ae_link_to_cust_trx_line_id from_line ,
2980: art2.ae_link_to_cust_trx_line_id to_line ,
2981: max(art1.ae_tax_line_count) tax_line_count ,
2982: 1 hit_count
2983: from ar_ae_alloc_rec_gt art1,
2984: ar_ae_alloc_rec_gt art2
2985: where art1.ae_id = g_id
2986: and art1.ae_account_class = 'TAX'
2987: and art1.ae_account_class = art2.ae_account_class

Line 2984: ar_ae_alloc_rec_gt art2

2980: art2.ae_link_to_cust_trx_line_id to_line ,
2981: max(art1.ae_tax_line_count) tax_line_count ,
2982: 1 hit_count
2983: from ar_ae_alloc_rec_gt art1,
2984: ar_ae_alloc_rec_gt art2
2985: where art1.ae_id = g_id
2986: and art1.ae_account_class = 'TAX'
2987: and art1.ae_account_class = art2.ae_account_class
2988: and art1.ae_tax_id = art2.ae_tax_id

Line 3915: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE;

3911: | NONE
3912: *==========================================================================*/
3913: PROCEDURE Gross_To_Activity_GL(p_type_acct IN VARCHAR2) IS
3914:
3915: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE;
3916:
3917: BEGIN
3918:
3919: IF PG_DEBUG in ('Y', 'C') THEN

Line 3986: UPDATE /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3)/

3982: | Set the prorate amount and summarized flags to null because they may have |
3983: | been set for earned discounts. |
3984: +------------------------------------------------------------------------------*/
3985:
3986: UPDATE /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3)*/
3987: ar_ae_alloc_rec_gt
3988: SET ae_pro_amt = 0 ,
3989: ae_pro_acctd_amt = 0 ,
3990: ae_pro_frt_chrg_amt = 0 ,

Line 3987: ar_ae_alloc_rec_gt

3983: | been set for earned discounts. |
3984: +------------------------------------------------------------------------------*/
3985:
3986: UPDATE /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3)*/
3987: ar_ae_alloc_rec_gt
3988: SET ae_pro_amt = 0 ,
3989: ae_pro_acctd_amt = 0 ,
3990: ae_pro_frt_chrg_amt = 0 ,
3991: ae_pro_frt_chrg_acctd_amt = 0 ,

Line 4119: SELECT /+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) /

4115:
4116: g_ae_alloc_rev_tax_tbl g_ae_alloc_type;
4117:
4118: CURSOR l_rev_tax_cur IS
4119: SELECT /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
4120: rowid,
4121: ae_account_class,
4122: ae_amount,
4123: ae_acctd_amount,

Line 4135: FROM ar_ae_alloc_rec_gt

4131: ae_pro_frt_chrg_acctd_amt,
4132: ae_collected_tax_ccid,
4133: ae_pro_def_tax_amt,
4134: ae_pro_def_tax_acctd_amt
4135: FROM ar_ae_alloc_rec_gt
4136: WHERE ae_id = g_id
4137: AND ae_account_class IS NOT NULL
4138: ORDER BY ae_account_class, ae_customer_trx_line_id;
4139:

Line 4564: UPDATE ar_ae_alloc_rec_gt

4560: /*------------------------------------------------------------------------------+
4561: | Update the amounts for revenue or tax based on rowid |
4562: +------------------------------------------------------------------------------*/
4563: FORALL m IN g_ae_alloc_rev_tax_tbl.l_rowid.FIRST .. g_ae_alloc_rev_tax_tbl.l_rowid.LAST
4564: UPDATE ar_ae_alloc_rec_gt
4565: SET ae_pro_amt = g_ae_alloc_rev_tax_tbl.ae_pro_amt(m),
4566: ae_pro_acctd_amt = g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(m),
4567: ae_pro_taxable_amt = g_ae_alloc_rev_tax_tbl.ae_pro_taxable_amt(m),
4568: ae_pro_taxable_acctd_amt = g_ae_alloc_rev_tax_tbl.ae_pro_taxable_acctd_amt(m),

Line 4705: select /+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) /

4701: l_ctr BINARY_INTEGER;
4702: l_ctr1 BINARY_INTEGER;
4703:
4704: CURSOR set_taxable_and_link IS
4705: select /*+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) */
4706: a2.rowid,
4707: a3.link_id,
4708: a3.line_id,
4709: a3.amt,

Line 4711: from ar_ae_alloc_rec_gt a2,

4707: a3.link_id,
4708: a3.line_id,
4709: a3.amt,
4710: a3.acctd_amt
4711: from ar_ae_alloc_rec_gt a2,
4712: (select /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
4713: a1.ae_id ae_id,
4714: decode(p_type_acct,
4715: 'ED_ADJ', a1.ae_tax_link_id_ed_adj,

Line 4712: (select /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

4708: a3.line_id,
4709: a3.amt,
4710: a3.acctd_amt
4711: from ar_ae_alloc_rec_gt a2,
4712: (select /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
4713: a1.ae_id ae_id,
4714: decode(p_type_acct,
4715: 'ED_ADJ', a1.ae_tax_link_id_ed_adj,
4716: 'UNED' , a1.ae_tax_link_id_uned,

Line 4721: from ar_ae_alloc_rec_gt a1

4717: 'PAY' , a1.ae_tax_link_id) link_id,
4718: a1.ae_customer_trx_line_id line_id,
4719: sum(a1.ae_pro_amt) amt,
4720: sum(a1.ae_pro_acctd_amt) acctd_amt
4721: from ar_ae_alloc_rec_gt a1
4722: where a1.ae_id = g_id
4723: and a1.ae_account_class IN ('REVEARN','REVUNEARN') --MAINTAINLINKTAXID
4724: group by
4725: a1.ae_id,

Line 4808: UPDATE ar_ae_alloc_rec_gt

4804: END LOOP;
4805:
4806: --Bulk update
4807: FORALL m IN rowid_tbl.FIRST .. rowid_tbl.LAST
4808: UPDATE ar_ae_alloc_rec_gt
4809: SET ae_pro_taxable_amt = amt_tbl(m),
4810: ae_pro_taxable_acctd_amt = acctd_amt_tbl(m),
4811: ae_tax_link_id_act = link_id_tbl(m)
4812: WHERE rowid = rowid_tbl(m)

Line 4855: select /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

4851: *==========================================================================*/
4852: PROCEDURE Set_Taxable_Split_Amt(p_type_acct IN VARCHAR2) IS
4853:
4854: CURSOR set_taxable_split IS
4855: select /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
4856: a1.rowid row_id,
4857: a1.ae_link_to_cust_trx_line_id inv_line_id,
4858: a1.ae_tax_id tax_id,
4859: a1.ae_tax_type tax_type,

Line 4868: from ar_ae_alloc_rec_gt a1,

4864: 0 taxable_amt_split,
4865: 0 taxable_acctd_amt_split,
4866: '' taxable_amt_r_split,
4867: '' taxable_acctd_amt_r_split
4868: from ar_ae_alloc_rec_gt a1,
4869: (select /*+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) */
4870: a2.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
4871: a2.ae_tax_type ae_tax_type,
4872: a2.ae_tax_id ae_tax_id

Line 4869: (select /+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) /

4865: 0 taxable_acctd_amt_split,
4866: '' taxable_amt_r_split,
4867: '' taxable_acctd_amt_r_split
4868: from ar_ae_alloc_rec_gt a1,
4869: (select /*+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) */
4870: a2.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
4871: a2.ae_tax_type ae_tax_type,
4872: a2.ae_tax_id ae_tax_id
4873: from ar_ae_alloc_rec_gt a2

Line 4873: from ar_ae_alloc_rec_gt a2

4869: (select /*+ INDEX(a2 AR_AE_ALLOC_REC_GT_N3) */
4870: a2.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
4871: a2.ae_tax_type ae_tax_type,
4872: a2.ae_tax_id ae_tax_id
4873: from ar_ae_alloc_rec_gt a2
4874: where a2.ae_id = g_id
4875: and a2.ae_account_class = 'TAX'
4876: group by a2.ae_link_to_cust_trx_line_id,
4877: a2.ae_tax_type,

Line 4992: UPDATE ar_ae_alloc_rec_gt

4988: END LOOP;
4989:
4990: --Bulk update
4991: FORALL m IN rowid_tbl.FIRST .. rowid_tbl.LAST
4992: UPDATE ar_ae_alloc_rec_gt
4993: SET ae_pro_split_taxable_amt = taxable_amt_split_tbl(m),
4994: ae_pro_split_taxable_acctd_amt = taxable_acctd_amt_split_tbl(m),
4995: ae_pro_recov_taxable_amt = taxable_amt_recov_tbl(m),
4996: ae_pro_recov_taxable_acctd_amt = taxable_acctd_amt_recov_tbl(m)

Line 5061: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;

5057: l_rev_rowid VARCHAR2(50);
5058:
5059: l_not_found BOOLEAN := FALSE;
5060:
5061: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5062: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5063: g_ae_alloc_empty_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5064:
5065: CURSOR alloc_tax_rev IS

Line 5062: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;

5058:
5059: l_not_found BOOLEAN := FALSE;
5060:
5061: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5062: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5063: g_ae_alloc_empty_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5064:
5065: CURSOR alloc_tax_rev IS
5066: SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) INDEX(ae2 AR_AE_ALLOC_REC_GT_N1) */

Line 5063: g_ae_alloc_empty_tbl ar_ae_alloc_rec_gt%ROWTYPE;

5059: l_not_found BOOLEAN := FALSE;
5060:
5061: g_ae_alloc_tax_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5062: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5063: g_ae_alloc_empty_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5064:
5065: CURSOR alloc_tax_rev IS
5066: SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) INDEX(ae2 AR_AE_ALLOC_REC_GT_N1) */
5067: ae2.rowid ,

Line 5066: SELECT /+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) INDEX(ae2 AR_AE_ALLOC_REC_GT_N1) /

5062: g_ae_alloc_rev_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5063: g_ae_alloc_empty_tbl ar_ae_alloc_rec_gt%ROWTYPE;
5064:
5065: CURSOR alloc_tax_rev IS
5066: SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) INDEX(ae2 AR_AE_ALLOC_REC_GT_N1) */
5067: ae2.rowid ,
5068: ae1.ae_customer_trx_line_id ,
5069: ae1.ae_link_to_cust_trx_line_id ,
5070: ae1.ae_code_combination_id ,

Line 5079: FROM ar_ae_alloc_rec_gt ae1,

5075: ae2.ae_sum_rev_acctd_amt ,
5076: ae2.ae_count ,
5077: ae2.ae_amount ,
5078: ae2.ae_acctd_amount
5079: FROM ar_ae_alloc_rec_gt ae1,
5080: ar_ae_alloc_rec_gt ae2
5081: WHERE ae1.ae_id = g_id
5082: AND ae1.ae_account_class = 'TAX'
5083: AND ae2.ae_id = ae1.ae_id

Line 5080: ar_ae_alloc_rec_gt ae2

5076: ae2.ae_count ,
5077: ae2.ae_amount ,
5078: ae2.ae_acctd_amount
5079: FROM ar_ae_alloc_rec_gt ae1,
5080: ar_ae_alloc_rec_gt ae2
5081: WHERE ae1.ae_id = g_id
5082: AND ae1.ae_account_class = 'TAX'
5083: AND ae2.ae_id = ae1.ae_id
5084: AND ae2.ae_account_class IN ('REVEARN','REVUNEARN') --MAINTAINTAXLINKID

Line 5276: UPDATE ar_ae_alloc_rec_gt ae1

5272:
5273: /*------------------------------------------------------------------------------+
5274: | Add tax allocated amount and accounted amount to revenue amounts allocated |
5275: +------------------------------------------------------------------------------*/
5276: UPDATE ar_ae_alloc_rec_gt ae1
5277: SET ae1.ae_pro_amt = ae1.ae_pro_amt + l_tax_amt_pro_rev,
5278: ae1.ae_pro_acctd_amt = ae1.ae_pro_acctd_amt + l_tax_acctd_amt_pro_rev
5279: WHERE ae1.rowid = l_rev_rowid;
5280:

Line 5350: -- UPDATE /+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) /

5346: | Set up actual link ids for revenue lines so that at summarization only required|
5347: | number of lines are created. |
5348: +--------------------------------------------------------------------------------*/
5349: --{HYUDETUPT
5350: -- UPDATE /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
5351: -- ar_ae_alloc_rec_gt ae1
5352: -- SET ae1.ae_tax_link_id_act = decode(p_type_acct,
5353: -- 'ED_ADJ', ae1.ae_tax_link_id_ed_adj,
5354: -- 'UNED' , ae1.ae_tax_link_id_uned ,

Line 5351: -- ar_ae_alloc_rec_gt ae1

5347: | number of lines are created. |
5348: +--------------------------------------------------------------------------------*/
5349: --{HYUDETUPT
5350: -- UPDATE /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
5351: -- ar_ae_alloc_rec_gt ae1
5352: -- SET ae1.ae_tax_link_id_act = decode(p_type_acct,
5353: -- 'ED_ADJ', ae1.ae_tax_link_id_ed_adj,
5354: -- 'UNED' , ae1.ae_tax_link_id_uned ,
5355: -- '')

Line 5368: -- (SELECT /+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) /

5364: -- '','N',
5365: -- 'Y'),
5366: -- 'N') = 'Y')
5367: -- AND EXISTS
5368: -- (SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
5369: -- ae2.ae_account_class
5370: -- FROM ar_ae_alloc_rec_gt ae2
5371: -- WHERE ae2.ae_account_class = 'TAX'
5372: -- AND ae2.ae_id = ae1.ae_id

Line 5370: -- FROM ar_ae_alloc_rec_gt ae2

5366: -- 'N') = 'Y')
5367: -- AND EXISTS
5368: -- (SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
5369: -- ae2.ae_account_class
5370: -- FROM ar_ae_alloc_rec_gt ae2
5371: -- WHERE ae2.ae_account_class = 'TAX'
5372: -- AND ae2.ae_id = ae1.ae_id
5373: -- AND decode(p_type_acct,
5374: -- 'ED_ADJ', ae2.ae_tax_link_id_ed_adj,

Line 5391: UPDATE /+ index( a1 AR_AE_ALLOC_REC_GT_N4 ) /

5387: --}
5388: -- for a rev distribution ae_tax_link_id_act = ref_customer_trx_line_id
5389: -- if it exists a tax distribution with ae_tax_link_id equal to it
5390: arp_standard.debug('setlink 1');
5391: UPDATE /*+ index( a1 AR_AE_ALLOC_REC_GT_N4 ) */
5392: ar_ae_alloc_rec_gt a1
5393: SET (a1.ae_tax_link_id_act) =
5394: (SELECT /*+ index( a2 AR_AE_ALLOC_REC_GT_N4 ) */
5395: MAX(a2.ae_tax_link_id)

Line 5392: ar_ae_alloc_rec_gt a1

5388: -- for a rev distribution ae_tax_link_id_act = ref_customer_trx_line_id
5389: -- if it exists a tax distribution with ae_tax_link_id equal to it
5390: arp_standard.debug('setlink 1');
5391: UPDATE /*+ index( a1 AR_AE_ALLOC_REC_GT_N4 ) */
5392: ar_ae_alloc_rec_gt a1
5393: SET (a1.ae_tax_link_id_act) =
5394: (SELECT /*+ index( a2 AR_AE_ALLOC_REC_GT_N4 ) */
5395: MAX(a2.ae_tax_link_id)
5396: FROM ar_ae_alloc_rec_gt a2

Line 5394: (SELECT /+ index( a2 AR_AE_ALLOC_REC_GT_N4 ) /

5390: arp_standard.debug('setlink 1');
5391: UPDATE /*+ index( a1 AR_AE_ALLOC_REC_GT_N4 ) */
5392: ar_ae_alloc_rec_gt a1
5393: SET (a1.ae_tax_link_id_act) =
5394: (SELECT /*+ index( a2 AR_AE_ALLOC_REC_GT_N4 ) */
5395: MAX(a2.ae_tax_link_id)
5396: FROM ar_ae_alloc_rec_gt a2
5397: WHERE a2.ae_id = g_id
5398: AND a2.ref_account_class = 'TAX'

Line 5396: FROM ar_ae_alloc_rec_gt a2

5392: ar_ae_alloc_rec_gt a1
5393: SET (a1.ae_tax_link_id_act) =
5394: (SELECT /*+ index( a2 AR_AE_ALLOC_REC_GT_N4 ) */
5395: MAX(a2.ae_tax_link_id)
5396: FROM ar_ae_alloc_rec_gt a2
5397: WHERE a2.ae_id = g_id
5398: AND a2.ref_account_class = 'TAX'
5399: AND a1.ae_customer_trx_line_id = a2.ae_tax_link_id)
5400: WHERE a1.ae_id = g_id

Line 5407: UPDATE ar_ae_alloc_rec_gt a1

5403: /*MAINTAINTAXLINKID
5404: arp_standard.debug('setlink 2');
5405: -- for a tax distribution ae_tax_link_id_act = line_to_cust_trx_line_id
5406: -- if it exists a rev distribution with ref_customer_trx_line_id equal to it
5407: UPDATE ar_ae_alloc_rec_gt a1
5408: SET (a1.ae_tax_link_id_act) =
5409: (SELECT MAX(a2.ae_tax_link_id)
5410: FROM ar_ae_alloc_rec_gt a2
5411: WHERE a2.ae_id = g_id

Line 5410: FROM ar_ae_alloc_rec_gt a2

5406: -- if it exists a rev distribution with ref_customer_trx_line_id equal to it
5407: UPDATE ar_ae_alloc_rec_gt a1
5408: SET (a1.ae_tax_link_id_act) =
5409: (SELECT MAX(a2.ae_tax_link_id)
5410: FROM ar_ae_alloc_rec_gt a2
5411: WHERE a2.ae_id = g_id
5412: AND a2.ref_account_class IN ('REV','UNEARN','UNBILL')
5413: AND a1.ae_tax_link_id = a2.ae_customer_trx_line_id)
5414: WHERE a1.ae_id = g_id

Line 5426: UPDATE ar_ae_alloc_rec_gt a1

5422: -- Group by ae_tax_link_id_act
5423: -- 3: Proration using the elements 2 and allocation amt in 1
5424: -- ==> ae_pro_taxable_amt, ae_pro_split_taxable_amt,
5425:
5426: UPDATE ar_ae_alloc_rec_gt a1
5427: SET (a1.ae_tax_link_id_act,
5428: a1.AE_PRO_TAXABLE_AMT,
5429: a1.AE_PRO_TAXABLE_ACCTD_AMT,
5430: a1.AE_PRO_SPLIT_TAXABLE_AMT,

Line 5441: FROM ar_ae_alloc_rec_gt a2

5437: MAX(a2.AE_PRO_AMT),
5438: MAX(a2.AE_PRO_ACCTD_AMT),
5439: MAX(a2.AE_PRO_AMT),
5440: MAX(a2.AE_PRO_ACCTD_AMT)
5441: FROM ar_ae_alloc_rec_gt a2
5442: WHERE a2.ae_id = g_id
5443: AND a2.ref_account_class = 'REV'
5444: AND a1.ae_tax_link_id = a2.ae_customer_trx_line_id)
5445: WHERE a1.ae_id = g_id

Line 5530: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE ;

5526:
5527: l_gl_account_source ar_receivables_trx.gl_account_source%TYPE ;
5528: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE ;
5529: l_tax_recoverable_flag ar_receivables_trx.tax_recoverable_flag%TYPE ;
5530: l_ae_line_init_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5531:
5532: BEGIN
5533:
5534: arp_standard.debug( 'ARP_ALLOCATION_PKG.Build_Lines()+');

Line 5610: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS

5606: *==========================================================================*/
5607: PROCEDURE Build_Rev(p_gl_account_source IN ar_receivables_trx.gl_account_source%TYPE ,
5608: p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
5609: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
5610: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
5611:
5612: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5613: l_ctr BINARY_INTEGER ;
5614: l_actual_account ar_distributions.code_combination_id%TYPE ;

Line 5612: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;

5608: p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
5609: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
5610: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
5611:
5612: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5613: l_ctr BINARY_INTEGER ;
5614: l_actual_account ar_distributions.code_combination_id%TYPE ;
5615: l_source_type ar_distributions.source_type%TYPE ;
5616:

Line 5618: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;

5614: l_actual_account ar_distributions.code_combination_id%TYPE ;
5615: l_source_type ar_distributions.source_type%TYPE ;
5616:
5617: --PL/SQL table object,this collection is used for bulk processing of inserts
5618: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
5619: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;
5620: l_ae_alloc_empty_tab ae_alloc_rec_gt_tab;
5621:
5622: l_last_fetch BOOLEAN := FALSE;

Line 5639: SELECT /+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) /

5635: | dont need to summarize as only deferred tax is moved, However no additional |
5636: | accounting is required. |
5637: +-------------------------------------------------------------------------------*/
5638: CURSOR l_summarize_rev IS
5639: SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
5640: ae1.ae_tax_link_id_act,
5641: ae1.ae_customer_trx_line_id,
5642: ae1.ae_cust_trx_line_gl_dist_id,
5643: ae1.ae_ref_line_id,

Line 5700: FROM ar_ae_alloc_rec_gt ae1

5696: nvl(ae1.ae_from_pro_amt,0) ae_from_pro_amt,
5697: nvl(ae1.ae_from_pro_acctd_amt,0) ae_from_pro_acctd_amt,
5698: nvl(ae1.ae_from_pro_chrg_amt,0) ae_from_pro_chrg_amt,
5699: nvl(ae1.ae_from_pro_chrg_acctd_amt,0) ae_from_pro_chrg_acctd_amt
5700: FROM ar_ae_alloc_rec_gt ae1
5701: WHERE ae1.ae_id = g_id
5702: AND ae1.ae_account_class IN ('REVEARN',
5703: 'FREIGHT',
5704: 'REVUNEARN',

Line 5962: INSERT INTO ar_ae_alloc_rec_gt VALUES l_ae_alloc_rec_gt_tab(i);

5958: /**In procedure Assign_Elements,g_ae_ctr is incremented for each record
5959: inserted.But no code segment in this package uses the value of the
5960: variable,thus not incremented the variable here.*/
5961: FORALL i IN l_ae_alloc_rec_gt_tab.first..l_ae_alloc_rec_gt_tab.last
5962: INSERT INTO ar_ae_alloc_rec_gt VALUES l_ae_alloc_rec_gt_tab(i);
5963:
5964: --Exit Last fetch
5965: IF l_last_fetch THEN
5966: EXIT;

Line 6118: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS

6114: | from_acctd_amount_dr, from_acctd_amount_cr
6115: *==========================================================================*/
6116: PROCEDURE Build_Tax(p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
6117: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
6118: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
6119:
6120: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
6121: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
6122: l_ctr BINARY_INTEGER ;

Line 6120: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;

6116: PROCEDURE Build_Tax(p_tax_code_source IN ar_receivables_trx.tax_code_source%TYPE ,
6117: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
6118: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
6119:
6120: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
6121: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
6122: l_ctr BINARY_INTEGER ;
6123: l_actual_account ar_distributions.code_combination_id%TYPE ;
6124: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;

Line 6121: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;

6117: p_tax_recoverable_flag IN ar_receivables_trx.tax_recoverable_flag%TYPE ,
6118: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE ) IS
6119:
6120: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
6121: l_ae_line_rec_empty ar_ae_alloc_rec_gt%ROWTYPE ;
6122: l_ctr BINARY_INTEGER ;
6123: l_actual_account ar_distributions.code_combination_id%TYPE ;
6124: l_org_inv_tax_code_id ar_distributions.tax_code_id%TYPE ;
6125: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;

Line 6132: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;

6128:
6129: l_source_type_secondary ar_distributions.source_type_secondary%TYPE;
6130:
6131: --PL/SQL table object,this collection is used for bulk processing of inserts
6132: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
6133: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;
6134: l_ae_alloc_empty_tab ae_alloc_rec_gt_tab;
6135:
6136: l_last_fetch BOOLEAN := FALSE;

Line 6140: SELECT /+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) /

6136: l_last_fetch BOOLEAN := FALSE;
6137: l_bulk_index NUMBER := 0;
6138:
6139: CURSOR summarize_tax IS
6140: SELECT /*+ INDEX(ae1 AR_AE_ALLOC_REC_GT_N3) */
6141: nvl(ae_pro_amt,0) ae_pro_amt,
6142: nvl(ae_pro_acctd_amt,0) ae_pro_acctd_amt,
6143: nvl(ae_pro_taxable_amt,0) ae_pro_taxable_amt,
6144: nvl(ae_pro_taxable_acctd_amt,0) ae_pro_taxable_acctd_amt,

Line 6227: FROM ar_ae_alloc_rec_gt ae1,

6223: ae1.ae_adj_ccid
6224: ,d.code_combination_id actual_tax_ccid
6225: ,ae1.ae_unedisc_ccid
6226: ,ae1.ae_edisc_ccid
6227: FROM ar_ae_alloc_rec_gt ae1,
6228: ra_cust_trx_line_gl_dist d
6229: WHERE ae1.ae_id = g_id
6230: AND ae1.ae_account_class = 'TAX'
6231: AND ae1.ae_cust_trx_line_gl_dist_id = d.cust_trx_line_gl_dist_id(+);

Line 7204: INSERT INTO ar_ae_alloc_rec_gt VALUES l_ae_alloc_rec_gt_tab(i);

7200: /**In procedure Assign_Elements,g_ae_ctr is incremented for each record
7201: inserted.But no code segment in this package uses the value of the
7202: variable,thus not incremented the variable here.*/
7203: FORALL i IN l_ae_alloc_rec_gt_tab.first..l_ae_alloc_rec_gt_tab.last
7204: INSERT INTO ar_ae_alloc_rec_gt VALUES l_ae_alloc_rec_gt_tab(i);
7205:
7206: --Exit Last fetch
7207: IF l_last_fetch THEN
7208: EXIT;

Line 7277: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,

7273: | 21-NOV-2003 Herve Yu from_amount_dr , from_amount_cr
7274: | from_acctd_amount_dr, from_acctd_amount_cr
7275: *==========================================================================*/
7276: PROCEDURE Build_Charges_Freight_All(p_type_acct IN VARCHAR2 ,
7277: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,
7278: p_build_all IN BOOLEAN ) IS
7279:
7280: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
7281: l_actual_account ar_distributions.code_combination_id%TYPE ;

Line 7280: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;

7276: PROCEDURE Build_Charges_Freight_All(p_type_acct IN VARCHAR2 ,
7277: p_ae_line_init_rec IN ar_ae_alloc_rec_gt%ROWTYPE,
7278: p_build_all IN BOOLEAN ) IS
7279:
7280: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
7281: l_actual_account ar_distributions.code_combination_id%TYPE ;
7282: l_line_tax_amt NUMBER := 0;
7283: l_line_tax_acctd_amt NUMBER := 0;
7284:

Line 7598: p_ae_line_rec IN OUT NOCOPY ar_ae_alloc_rec_gt%ROWTYPE,

7594: --HYU--{
7595: p_from_amount IN NUMBER ,
7596: p_from_acctd_amount IN NUMBER ,
7597: --HYU--}
7598: p_ae_line_rec IN OUT NOCOPY ar_ae_alloc_rec_gt%ROWTYPE,
7599: p_paired_flag IN VARCHAR2 DEFAULT NULL,
7600: p_calling_point IN VARCHAR2 DEFAULT NULL) IS
7601:
7602: l_taxable_set BOOLEAN;

Line 7859: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;

7855: l_txb_amt NUMBER;
7856: l_txb_acctd_amt NUMBER;
7857: l_from_ent_amt NUMBER;
7858: l_from_ent_acctd_amt NUMBER;
7859: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
7860: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
7861:
7862: CURSOR summarize_lines IS
7863: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */

Line 7860: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;

7856: l_txb_acctd_amt NUMBER;
7857: l_from_ent_amt NUMBER;
7858: l_from_ent_acctd_amt NUMBER;
7859: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
7860: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
7861:
7862: CURSOR summarize_lines IS
7863: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
7864: NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0),

Line 7863: SELECT /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

7859: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
7860: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
7861:
7862: CURSOR summarize_lines IS
7863: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
7864: NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0),
7865: NVL(a1.ae_accounted_dr,0) * -1 + NVL(a1.ae_accounted_cr,0),
7866: -- SUM(NVL(ae_pro_amt,0)),
7867: -- SUM(NVL(ae_pro_acctd_amt,0)),

Line 7904: FROM ar_ae_alloc_rec_gt a1

7900: a1.ref_account_class,
7901: a1.activity_bucket,
7902: a1.ref_dist_ccid,
7903: a1.ref_mf_dist_flag
7904: FROM ar_ae_alloc_rec_gt a1
7905: WHERE a1.ae_id = g_id
7906: AND a1.ae_summarize_flag = 'N'
7907: AND a1.ae_account_class IS NULL
7908: AND (NVL(a1.ae_entered_dr,0) <> 0 OR NVL(a1.ae_entered_cr,0) <> 0 OR

Line 8173: SELECT /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

8169: al.ref_mf_dist_flag
8170: from
8171: ( --Defined it as a subquery as some of the values[Amount columns] derived in this
8172: -- select are used for further calculations in the main select.
8173: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
8174: NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0) amount,
8175: NVL(a1.ae_accounted_dr,0) * -1 + NVL(a1.ae_accounted_cr,0) acctd_amount,
8176: NVL(a1.ae_taxable_entered_dr,0) * -1 + NVL(a1.ae_taxable_entered_cr,0) taxable_amount,
8177: NVL(a1.ae_taxable_accounted_dr,0) * -1 + NVL(a1.ae_taxable_accounted_cr,0) taxable_acctd_amount,

Line 8214: FROM ar_ae_alloc_rec_gt a1

8210: a1.ref_account_class,
8211: a1.activity_bucket,
8212: a1.ref_dist_ccid,
8213: a1.ref_mf_dist_flag
8214: FROM ar_ae_alloc_rec_gt a1
8215: WHERE a1.ae_id = g_id
8216: AND a1.ae_summarize_flag = 'N'
8217: AND a1.ae_account_class IS NULL
8218: AND (NVL(a1.ae_entered_dr,0) <> 0 OR NVL(a1.ae_entered_cr,0) <> 0

Line 8278: | into the ar_ae_alloc_rec_gt. |

8274:
8275: /*------------------------------------------------------------------------------+
8276: | Build final debits and credits for entered amount. It is important to route |
8277: | through the Create Debits and Credits function, rather than directly insert |
8278: | into the ar_ae_alloc_rec_gt. |
8279: +------------------------------------------------------------------------------*/
8280: Create_Debits_Credits(l_ent_amt, l_ent_acctd_amt,
8281: l_txb_amt, l_txb_acctd_amt,
8282: l_from_ent_amt, l_from_ent_acctd_amt,

Line 8338: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;

8334: l_txb_amt NUMBER;
8335: l_txb_acctd_amt NUMBER;
8336: l_from_ent_amt NUMBER;
8337: l_from_ent_acctd_amt NUMBER;
8338: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
8339: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
8340:
8341: CURSOR summarize_lines IS
8342: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */

Line 8339: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;

8335: l_txb_acctd_amt NUMBER;
8336: l_from_ent_amt NUMBER;
8337: l_from_ent_acctd_amt NUMBER;
8338: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
8339: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
8340:
8341: CURSOR summarize_lines IS
8342: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
8343: SUM(NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0)),

Line 8342: SELECT /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

8338: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE;
8339: l_ae_empty_rec ar_ae_alloc_rec_gt%ROWTYPE;
8340:
8341: CURSOR summarize_lines IS
8342: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
8343: SUM(NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0)),
8344: SUM(NVL(a1.ae_accounted_dr,0) * -1 + NVL(a1.ae_accounted_cr,0)),
8345: SUM(NVL(a1.ae_taxable_entered_dr,0) * -1 + NVL(a1.ae_taxable_entered_cr,0)),
8346: SUM(NVL(a1.ae_taxable_accounted_dr,0) * -1 + NVL(a1.ae_taxable_accounted_cr,0)),

Line 8372: FROM ar_ae_alloc_rec_gt a1

8368: 1, a1.ae_neg_ind,
8369: ''),
8370: a1.ae_neg_ind),
8371: a1.ae_reversed_source_id
8372: FROM ar_ae_alloc_rec_gt a1
8373: WHERE a1.ae_id = g_id
8374: AND a1.ae_summarize_flag = 'N'
8375: AND a1.ae_account_class IS NULL
8376: GROUP BY a1.ae_line_type,

Line 8477: | into the ar_ae_alloc_rec_gt. |

8473:
8474: /*------------------------------------------------------------------------------+
8475: | Build final debits and credits for entered amount. It is important to route |
8476: | through the Create Debits and Credits function, rather than directly insert |
8477: | into the ar_ae_alloc_rec_gt. |
8478: +------------------------------------------------------------------------------*/
8479: Create_Debits_Credits(l_ent_amt, l_ent_acctd_amt,
8480: l_txb_amt, l_txb_acctd_amt,
8481: l_from_ent_amt, l_from_ent_acctd_amt,

Line 8570: SELECT /+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) /

8566: l_amount NUMBER := 0;
8567:
8568: BEGIN
8569:
8570: SELECT /*+ INDEX(a1 AR_AE_ALLOC_REC_GT_N3) */
8571: ABS(SUM(NVL(a1.ae_entered_dr,0) * -1 + NVL(a1.ae_entered_cr,0))) +
8572: ABS(SUM(NVL(a1.ae_accounted_dr,0) * -1 + NVL(a1.ae_accounted_cr,0))) +
8573: ABS(SUM(NVL(a1.ae_taxable_entered_dr,0) * -1 + NVL(a1.ae_taxable_entered_cr,0))) +
8574: ABS(SUM(NVL(a1.ae_taxable_accounted_dr,0) * -1 + NVL(a1.ae_taxable_accounted_cr,0)))

Line 8576: FROM ar_ae_alloc_rec_gt a1,

8572: ABS(SUM(NVL(a1.ae_accounted_dr,0) * -1 + NVL(a1.ae_accounted_cr,0))) +
8573: ABS(SUM(NVL(a1.ae_taxable_entered_dr,0) * -1 + NVL(a1.ae_taxable_entered_cr,0))) +
8574: ABS(SUM(NVL(a1.ae_taxable_accounted_dr,0) * -1 + NVL(a1.ae_taxable_accounted_cr,0)))
8575: INTO l_amount
8576: FROM ar_ae_alloc_rec_gt a1,
8577: ar_ae_alloc_rec_gt a2
8578: WHERE a1.ae_id = g_id
8579: AND a1.ae_summarize_flag = 'N'
8580: AND a1.ae_account_class IS NULL

Line 8577: ar_ae_alloc_rec_gt a2

8573: ABS(SUM(NVL(a1.ae_taxable_entered_dr,0) * -1 + NVL(a1.ae_taxable_entered_cr,0))) +
8574: ABS(SUM(NVL(a1.ae_taxable_accounted_dr,0) * -1 + NVL(a1.ae_taxable_accounted_cr,0)))
8575: INTO l_amount
8576: FROM ar_ae_alloc_rec_gt a1,
8577: ar_ae_alloc_rec_gt a2
8578: WHERE a1.ae_id = g_id
8579: AND a1.ae_summarize_flag = 'N'
8580: AND a1.ae_account_class IS NULL
8581: AND a2.rowid = p_rowid

Line 8632: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS

8628: | Hidtory
8629: | 21-NOV-2003 Herve Yu from_amount_dr , from_amount_cr,
8630: | from_acctd_amount_dr, from_acctd_amount_cr
8631: *==========================================================================*/
8632: PROCEDURE Assign_Elements(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8633:
8634: BEGIN
8635: IF PG_DEBUG IN ('Y','C') THEN
8636: arp_standard.debug( 'ARP_ALLOCATION_PKG.Assign_Elements()+');

Line 8643: insert into ar_ae_alloc_rec_gt

8639: | Store AE Line elements in AE Lines temp table |
8640: +------------------------------------------------------*/
8641: g_ae_ctr := g_ae_ctr +1;
8642:
8643: insert into ar_ae_alloc_rec_gt
8644: ( ae_id,
8645: ae_account_class ,
8646: ae_customer_trx_id ,
8647: ae_customer_trx_line_id ,

Line 8824: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS

8820: | p_ae_line_tbl IN Accounting lines table
8821: | History
8822: | 24-NOV-2003 Herve Yu Distributions in the receipt currency
8823: *=======================================================================*/
8824: PROCEDURE Insert_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8825:
8826: l_ae_line_rec ar_distributions%ROWTYPE;
8827: l_ae_line_rec_empty ar_distributions%ROWTYPE;
8828: l_dummy ar_distributions.line_id%TYPE;

Line 8947: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS

8943: | PARAMETERS
8944: | p_ae_line_tbl IN Accounting lines table
8945: |
8946: *=======================================================================*/
8947: PROCEDURE Cache_Ae_Lines(p_ae_line_tbl IN ar_ae_alloc_rec_gt%ROWTYPE) IS
8948:
8949: BEGIN
8950:
8951:

Line 9064: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2, p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS

9060: | PARAMETERS
9061: | p_type IN Indicates Rev or Tax
9062: | p_alloc_rec IN Allocation details Record
9063: *==========================================================================*/
9064: PROCEDURE Dump_Alloc_Rev_Tax(p_type IN VARCHAR2, p_alloc_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
9065:
9066: BEGIN
9067: IF PG_DEBUG in ('Y', 'C') THEN
9068: arp_standard.debug( 'ARP_ALLOCATION_PKG.Dump_Alloc_Rev_Tax()+');

Line 9255: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS

9251: |
9252: | PARAMETERS
9253: | p_ae_line_rec IN Accounting lines record
9254: *==========================================================================*/
9255: PROCEDURE Dump_Line_Amts(p_ae_line_rec IN ar_ae_alloc_rec_gt%ROWTYPE) IS
9256:
9257: BEGIN
9258:
9259: arp_standard.debug('ARP_ALLOCATION_PKG.Dump_Line_Amts()+');