DBA Data[Home] [Help]

APPS.VEA_TPA_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 3374: p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,

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

Line 3375: p_new_lookup_code IN fnd_lookup_values.lookup_code%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: )

Line 3376: p_current_lookup_code IN fnd_lookup_values.lookup_code%TYPE,

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

Line 3377: p_meaning IN fnd_lookup_values.meaning%TYPE,

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: --{

Line 3378: p_description IN fnd_lookup_values.description%TYPE

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';

Line 3391: UPDATE fnd_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

Line 3409: p_lookup_type IN fnd_lookup_values.lookup_type%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: )

Line 3410: p_lookup_code IN fnd_lookup_values.lookup_code%TYPE,

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

Line 3411: p_meaning IN fnd_lookup_values.meaning%TYPE,

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: --{

Line 3412: p_description IN fnd_lookup_values.description%TYPE

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';

Line 3425: FND_LOOKUP_VALUES_PKG.INSERT_ROW

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,