APPS.ARP_ALLOCATION_PKG dependencies on RA_CUSTOMER_TRX

Line 53: ae_customer_trx_id ra_customer_trx_lines.customer_trx_id%TYPE ,

49: | Allocation Control Record Type |
50: +------------------------------------------------------------*/
51: TYPE ae_alloc_rec_type IS RECORD (
52: ae_account_class ra_cust_trx_line_gl_dist.account_class%TYPE ,
53: ae_customer_trx_id ra_customer_trx_lines.customer_trx_id%TYPE ,
54: ae_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
55: ae_link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
56: ae_tax_type VARCHAR2(3) ,
57: ae_code_combination_id ra_cust_trx_line_gl_dist.code_combination_id%TYPE ,

Line 54: ae_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,

50: +------------------------------------------------------------*/
51: TYPE ae_alloc_rec_type IS RECORD (
52: ae_account_class ra_cust_trx_line_gl_dist.account_class%TYPE ,
53: ae_customer_trx_id ra_customer_trx_lines.customer_trx_id%TYPE ,
54: ae_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
55: ae_link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
56: ae_tax_type VARCHAR2(3) ,
57: ae_code_combination_id ra_cust_trx_line_gl_dist.code_combination_id%TYPE ,
58: ae_collected_tax_ccid ra_cust_trx_line_gl_dist.collected_tax_ccid%TYPE ,

Line 55: ae_link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,

51: TYPE ae_alloc_rec_type IS RECORD (
52: ae_account_class ra_cust_trx_line_gl_dist.account_class%TYPE ,
53: ae_customer_trx_id ra_customer_trx_lines.customer_trx_id%TYPE ,
54: ae_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
55: ae_link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
56: ae_tax_type VARCHAR2(3) ,
57: ae_code_combination_id ra_cust_trx_line_gl_dist.code_combination_id%TYPE ,
58: ae_collected_tax_ccid ra_cust_trx_line_gl_dist.collected_tax_ccid%TYPE ,
59: ae_line_amount NUMBER ,

Line 88: ae_autotax ra_customer_trx_lines.autotax%TYPE

84: ae_pro_def_tax_amt NUMBER ,
85: ae_pro_def_tax_acctd_amt NUMBER ,
86: ae_summarize_flag VARCHAR2(1) ,
87: ae_counted_flag VARCHAR2(1) ,
88: ae_autotax ra_customer_trx_lines.autotax%TYPE
89: );
90: /*----------------------------------------------------------------------+
91: | Table which stores details for Invoice Revenue and Tax distributions |
92: | and their tax code details. |

Line 101: ae_inv_line ra_customer_trx_lines.customer_trx_line_id%TYPE,

97: /*--------------------------------------------------------------------+
98: | Invoice Lines Revenue amounts and revenue accounted amount totals |
99: +--------------------------------------------------------------------*/
100: TYPE ae_rev_total_rec IS RECORD (
101: ae_inv_line ra_customer_trx_lines.customer_trx_line_id%TYPE,
102: ae_sum_rev_amt NUMBER,
103: ae_sum_rev_acctd_amt NUMBER,
104: ae_count NUMBER
105: );

Line 119: ae_inv_line ra_customer_trx_lines.customer_trx_line_id%TYPE,

115: | Table which stores link id and revenue allocated totals for line amounts|
116: +--------------------------------------------------------------------------*/
117: TYPE ae_link_rec IS RECORD (
118: ae_tax_link_id NUMBER,
119: ae_inv_line ra_customer_trx_lines.customer_trx_line_id%TYPE,
120: ae_sum_alloc_amt NUMBER,
121: ae_sum_alloc_acctd_amt NUMBER,
122: ae_run_amt_tot NUMBER,
123: ae_run_acctd_amt_tot NUMBER,

Line 159: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

155: PROCEDURE Allocate_Tax ( p_ae_doc_rec IN ae_doc_rec_type ,
156: p_ae_event_rec IN ae_event_rec_type ,
157: p_ae_rule_rec IN ae_rule_rec_type ,
158: p_app_rec IN ar_receivable_applications%ROWTYPE ,
159: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
160: p_adj_rec IN ar_adjustments%ROWTYPE ,
161: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER ,
162: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type ,
163: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,

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

159: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
160: p_adj_rec IN ar_adjustments%ROWTYPE ,
161: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER ,
162: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type ,
163: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,
164: p_simul_app IN VARCHAR2 default NULL ,
165: --{HYUDETUPT
166: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
167: p_gt_id IN NUMBER DEFAULT NULL,