DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

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 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;