DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on RA_CUSTOMER_TRX_LINES_GT

Line 1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;

1315:
1316: IF(p_called_from = 'OZFAPI') THEN
1317:
1318: if ( FND_API.to_Boolean(p_commit) = FALSE ) then
1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1320:
1321: IF (l_gt > 0 ) then
1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1323: end if;

Line 1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;

1318: if ( FND_API.to_Boolean(p_commit) = FALSE ) then
1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1320:
1321: IF (l_gt > 0 ) then
1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1323: end if;
1324:
1325: end if;
1326: l_called_from := NULL;