APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_DELIVERY_CHANNELS_VL

Line 1519: FROM IBY_DELIVERY_CHANNELS_VL ibydlv

1515:
1516: CURSOR dlv_channels_csr(p_dlv_channel_code VARCHAR2)
1517: IS
1518: SELECT COUNT(delivery_channel_code)
1519: FROM IBY_DELIVERY_CHANNELS_VL ibydlv
1520: WHERE ibydlv.delivery_channel_code = p_dlv_channel_code
1521: AND (ibydlv.inactive_date is NULL OR ibydlv.inactive_date >= trunc(sysdate));
1522:
1523: CURSOR payment_formats_csr(p_payment_format_code VARCHAR2)

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

1662: print_debuginfo(l_module_name, 'Validate Delivery Channel Code');
1663: print_debuginfo(l_module_name, 'Delivery Channel Code::'||p_ext_payee_rec.Delivery_Channel);
1664: END IF;
1665:
1666: -- 6. Validate Delivery Channel Code (table: IBY_DELIVERY_CHANNELS_VL by country)
1667: -- is not mandatory
1668: IF (p_ext_payee_rec.Delivery_Channel IS NOT NULL) THEN
1669: OPEN dlv_channels_csr(p_ext_payee_rec.Delivery_Channel);
1670: FETCH dlv_channels_csr INTO l_count;

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

1674: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1675: print_debuginfo(l_module_name, 'InValid Delivery Channel');
1676: END IF;
1677: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1678: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_DELIVERY_CHANNELS_VL');
1679: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Delivery_Channel);
1680: FND_MSG_PUB.Add;
1681: l_valid := FALSE;
1682: END IF;