APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_DELIVERY_CHANNELS_VL

Line 1259: FROM IBY_DELIVERY_CHANNELS_VL ibydlv

1255: CURSOR dlv_channels_csr(p_dlv_channel_code VARCHAR2,
1256: p_payer_country VARCHAR2)
1257: IS
1258: SELECT COUNT(delivery_channel_code)
1259: FROM IBY_DELIVERY_CHANNELS_VL ibydlv
1260: WHERE ibydlv.delivery_channel_code = p_dlv_channel_code
1261: AND (ibydlv.territory_code = p_payer_country OR ibydlv.territory_code is NULL)
1262: AND (ibydlv.inactive_date is NULL OR ibydlv.inactive_date >= trunc(sysdate));
1263:

Line 1369: -- 6. Validate Delivery Channel Code (table: IBY_DELIVERY_CHANNELS_VL by country)

1365: l_valid := FALSE;
1366: END IF;
1367: END IF;
1368:
1369: -- 6. Validate Delivery Channel Code (table: IBY_DELIVERY_CHANNELS_VL by country)
1370: -- is not mandatory
1371: IF (p_ext_payee_rec.Delivery_Channel IS NOT NULL) THEN
1372: OPEN dlv_channels_csr(p_ext_payee_rec.Delivery_Channel,l_payee_country);
1373: FETCH dlv_channels_csr INTO l_count;

Line 1378: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_DELIVERY_CHANNELS_VL');

1374: CLOSE dlv_channels_csr;
1375:
1376: IF (l_count = 0) THEN
1377: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1378: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_DELIVERY_CHANNELS_VL');
1379: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Delivery_Channel);
1380: FND_MSG_PUB.Add;
1381: l_valid := FALSE;
1382: END IF;