DBA Data[Home] [Help]

APPS.AR_INVOICE_TABLE_HANDLER dependencies on AR_TRX_LINES_GT

Line 9: p_trx_lines_rec IN ar_trx_lines_gt%rowtype,

5:
6: PROCEDURE generate_default_salescredit(
7: p_cust_trx_id IN NUMBER,
8: p_cust_trx_line_id IN NUMBER,
9: p_trx_lines_rec IN ar_trx_lines_gt%rowtype,
10: x_errmsg OUT NOCOPY VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2 ) IS
12:
13: l_status1 VARCHAR2(2000);

Line 28: FROM ar_trx_lines_gt

24: INTO l_cnt
25: FROM ar_trx_salescredits_gt
26: WHERE trx_line_id = (
27: SELECT trx_line_id
28: FROM ar_trx_lines_gt
29: WHERE customer_trx_line_id = p_cust_trx_line_id);
30:
31: IF l_cnt = 0 -- means user has not passed saleccredit
32: THEN

Line 110: ar_trx_lines_rec IN ar_trx_lines_gt%rowtype,

106: return;
107: END;
108:
109: PROCEDURE INSERT_TRX_LINES (
110: ar_trx_lines_rec IN ar_trx_lines_gt%rowtype,
111: p_cust_trx_id IN NUMBER,
112: p_batch_id NUMBER DEFAULT NULL,
113: x_errmsg OUT NOCOPY VARCHAR2,
114: x_return_status OUT NOCOPY VARCHAR2) IS

Line 299: ar_trx_lines_rec IN ar_trx_lines_gt%rowtype,

295: than the trx workbench (individual calls) for performance reasons. */
296:
297: PROCEDURE GET_DEFAULT_TAX_CODE (
298: ar_trx_header_rec IN ar_trx_header_gt%rowtype,
299: ar_trx_lines_rec IN ar_trx_lines_gt%rowtype,
300: p_vat_tax_id OUT NOCOPY NUMBER,
301: p_amt_incl_tax_flag OUT NOCOPY VARCHAR2,
302: x_errmsg OUT NOCOPY VARCHAR2,
303: x_return_status OUT NOCOPY VARCHAR2 ) AS

Line 517: SELECT * FROM ar_trx_lines_gt gt

513: ar_trx_errors_gt err
514: WHERE err.trx_header_id = gt.trx_header_id);
515:
516: CURSOR ar_trx_lines_c IS
517: SELECT * FROM ar_trx_lines_gt gt
518: WHERE trx_header_id = l_trx_header_id
519: order by trx_header_id, trx_line_id, line_number;
520:
521: CURSOR ar_trx_dist_c IS