APPS.AR_INVOICE_API_PUB dependencies on AR_TRX_LINES_GT

Line 71: FROM ar_trx_lines_gt

67:
68: CURSOR clink IS
69: SELECT customer_trx_line_id, link_to_trx_line_id, trx_line_id,
70: link_to_cust_trx_line_id
71: FROM ar_trx_lines_gt
72: WHERE link_to_trx_line_id IS NOT NULL
73: AND line_type in ( 'TAX', 'FREIGHT');
74:
75: CURSOR line (p_link_line_id NUMBER) IS

Line 77: FROM ar_trx_lines_gt

73: AND line_type in ( 'TAX', 'FREIGHT');
74:
75: CURSOR line (p_link_line_id NUMBER) IS
76: SELECT customer_trx_line_id
77: FROM ar_trx_lines_gt
78: WHERE trx_line_id = p_link_line_id;
79:
80: BEGIN
81:

Line 121: UPDATE ar_trx_lines_gt gt

117: ar_invoice_utils.debug ('Trx Line Id in Link Loop ' ||
118: clinkRec.trx_line_id );
119: END IF;
120:
121: UPDATE ar_trx_lines_gt gt
122: set link_to_cust_trx_line_id = l_customer_trx_line_id
123: WHERE customer_trx_line_id = clinkRec.customer_trx_line_id;
124:
125: END LOOP;

Line 127: UPDATE ar_trx_lines_gt lgt

123: WHERE customer_trx_line_id = clinkRec.customer_trx_line_id;
124:
125: END LOOP;
126:
127: UPDATE ar_trx_lines_gt lgt
128: SET (customer_trx_id, trx_date, org_id, set_of_books_id,currency_code) =
129: ( SELECT hgt.customer_trx_id, hgt.trx_date, hgt.org_id,
130: hgt.set_of_books_id, trx_currency
131: FROM ar_trx_header_gt hgt

Line 195: FROM ar_trx_lines_gt line,

191: SELECT line.customer_trx_id,
192: line.customer_trx_line_id,
193: line.trx_header_id,
194: h.gl_date
195: FROM ar_trx_lines_gt line,
196: ar_trx_header_gt h
197: WHERE line.trx_line_id = dist.trx_line_id
198: AND line.trx_header_id = h.trx_header_id
199: UNION

Line 252: FROM ar_trx_lines_gt line

248: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id,
249: (customer_trx_id, customer_trx_line_id, trx_header_id) = (
250: SELECT line.customer_trx_id, line.customer_trx_line_id,
251: trx_header_id
252: FROM ar_trx_lines_gt line
253: WHERE line.trx_line_id = sc.trx_line_id
254: AND rownum = 1);
255:
256:

Line 304: FROM ar_trx_lines_gt tlg

300: UPDATE ar_trx_contingencies_gt tcg
301: SET org_id = nvl(org_id, p_trx_system_param_rec.org_id),
302: request_id = ar_invoice_table_handler.g_request_id,
303: trx_header_id = (SELECT trx_header_id
304: FROM ar_trx_lines_gt tlg
305: WHERE tlg.trx_line_id = tcg.trx_line_id
306: AND rownum = 1);
307:
308: IF pg_debug = 'Y' THEN

Line 324: delete from ar_trx_lines_gt;

320: PROCEDURE clean_gt IS
321:
322: BEGIN
323: delete from ar_trx_header_gt;
324: delete from ar_trx_lines_gt;
325: delete from ar_trx_dist_gt;
326: delete from ar_trx_salescredits_gt;
327: --delete from ar_trx_errors_gt;
328: DELETE FROM ZX_TRX_HEADERS_GT;