APPS.HZ_CLASSIFICATION_V2PUB dependencies on FND_LOOKUP_VALUES

Line 645: FROM fnd_lookup_values

641: )
642: THEN
643: SELECT lookup_code
644: INTO p_code_assignment_rec.class_code
645: FROM fnd_lookup_values
646: WHERE replace(lookup_code, '.', '') = replace(p_code_assignment_rec.class_code, '.', '')
647: AND lookup_type='NACE'
648: AND rownum = 1;
649: END IF;

Line 995: FROM fnd_lookup_values

991: )
992: THEN
993: SELECT lookup_code
994: INTO p_code_assignment_rec.class_code
995: FROM fnd_lookup_values
996: WHERE replace(lookup_code, '.', '') = replace(nvl(p_code_assignment_rec.class_code,l_class_code), '.', '')
997: AND lookup_type='NACE'
998: AND rownum = 1;
999: END IF;

Line 3548: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.insert_row. It also

3544: /**
3545: * PROCEDURE create_class_code
3546: *
3547: * DESCRIPTION
3548: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.insert_row. It also
3549: * updates frozen flag and validate class code meaning.
3550: *
3551: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3552: *

Line 3636: Fnd_Lookup_Values_Pkg.Insert_Row(

3632: RAISE FND_API.G_EXC_ERROR;
3633:
3634: end if;
3635:
3636: Fnd_Lookup_Values_Pkg.Insert_Row(
3637: X_ROWID => row_id,
3638: X_LOOKUP_TYPE => l_class_code_rec.type,
3639: X_SECURITY_GROUP_ID => 0,
3640: X_VIEW_APPLICATION_ID => 222,

Line 3720: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.update_row. It also

3716: /**
3717: * PROCEDURE update_class_code
3718: *
3719: * DESCRIPTION
3720: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.update_row. It also
3721: * updates frozen flag and validate class code meaning.
3722: *
3723: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3724: *

Line 3770: FROM fnd_lookup_values_vl val

3766: END IF;
3767:
3768: --Bug fix 2783498
3769: SELECT start_date_active,end_date_active into l_start_date_active,l_end_date_active
3770: FROM fnd_lookup_values_vl val
3771: WHERE val.lookup_type = l_class_code_rec.type
3772: AND val.lookup_code = l_class_code_rec.code
3773: AND rownum = 1
3774: FOR UPDATE OF LOOKUP_CODE NOWAIT;

Line 3802: Fnd_Lookup_Values_Pkg.Update_Row(

3798: RAISE FND_API.G_EXC_ERROR;
3799: end if;
3800: end if;
3801:
3802: Fnd_Lookup_Values_Pkg.Update_Row(
3803: X_LOOKUP_TYPE => l_class_code_rec.type,
3804: X_SECURITY_GROUP_ID => 0,
3805: X_VIEW_APPLICATION_ID => 222,
3806: X_LOOKUP_CODE => l_class_code_rec.code,

Line 3914: FROM FND_LOOKUP_VALUES

3910: DESCRIPTION,
3911: START_DATE_ACTIVE,
3912: END_DATE_ACTIVE,
3913: ENABLED_FLAG
3914: FROM FND_LOOKUP_VALUES
3915: WHERE LOOKUP_TYPE = p_class_category;
3916:
3917: --Create cursor for class code relations
3918: CURSOR C_codes_rel_cursor