APPS.CSI_GENERIC_GRP dependencies on CSI_LOOKUPS

Line 393: FROM csi_lookups

389: THEN
390: BEGIN
391: SELECT 'x'
392: INTO l_dummy
393: FROM csi_lookups
394: WHERE lookup_type = l_ext_lookup_type
395: AND lookup_code = p_ext_attrib_rec.attribute_level;
396: IF p_ext_attrib_rec.attribute_level = 'GLOBAL'
397: THEN

Line 529: END;--End for csi_lookups

525: fnd_message.set_name('CSI', 'CSI_INVALID_AL_PARAMETER');
526: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.attribute_level);
527: fnd_msg_pub.add;
528: x_return_status := fnd_api.g_ret_sts_error;
529: END;--End for csi_lookups
530: ELSE -- Else if p_ext_attrib_rec.attribute_level IS NULL
531: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');
532: fnd_message.set_token('PARAMETER','ATTRIBUTE_LEVEL');
533: fnd_msg_pub.add;

Line 567: FROM csi_lookups

563: IF ( (p_attribute_code IS NOT NULL) AND (p_attribute_code<>fnd_api.g_miss_char) ) THEN
564: BEGIN
565: SELECT 'x'
566: INTO l_dummy
567: FROM csi_lookups
568: WHERE lookup_type=l_attrib_lookup_type
569: AND lookup_code=p_attribute_code;
570: EXCEPTION
571: WHEN NO_DATA_FOUND THEN

Line 609: FROM csi_lookups

605: IF ( (p_attribute_category IS NOT NULL) AND (p_attribute_category<>fnd_api.g_miss_char) ) THEN
606: BEGIN
607: SELECT 'x'
608: INTO l_dummy
609: FROM csi_lookups
610: WHERE lookup_type= l_cat_lookup_type
611: AND lookup_code=p_attribute_category;
612: EXCEPTION
613: WHEN NO_DATA_FOUND THEN