APPS.ARP_ACCT_EVENT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 115: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN

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

Line 381: ar_receivable_applications ra

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

Line 415: FROM ar_receivable_applications ra

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

Line 951: ar_receivable_applications_all ra

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

Line 982: p_entity => 'AR_RECEIVABLE_APPLICATIONS_ALL',

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

Line 1494: FROM AR_RECEIVABLE_APPLICATIONS

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