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 983: FROM fnd_lookup_values

979: )
980: THEN
981: SELECT lookup_code
982: INTO p_code_assignment_rec.class_code
983: FROM fnd_lookup_values
984: WHERE replace(lookup_code, '.', '') = replace(nvl(p_code_assignment_rec.class_code,l_class_code), '.', '')
985: AND lookup_type='NACE'
986: AND rownum = 1;
987: END IF;

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

3518: /**
3519: * PROCEDURE create_class_code
3520: *
3521: * DESCRIPTION
3522: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.insert_row. It also
3523: * updates frozen flag and validate class code meaning.
3524: *
3525: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3526: *

Line 3610: Fnd_Lookup_Values_Pkg.Insert_Row(

3606: RAISE FND_API.G_EXC_ERROR;
3607:
3608: end if;
3609:
3610: Fnd_Lookup_Values_Pkg.Insert_Row(
3611: X_ROWID => row_id,
3612: X_LOOKUP_TYPE => l_class_code_rec.type,
3613: X_SECURITY_GROUP_ID => 0,
3614: X_VIEW_APPLICATION_ID => 222,

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

3690: /**
3691: * PROCEDURE update_class_code
3692: *
3693: * DESCRIPTION
3694: * This is a wrapper on top of FND_LOOKUP_VALUES_PKG.update_row. It also
3695: * updates frozen flag and validate class code meaning.
3696: *
3697: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3698: *

Line 3744: FROM fnd_lookup_values_vl val

3740: END IF;
3741:
3742: --Bug fix 2783498
3743: SELECT start_date_active,end_date_active into l_start_date_active,l_end_date_active
3744: FROM fnd_lookup_values_vl val
3745: WHERE val.lookup_type = l_class_code_rec.type
3746: AND val.lookup_code = l_class_code_rec.code
3747: AND rownum = 1
3748: FOR UPDATE OF LOOKUP_CODE NOWAIT;

Line 3776: Fnd_Lookup_Values_Pkg.Update_Row(

3772: RAISE FND_API.G_EXC_ERROR;
3773: end if;
3774: end if;
3775:
3776: Fnd_Lookup_Values_Pkg.Update_Row(
3777: X_LOOKUP_TYPE => l_class_code_rec.type,
3778: X_SECURITY_GROUP_ID => 0,
3779: X_VIEW_APPLICATION_ID => 222,
3780: X_LOOKUP_CODE => l_class_code_rec.code,

Line 3888: FROM FND_LOOKUP_VALUES

3884: DESCRIPTION,
3885: START_DATE_ACTIVE,
3886: END_DATE_ACTIVE,
3887: ENABLED_FLAG
3888: FROM FND_LOOKUP_VALUES
3889: WHERE LOOKUP_TYPE = p_class_category;
3890:
3891: --Create cursor for class code relations
3892: CURSOR C_codes_rel_cursor