DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 107: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN

103: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
104: FND_MSG_PUB.ADD;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END IF;
107: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
108: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
109: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
110: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
111: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');

Line 855: ar_cash_receipt_history_all crh,

851: p_type IN VARCHAR2)
852: IS
853: SELECT crh.cash_receipt_id
854: FROM ar_distributions_all ard,
855: ar_cash_receipt_history_all crh,
856: ar_cash_receipts_all cr
857: WHERE ard.source_table = 'CRH'
858: AND ard.source_id = crh.cash_receipt_history_id
859: AND crh.gl_date BETWEEN p_start_date AND p_end_date

Line 886: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',

882: (p_start_date => p_start_date,
883: p_end_date => p_end_date,
884: p_org_id => p_org_id,
885: p_type => p_type,
886: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',
887: x_return_status => x_return_status);
888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: RAISE fnd_api.g_exc_error;
890: END IF;