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_ETAX_SERVICES_PKG dependencies on RA_CUSTOMER_TRX

Line 12: pg_new_line_rec ra_customer_trx_lines%rowtype;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARP_ETAX_SERVICES_PKG';
9:
10: -- for Manual tax lines, store the line information that the user overrides:
11: pg_extended_amount_changed BOOLEAN := FALSE;
12: pg_new_line_rec ra_customer_trx_lines%rowtype;
13: pg_tax_amount_changed BOOLEAN := FALSE;
14: pg_line_changed BOOLEAN := FALSE;
15:
16: pg_use_inv_acctg VARCHAR2(1);

Line 27: TYPE table_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%TYPE

23:
24: /*--------------------------------------------------------+
25: | Table records for record and replace tax accounts |
26: +--------------------------------------------------------*/
27: TYPE table_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE

Line 39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE

35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE
38: INDEX BY BINARY_INTEGER;
39: TYPE tax_rate_type IS TABLE OF ra_customer_trx_lines_all.vat_tax_id%TYPE
40: INDEX BY BINARY_INTEGER;
41:
42: t_customer_trx_id table_id_type;
43: t_customer_trx_line_id table_id_type;

Line 235: ra_customer_trx ct,

231: ct.org_id,
232: rec_ctlgd.event_id
233: FROM
234: fnd_currencies foreign_fc,
235: ra_customer_trx ct,
236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,

Line 236: ra_customer_trx_lines ctl,

232: rec_ctlgd.event_id
233: FROM
234: fnd_currencies foreign_fc,
235: ra_customer_trx ct,
236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,

Line 239: ra_customer_trx prev_ct,

235: ra_customer_trx ct,
236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,
241: ra_cust_trx_line_gl_dist prev_ctlgd
242: WHERE
243: ct.customer_trx_id = p_customer_trx_id

Line 240: ra_customer_trx_lines prev_ctl,

236: ra_customer_trx_lines ctl,
237: ra_cust_trx_line_gl_dist ctlgd,
238: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
239: ra_customer_trx prev_ct,
240: ra_customer_trx_lines prev_ctl,
241: ra_cust_trx_line_gl_dist prev_ctlgd
242: WHERE
243: ct.customer_trx_id = p_customer_trx_id
244: AND ct.customer_trx_id = ctl.customer_trx_id

Line 292: FROM ra_customer_trx_lines tl,

288: zx.tax_regime_code, -- ZX tax regime code
289: zx.tax, -- ZX tax code
290: tgl.code_combination_id, -- tax account!
291: tl.vat_tax_id -- Tax Rate ID
292: FROM ra_customer_trx_lines tl,
293: ra_cust_trx_line_gl_dist tgl,
294: zx_lines zx
295: WHERE tl.customer_trx_id = p_customer_trx_id
296: AND tl.line_type = 'TAX'

Line 384: ra_customer_trx_lines tl,

380: AND account_class = 'TAX'
381: AND cust_trx_line_gl_dist_id IN
382: (SELECT tgl.cust_trx_line_gl_dist_id
383: FROM ra_cust_trx_line_gl_dist tgl,
384: ra_customer_trx_lines tl,
385: zx_lines zx
386: WHERE tl.customer_trx_id = t_customer_trx_id(i)
387: AND tl.link_to_cust_trx_line_id =
388: t_customer_trx_line_id(i)

Line 514: -- insert Tax records into ra_customer_trx_lines based upon

510:
511: arp_util.debug('return status service = ' || l_return_status_service);
512:
513: IF (l_return_status_service = 'S') THEN
514: -- insert Tax records into ra_customer_trx_lines based upon
515: -- customer trx line id
516: arp_util.debug('calling build_ar_tax_lines ...');
517: arp_util.debug('customer trx id = ' || p_customer_trx_id);
518:

Line 573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;

569: p_event_class_code IN VARCHAR2,
570: p_line_level_action IN VARCHAR2,
571: p_tax_amount IN NUMBER DEFAULT NULL) IS
572:
573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;
574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;

Line 574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;

570: p_line_level_action IN VARCHAR2,
571: p_tax_amount IN NUMBER DEFAULT NULL) IS
572:
573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;
574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;

Line 575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;

571: p_tax_amount IN NUMBER DEFAULT NULL) IS
572:
573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;
574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861

Line 576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;

572:
573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;
574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861
580:

Line 577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;

573: l_line_ship_to_cust_id RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE;
574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861
580:
581: --Variables defined for Bug6126010.

Line 578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;

574: l_line_ship_to_su_id RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE;
575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861
580:
581: --Variables defined for Bug6126010.
582: p_salesrep_id NUMBER;

Line 579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861

575: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
576: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
577: l_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
578: l_site_use_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
579: l_memo_line_id RA_CUSTOMER_TRX_LINES.memo_line_id%TYPE; --bug6770861
580:
581: --Variables defined for Bug6126010.
582: p_salesrep_id NUMBER;
583: p_ccid NUMBER;

Line 890: RA_CUSTOMER_TRX TRX,

886: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_location_id(1),
887: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(1),
888: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DESCRIPTION(1)
889: FROM
890: RA_CUSTOMER_TRX TRX,
891: RA_CUSTOMER_TRX_LINES LINES,
892: RA_CUST_TRX_LINE_GL_DIST REC,
893: FND_CURRENCIES CURR,
894: FND_DOCUMENT_SEQUENCES SEQ,

Line 891: RA_CUSTOMER_TRX_LINES LINES,

887: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(1),
888: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DESCRIPTION(1)
889: FROM
890: RA_CUSTOMER_TRX TRX,
891: RA_CUSTOMER_TRX_LINES LINES,
892: RA_CUST_TRX_LINE_GL_DIST REC,
893: FND_CURRENCIES CURR,
894: FND_DOCUMENT_SEQUENCES SEQ,
895: AR_SYSTEM_PARAMETERS AR,

Line 904: RA_CUSTOMER_TRX INV,

900: HZ_CUST_ACCT_SITES BILL_AS,
901: HZ_CUST_SITE_USES BILL_SU,
902: HZ_PARTY_SITES BILL_PS,
903: HZ_LOCATIONS BILL_LOC,
904: RA_CUSTOMER_TRX INV,
905: RA_CUST_TRX_TYPES INV_TT,
906: HR_ALL_ORGANIZATION_UNITS HR,
907: HR_ORGANIZATION_UNITS HRL,
908: RA_CUSTOMER_TRX REL_T,

Line 908: RA_CUSTOMER_TRX REL_T,

904: RA_CUSTOMER_TRX INV,
905: RA_CUST_TRX_TYPES INV_TT,
906: HR_ALL_ORGANIZATION_UNITS HR,
907: HR_ORGANIZATION_UNITS HRL,
908: RA_CUSTOMER_TRX REL_T,
909: RA_CUST_TRX_TYPES REL_TT,
910: AR_MEMO_LINES_B ML
911: WHERE
912: TRX.customer_trx_id = p_customer_trx_id and

Line 954: FROM ra_customer_trx_lines ctl, ra_customer_trx ctx

950:
951: SELECT ctl.inventory_item_id, ctl.memo_line_id,
952: ctx.cust_trx_type_id, ctx.primary_salesrep_id
953: INTO p_inv_item_id, p_memo_line_id, p_trx_type_id, p_salesrep_id
954: FROM ra_customer_trx_lines ctl, ra_customer_trx ctx
955: WHERE ctl.customer_trx_id = p_customer_trx_id
956: AND ctl.customer_trx_line_id = p_customer_trx_line_id
957: AND ctl.customer_trx_id=ctx.customer_trx_id;
958:

Line 1195: p_line_rec IN ra_customer_trx_lines%rowtype,

1191: |
1192: *===========================================================================*/
1193: PROCEDURE set_line_flags(
1194: p_customer_trx_line_id IN NUMBER,
1195: p_line_rec IN ra_customer_trx_lines%rowtype,
1196: p_inventory_item_changed OUT NOCOPY boolean,
1197: p_memo_line_changed OUT NOCOPY boolean,
1198: p_quantity_changed OUT NOCOPY boolean,
1199: p_extended_amount_changed OUT NOCOPY boolean,

Line 1207: l_old_line_rec ra_customer_trx_lines%rowtype;

1203: p_tax_code_changed OUT NOCOPY boolean,
1204: p_warehouse_flag_changed OUT NOCOPY boolean,
1205: p_ship_to_changed OUT NOCOPY boolean ) IS
1206:
1207: l_old_line_rec ra_customer_trx_lines%rowtype;
1208:
1209: l_inventory_item_changed BOOLEAN;
1210: l_memo_line_changed BOOLEAN;
1211: l_quantity_changed BOOLEAN;

Line 1413: FROM ra_customer_trx_lines lines

1409: PROCEDURE delete_tax_f_ctl_id( p_customer_trx_line_id IN Number ) IS
1410:
1411: cursor s_tax_lines_for_inv_line( p_customer_trx_line_id in number ) IS
1412: SELECT lines.customer_trx_line_id
1413: FROM ra_customer_trx_lines lines
1414: WHERE link_to_cust_trx_line_id = p_customer_trx_line_id
1415: AND line_type = 'TAX';
1416:
1417: BEGIN

Line 1481: p_line_rec IN ra_customer_trx_lines%rowtype,

1477: *===========================================================================*/
1478:
1479: PROCEDURE before_update_line(
1480: p_customer_trx_line_id IN Number,
1481: p_line_rec IN ra_customer_trx_lines%rowtype,
1482: p_recalc_tax OUT NOCOPY BOOLEAN ) IS
1483:
1484: l_inventory_item_changed BOOLEAN;
1485: l_memo_line_changed BOOLEAN;

Line 1563: FROM ra_customer_trx

1559:
1560:
1561: CURSOR TRX_Header IS
1562: SELECT *
1563: FROM ra_customer_trx
1564: WHERE customer_trx_id = p_customer_trx_id;
1565:
1566: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
1567: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;

Line 1569: l_trx_header_rec ra_customer_trx%ROWTYPE;

1565:
1566: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
1567: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
1568: l_transaction_line_rec zx_api_pub.transaction_line_rec_type;
1569: l_trx_header_rec ra_customer_trx%ROWTYPE;
1570:
1571: l_return_status_service VARCHAR2(4000);
1572: l_msg_count NUMBER;
1573: l_msg_data VARCHAR2(4000);

Line 1645: | the tax lines from ra_Customer_Trx_lines and its associated accounting

Line 1664: -- delete tax line from ra_customer_Trx_lines and associated accting.

1660: BEGIN
1661:
1662: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()+');
1663:
1664: -- delete tax line from ra_customer_Trx_lines and associated accting.
1665:
1666: arp_etax_services_pkg.delete_tax_f_ctl_id(
1667: p_customer_trx_line_id => p_customer_trx_line_id);
1668:

Line 2082: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;

2078: x_msg_count OUT NOCOPY NUMBER,
2079: x_msg_data OUT NOCOPY VARCHAR2 ) IS
2080:
2081: l_hdr_det_factors_rec zx_api_pub.header_det_factors_rec_type;
2082: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
2083: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
2084: l_action VARCHAR2(12);
2085: l_success BOOLEAN;
2086: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 2083: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;

2079: x_msg_data OUT NOCOPY VARCHAR2 ) IS
2080:
2081: l_hdr_det_factors_rec zx_api_pub.header_det_factors_rec_type;
2082: l_hdr_ship_to_cust_id RA_CUSTOMER_TRX.ship_to_customer_id%TYPE;
2083: l_hdr_ship_to_su_id RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE;
2084: l_action VARCHAR2(12);
2085: l_success BOOLEAN;
2086: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
2087: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;

Line 2268: RA_CUSTOMER_TRX TRX,

2264: l_hdr_ship_to_su_id,
2265: l_hdr_det_factors_rec.bill_to_cust_acct_site_use_id,
2266: l_hdr_det_factors_rec.application_doc_status
2267: FROM
2268: RA_CUSTOMER_TRX TRX,
2269: FND_CURRENCIES CURR,
2270: FND_DOCUMENT_SEQUENCES SEQ,
2271: AR_SYSTEM_PARAMETERS AR,
2272: RA_BATCH_SOURCES BS,

Line 2300: FROM ra_customer_trx_lines

2296: determine if the user is nulling the ship to
2297: out, or it is not changed */
2298: SELECT count(*)
2299: INTO l_llst_exists
2300: FROM ra_customer_trx_lines
2301: WHERE customer_trx_id = p_customer_trx_id
2302: AND line_type = 'LINE'
2303: AND ship_to_customer_id IS NOT NULL
2304: AND ship_to_site_use_id IS NOT NULL;

Line 2492: -- insert Tax records into ra_customer_trx_lines based upon

2488:
2489: arp_util.debug('return status service = ' || x_return_status);
2490:
2491: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2492: -- insert Tax records into ra_customer_trx_lines based upon
2493: -- customer trx id
2494: arp_util.debug('calling build_ar_tax_lines ...');
2495:
2496: arp_etax_util.build_ar_tax_lines(

Line 2518: from ra_customer_trx

2514: select previous_customer_trx_id,
2515: DECODE(invoicing_rule_id, NULL, 'N', 'Y')
2516: into l_is_reg_cm,
2517: l_rules_check_flag
2518: from ra_customer_trx
2519: where customer_trx_id = p_customer_trx_id;
2520:
2521:
2522: IF l_event_class_code = 'CREDIT_MEMO' and

Line 2641: | actions. IF there is no data in the ra_customer_Trx_lines table

Line 2662: FROM ra_customer_trx_lines

2658: arp_util.debug('ARP_ETAX_SERVICES_PKG.Get_Tax_Action(+)');
2659:
2660: select count(customer_trx_id)
2661: INTO l_count
2662: FROM ra_customer_trx_lines
2663: where customer_Trx_id = p_customer_trx_id and
2664: line_type = 'LINE';
2665:
2666: IF (l_count = 0 ) then

Line 2757: -- insert Tax records into ra_customer_trx_lines based upon

2753: x_msg_data => l_msg_data);
2754:
2755: -- update AR with return from tax
2756: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2757: -- insert Tax records into ra_customer_trx_lines based upon
2758: -- customer trx id
2759: arp_util.debug('calling build_ar_tax_lines ...');
2760:
2761: arp_etax_util.build_ar_tax_lines(

Line 2838: FROM ra_customer_trx

2834: arp_util.debug('ARP_ETAX_SERVICES_PKG.is_tax_update_allowed()+');
2835:
2836: SELECT complete_flag
2837: INTO l_complete_flag
2838: FROM ra_customer_trx
2839: WHERE customer_trx_id = p_customer_trx_id;
2840:
2841: IF (l_complete_flag = 'Y' )
2842: THEN

Line 2893: l_trx_number RA_CUSTOMER_TRX.trx_number%type;

2889: l_trx_rec ZX_API_PUB.transaction_rec_type;
2890: l_validation_status VARCHAR2(1);
2891: l_hold_codes_tbl ZX_API_PUB.hold_codes_tbl_type;
2892: l_error_count NUMBER;
2893: l_trx_number RA_CUSTOMER_TRX.trx_number%type;
2894: l_msg VARCHAR2(2000);
2895:
2896: CURSOR c_errors IS
2897: select trx_id, trx_line_id, message_name, message_text

Line 2929: from ra_customer_trx t,

2925: l_trx_rec.entity_code,
2926: l_trx_rec.event_class_code,
2927: l_trx_rec.event_type_code,
2928: l_trx_number
2929: from ra_customer_trx t,
2930: ra_cust_trx_types tt
2931: where t.customer_trx_id = p_customer_trx_id
2932: and t.cust_trx_type_id = tt.cust_trx_type_id
2933: and t.org_id = tt.org_id;