3370: --
3371: --
3372: PROCEDURE update_lookup_values
3373: (
3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3377: p_meaning IN fnd_lookup_values.meaning%TYPE,
3378: p_description IN fnd_lookup_values.description%TYPE
3371: --
3372: PROCEDURE update_lookup_values
3373: (
3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3377: p_meaning IN fnd_lookup_values.meaning%TYPE,
3378: p_description IN fnd_lookup_values.description%TYPE
3379: )
3372: PROCEDURE update_lookup_values
3373: (
3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3377: p_meaning IN fnd_lookup_values.meaning%TYPE,
3378: p_description IN fnd_lookup_values.description%TYPE
3379: )
3380: IS
3373: (
3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3377: p_meaning IN fnd_lookup_values.meaning%TYPE,
3378: p_description IN fnd_lookup_values.description%TYPE
3379: )
3380: IS
3381: --{
3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3377: p_meaning IN fnd_lookup_values.meaning%TYPE,
3378: p_description IN fnd_lookup_values.description%TYPE
3379: )
3380: IS
3381: --{
3382: l_api_name CONSTANT VARCHAR2(30) := 'update_lookup_values';
3387: --{
3388: l_location := '0010';
3389: --
3390: --
3391: UPDATE fnd_lookup_values
3392: SET lookup_code = p_new_lookup_code,
3393: meaning = p_meaning,
3394: description = p_description
3395: WHERE lookup_type = p_lookup_type
3405: --
3406: --
3407: PROCEDURE insert_lookup_values
3408: (
3409: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3410: p_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3411: p_meaning IN fnd_lookup_values.meaning%TYPE,
3412: p_description IN fnd_lookup_values.description%TYPE
3413: )
3406: --
3407: PROCEDURE insert_lookup_values
3408: (
3409: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3410: p_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3411: p_meaning IN fnd_lookup_values.meaning%TYPE,
3412: p_description IN fnd_lookup_values.description%TYPE
3413: )
3414: IS
3407: PROCEDURE insert_lookup_values
3408: (
3409: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3410: p_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3411: p_meaning IN fnd_lookup_values.meaning%TYPE,
3412: p_description IN fnd_lookup_values.description%TYPE
3413: )
3414: IS
3415: --{
3408: (
3409: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
3410: p_lookup_code IN fnd_lookup_values.lookup_code%TYPE,
3411: p_meaning IN fnd_lookup_values.meaning%TYPE,
3412: p_description IN fnd_lookup_values.description%TYPE
3413: )
3414: IS
3415: --{
3416: l_api_name CONSTANT VARCHAR2(30) := 'insert_lookup_values';
3421: --{
3422: l_location := '0010';
3423: --
3424: --
3425: FND_LOOKUP_VALUES_PKG.INSERT_ROW
3426: (
3427: x_rowid => l_row_id,
3428: x_lookup_type => p_lookup_type,
3429: x_security_group_id => FND_GLOBAL.SECURITY_GROUP_ID,