[Home] [Help]
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;
1307:
1308:
1309:
2397:
2398: -- Check for null customer trx line id
2399: IF gt_adj_lines_row.customer_trx_line_id IS NULL -- Check for null Customer Trx Line Id
2400: THEN
2401: insert into ar_llca_adj_trx_errors_gt
2402: (
2403: customer_trx_id,
2404: customer_trx_line_id,
2405: receivables_trx_id,
2419:
2420: ELSIF gt_adj_lines_row.receivables_trx_id IS NULL
2421: THEN
2422:
2423: insert into ar_llca_adj_trx_errors_gt
2424: (
2425: customer_trx_id,
2426: customer_trx_line_id,
2427: receivables_trx_id,