APPS.AR_CREDIT_MEMO_API_PUB dependencies on RA_BATCH_SOURCES

Line 1110: FROM ra_batch_sources b

1106: IF nvl(p_skip_workflow_flag,'N') = 'Y' THEN
1107: arp_util.debug ('Before validating trx number');
1108: BEGIN
1109: SELECT 'Y' INTO l_trx_no_err
1110: FROM ra_batch_sources b
1111: WHERE b.name = p_batch_source_name
1112: AND ((p_trx_number IS NULL AND
1113: NVL(b.auto_trx_numbering_flag,'N') = 'N')
1114: OR (p_trx_number IS NOT NULL AND

Line 1315: FROM ra_batch_sources where name=p_batch_source_name;

1311: END IF;
1312:
1313: BEGIN
1314: SELECT NVL(COPY_INV_TIDFF_TO_CM_FLAG,'N') into l_copy_inv_tidff_flag
1315: FROM ra_batch_sources where name=p_batch_source_name;
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: BEGIN
1319: SELECT NVL(COPY_INV_TIDFF_TO_CM_FLAG,'N') into l_copy_inv_tidff_flag

Line 1320: FROM ra_batch_sources where batch_source_id=l_ct_trx.batch_source_id;

1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: BEGIN
1319: SELECT NVL(COPY_INV_TIDFF_TO_CM_FLAG,'N') into l_copy_inv_tidff_flag
1320: FROM ra_batch_sources where batch_source_id=l_ct_trx.batch_source_id;
1321: EXCEPTION
1322: WHEN NO_DATA_FOUND THEN
1323: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_BATCH_SOURCE');
1324: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);