APPS.RA_LL_RCV_GROUPS_PKG dependencies on AR_ACTIVITY_DETAILS

Line 11: DELETE AR_ACTIVITY_DETAILS

7: X_CASH_RECEIPT_ID IN NUMBER
8: ) IS
9: BEGIN
10:
11: DELETE AR_ACTIVITY_DETAILS
12: WHERE 1 = 1
13: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
14: AND GROUP_ID = X_GROUP_ID
15: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111

Line 201: Select ar_Activity_details_s.nextval

197: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
198: , 'plsql',
199: 'RA_LL_RCV_GROUPS_PKG.INSERT_ROW', 1);
200:
201: Select ar_Activity_details_s.nextval
202: INTO l_line_id
203: FROM DUAL;
204:
205: INSERT INTO AR_ACTIVITY_DETAILS (

Line 205: INSERT INTO AR_ACTIVITY_DETAILS (

201: Select ar_Activity_details_s.nextval
202: INTO l_line_id
203: FROM DUAL;
204:
205: INSERT INTO AR_ACTIVITY_DETAILS (
206: LINE_ID,
207: APPLY_TO,
208: customer_trx_line_id,
209: CASH_RECEIPT_ID,

Line 436: FROM AR_ACTIVITY_DETAILS

432: X_ATTRIBUTE13,
433: X_ATTRIBUTE12,
434: X_ATTRIBUTE11,
435: X_ATTRIBUTE10
436: FROM AR_ACTIVITY_DETAILS
437: WHERE 1 = 1 AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
438: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
439: AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
440: ;

Line 446: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_AR_ACTIVITY_DETAILS_rec');

442:
443: EXCEPTION
444: WHEN NO_DATA_FOUND THEN
445: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_API_NO_RECORD' );
446: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_AR_ACTIVITY_DETAILS_rec');
447: FND_MESSAGE.SET_TOKEN( 'VALUE', '' );
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: END Select_Row;