DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

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