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 RA_CUSTOMER_TRX

Line 12: g_cust_inv_rec ra_customer_trx%ROWTYPE;

8: g_ae_event_rec ae_event_rec_type;
9: g_ae_rule_rec ae_rule_rec_type;
10: g_ae_sys_rec ae_sys_rec_type;
11: g_ae_curr_rec ae_curr_rec_type;
12: g_cust_inv_rec ra_customer_trx%ROWTYPE;
13:
14: g_ae_summarize_tbl ae_line_tbl_type;
15: g_ae_empty_line_tbl ae_line_tbl_type;
16: g_ae_rev_ctr BINARY_INTEGER := 0; -- Count of revenue lines

Line 44: g_br_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

40: g_link_ctr NUMBER := 0;
41: g_bulk_fetch_rows NUMBER := 400;
42: g_override1 VARCHAR2(1);
43: g_override2 VARCHAR2(1);
44: g_br_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
45: g_simul_app VARCHAR2(1);
46: g_ae_code_combination_id_app NUMBER;
47:
48: g_exec VARCHAR2(30);

Line 64: PROCEDURE Get_Tax_Curr(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,

60: p_bucket IN VARCHAR2,
61: p_ctlgd_id IN NUMBER,
62: x_ccid IN OUT NOCOPY NUMBER);
63:
64: PROCEDURE Get_Tax_Curr(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
65: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE);
66:
67: PROCEDURE Get_Invoice_Distributions(p_invoice_id IN NUMBER,
68: p_app_rec IN ar_receivable_applications%ROWTYPE,

Line 79: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,

75: p_adj_rec IN ar_adjustments%ROWTYPE,
76: p_override1 OUT NOCOPY VARCHAR2,
77: p_override2 OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
80: p_app_rec IN ar_receivable_applications%ROWTYPE,
81: p_adj_rec IN ar_adjustments%ROWTYPE,
82: p_rev_rec_req OUT NOCOPY BOOLEAN,
83: p_required OUT NOCOPY BOOLEAN);

Line 351: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,

347: p_ae_doc_rec IN ae_doc_rec_type,
348: p_ae_event_rec IN ae_event_rec_type,
349: p_ae_rule_rec IN ae_rule_rec_type,
350: p_app_rec IN ar_receivable_applications%ROWTYPE,
351: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
352: p_adj_rec IN ar_adjustments%ROWTYPE,
353: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER,
354: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type,
355: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,

Line 355: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,

351: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
352: p_adj_rec IN ar_adjustments%ROWTYPE,
353: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER,
354: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type,
355: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,
356: p_simul_app IN VARCHAR2 default NULL,
357: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
358: p_gt_id IN NUMBER DEFAULT NULL,
359: -- this flag is introduced to indicate if the application need conversion

Line 363: l_invoice_id ra_customer_trx.customer_trx_id%TYPE ;

359: -- this flag is introduced to indicate if the application need conversion
360: p_inv_cm IN VARCHAR2 DEFAULT 'I'
361: ) IS
362:
363: l_invoice_id ra_customer_trx.customer_trx_id%TYPE ;
364: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ;
365: l_ed_adj_acct VARCHAR2(10) := 0;
366: l_uned_acct VARCHAR2(10) := 0;
367: l_linked_tax BOOLEAN := FALSE;

Line 544: FROM ra_customer_trx

540:
541: /* Initialize zx */
542: SELECT legal_entity_id
543: INTO l_le_id
544: FROM ra_customer_trx
545: WHERE customer_trx_id = l_invoice_id;
546:
547: zx_api_pub.set_tax_security_context(
548: p_api_version => 1.0,

Line 916: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,

912: | needs to be run
913: | p_required OUT Flag indicates whether tax processing
914: | is required
915: * ======================================================================*/
916: PROCEDURE Check_Entry(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE,
917: p_app_rec IN ar_receivable_applications%ROWTYPE,
918: p_adj_rec IN ar_adjustments%ROWTYPE,
919: p_rev_rec_req OUT NOCOPY BOOLEAN,
920: p_required OUT NOCOPY BOOLEAN) IS

Line 967: from ra_customer_trx_lines ctl

963: END IF;
964:
965: select ctl.customer_trx_id
966: into l_dummy
967: from ra_customer_trx_lines ctl
968: where ctl.customer_trx_id = p_invoice_id
969: and ctl.autorule_complete_flag||'' = 'N'
970: group by ctl.customer_trx_id;
971:

Line 1039: PROCEDURE Get_Tax_Curr(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE ,

1035: |
1036: | PARAMETERS
1037: | p_invoice_id IN Invoice identifier
1038: * ======================================================================*/
1039: PROCEDURE Get_Tax_Curr(p_invoice_id IN ra_customer_trx.customer_trx_id%TYPE ,
1040: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1041:
1042: BEGIN
1043: IF PG_DEBUG in ('Y', 'C') THEN

Line 1066: from ra_customer_trx ct ,

1062: g_ae_curr_rec.minimum_accountable_unit ,
1063: g_amount_due_remaining ,
1064: g_acctd_amount_due_remaining ,
1065: g_amount_due_original
1066: from ra_customer_trx ct ,
1067: ar_payment_schedules pay ,
1068: fnd_currencies fc
1069: where ct.customer_trx_id = p_invoice_id
1070: and pay.customer_trx_id = ct.customer_trx_id

Line 1408: FROM ra_customer_trx_lines ctl,

1404: det.from_amount ae_from_pro_amt,
1405: det.from_acctd_amount ae_from_pro_acctd_amt,
1406: det.ccid ref_dist_ccid,
1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id

Line 1410: ra_customer_trx_lines line,

1406: det.ccid ref_dist_ccid,
1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id
1413: and ctl.line_type = 'TAX'
1414: and gld.customer_trx_line_id = ctl.customer_trx_line_id

Line 1424: from ra_customer_trx_lines ctl1

1420: AND det.ref_cust_trx_line_gl_dist_id = gld.cust_trx_line_gl_dist_id
1421: AND det.gt_id = g_id
1422: AND det.ledger_id = g_ae_sys_rec.set_of_books_id;
1423: /* and not exists (select 'x'
1424: from ra_customer_trx_lines ctl1
1425: where ctl1.customer_trx_id = p_invoice_id
1426: and ctl1.autorule_complete_flag = 'N') */
1427: /* nvl(tax.location_segment_id,tax.vat_tax_id),
1428: decode(tax.location_segment_id,

Line 1852: from ra_customer_trx_lines ctl,

1848: --{ref_dist_ccid
1849: det.ccid ref_dist_ccid,
1850: det.ref_mf_dist_flag ref_mf_dist_flag
1851: --}
1852: from ra_customer_trx_lines ctl,
1853: ra_cust_trx_line_gl_dist gld,
1854: ar_line_app_detail_gt det,
1855: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
1856: max(decode(g_ae_rule_rec.gl_account_source1,

Line 1931: from ra_customer_trx_lines ctl,

1927: gld.gl_date,
1928: 'UNEDISC'),
1929: ''),
1930: '')) override_ccid2
1931: from ra_customer_trx_lines ctl,
1932: ra_cust_trx_line_gl_dist gld
1933: where gld.customer_trx_line_id = ctl.customer_trx_line_id
1934: and gld.account_set_flag = 'N'
1935: and ctl.customer_trx_id = p_invoice_id

Line 1938: from ra_customer_trx_lines ctl1,

1934: and gld.account_set_flag = 'N'
1935: and ctl.customer_trx_id = p_invoice_id
1936: and ctl.rowid in
1937: (select min(ctl1.rowid)
1938: from ra_customer_trx_lines ctl1,
1939: (select /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
1940: count(*) tax_count
1941: from ar_ae_alloc_rec_gt b3
1942: where b3.ae_id = g_id

Line 1965: from ra_customer_trx_lines ctl1

1961: AND det.ref_cust_trx_line_gl_dist_id = gld.cust_trx_line_gl_dist_id
1962: AND det.ledger_id = g_ae_sys_rec.set_of_books_id
1963: AND det.gt_id = g_id;
1964: /* and not exists (select 'x'
1965: from ra_customer_trx_lines ctl1
1966: where ctl1.customer_trx_id = p_invoice_id
1967: and ctl1.autorule_complete_flag = 'N') */
1968: -- group by decode(gld.account_class,
1969: -- 'REV' ,'REVEARN',

Line 8042: from ra_customer_trx_lines a2

8038:
8039: select sum(a1.tax_count)
8040: into l_count
8041: from (select 1 tax_count
8042: from ra_customer_trx_lines a2
8043: where a2.line_type = 'TAX'
8044: and a2.link_to_cust_trx_line_id = p_invoice_line_id
8045: group by nvl(a2.location_segment_id, a2.vat_tax_id),
8046: decode(a2.location_segment_id,

Line 8936: FROM ra_customer_trx_lines tl

8932: arp_etax_util.get_tax_account(tl.customer_trx_line_id,
8933: trunc(sysdate),
8934: 'FINCHRG',
8935: 'TAX_LINE')
8936: FROM ra_customer_trx_lines tl
8937: WHERE tl.customer_trx_id = p_customer_trx_id
8938: AND tl.line_type = 'TAX'
8939: AND tl.tax_line_id IS NOT NULL;
8940:

Line 8962: FROM ra_customer_trx

8958: THEN
8959: /* get LE from target trx */
8960: SELECT legal_entity_id
8961: INTO l_le_id
8962: FROM ra_customer_trx
8963: WHERE customer_trx_id = p_customer_trx_id;
8964: ELSE
8965: /* Not required/used, set to null */
8966: l_le_id := NULL;