APPS.ARP_ACCT_EVENT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN

110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');
111: FND_MSG_PUB.ADD;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: END IF;
114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
115: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
118: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');

Line 380: ar_receivable_applications ra

376: ra.customer_trx_id trx_id,
377: ra.event_id event_id
378: FROM ra_customer_trx trx,
379: ra_cust_trx_types ctt,
380: ar_receivable_applications ra
381: WHERE trx.customer_trx_id = p_source_int_id
382: AND ctt.cust_trx_type_id= trx.cust_trx_type_id
383: AND ctt.org_id = trx.org_id
384: AND ctt.type = 'CM'

Line 413: FROM ar_receivable_applications ra

409: UNION ALL
410: SELECT ra.gl_date gl_date,
411: ra.cash_receipt_id cash_receipt_id,
412: ra.event_id event_id
413: FROM ar_receivable_applications ra
414: WHERE ra.cash_receipt_id = p_source_int_id
415: AND ra.status = 'APP');
416:
417:

Line 949: ar_receivable_applications_all ra

945: p_type IN VARCHAR2)
946: IS
947: SELECT ra.receivable_application_id
948: FROM ar_distributions_all ard,
949: ar_receivable_applications_all ra
950: WHERE ard.source_table = 'RA'
951: AND ra.status = 'APP'
952: AND ard.source_id = ra.receivable_application_id
953: AND ra.gl_date BETWEEN p_start_date AND p_end_date

Line 980: p_entity => 'AR_RECEIVABLE_APPLICATIONS_ALL',

976: (p_start_date => p_start_date,
977: p_end_date => p_end_date,
978: p_org_id => p_org_id,
979: p_type => p_type,
980: p_entity => 'AR_RECEIVABLE_APPLICATIONS_ALL',
981: x_return_status => x_return_status);
982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: RAISE fnd_api.g_exc_error;
984: END IF;

Line 1492: FROM AR_RECEIVABLE_APPLICATIONS

1488: FROM AR_CASH_RECEIPT_HISTORY
1489: WHERE CASH_RECEIPT_ID = p_source_id_int_1
1490: UNION ALL
1491: SELECT 'RA', RECEIVABLE_APPLICATION_ID
1492: FROM AR_RECEIVABLE_APPLICATIONS
1493: WHERE CASH_RECEIPT_ID = p_source_id_int_1 )
1494: AND source_type NOT IN ('UNID');
1495: ELSE
1496: RAISE fnd_api.g_exc_error;