DBA Data[Home] [Help]

APPS.AR_ADJUST_PUB dependencies on AR_LLCA_ADJ_TRX_LINES_GT

Line 1302: delete from ar_llca_adj_trx_lines_gt

1298:
1299: p_return_status := FND_API.G_RET_STS_SUCCESS;
1300:
1301: -- Clean the GT Table first.
1302: delete from ar_llca_adj_trx_lines_gt
1303: where customer_trx_id = p_customer_trx_id;
1304:
1305: delete from ar_llca_adj_trx_errors_gt
1306: where customer_trx_id = p_customer_trx_id;

Line 1325: Insert into ar_llca_adj_trx_lines_gt

1321: =>'||to_char(p_llca_adj_trx_lines_tbl.count));
1322: END IF;
1323: For i in p_llca_adj_trx_lines_tbl.FIRST..p_llca_adj_trx_lines_tbl.LAST
1324: Loop
1325: Insert into ar_llca_adj_trx_lines_gt
1326: ( customer_trx_id,
1327: customer_trx_line_id,
1328: receivables_trx_id,
1329: line_amount

Line 2163: select * from ar_llca_adj_trx_lines_gt

2159: l_adj_int_count number := 0;
2160: l_chk_count number := 0;
2161:
2162: cursor gt_adj_lines_cur (p_cust_trx_id in number) is
2163: select * from ar_llca_adj_trx_lines_gt
2164: where customer_trx_id = p_cust_trx_id;
2165:
2166:
2167: BEGIN