DBA Data[Home] [Help]

APPS.EGO_AG_BULKLOAD_PVT dependencies on FND_LOOKUP_VALUES

Line 2790: FROM fnd_lookup_values

2786: /*Set the defaulting when defaulting name is given*/
2787:
2788: UPDATE ego_attr_groups_dl_interface eagdl
2789: SET eagdl.defaulting = (SELECT lookup_code
2790: FROM fnd_lookup_values
2791: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
2792: AND meaning = eagdl.defaulting_name
2793: AND language = Userenv('LANG')),
2794: last_updated_by = G_USER_ID,

Line 2811: FROM fnd_lookup_values

2807:
2808: /*Set the defaulting name when defaulting is given*/
2809: UPDATE ego_attr_groups_dl_interface eagdl
2810: SET eagdl.defaulting_name = (SELECT meaning
2811: FROM fnd_lookup_values
2812: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
2813: AND lookup_code = eagdl.defaulting
2814: AND language = Userenv('LANG')),
2815: last_updated_by = G_USER_ID,

Line 5611: FROM fnd_lookup_values

5607: AND P_agdl_tbl(i).transaction_type <> G_OPR_DELETE) THEN
5608: BEGIN
5609: SELECT meaning
5610: INTO P_agdl_tbl(i).defaulting_name
5611: FROM fnd_lookup_values
5612: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
5613: AND lookup_code = P_agdl_tbl(i).defaulting
5614: AND language = Userenv('LANG');
5615: EXCEPTION

Line 5652: FROM fnd_lookup_values

5648: and P_agdl_tbl(i).transaction_type <> G_OPR_DELETE) THEN
5649: BEGIN
5650: SELECT lookup_code
5651: INTO P_agdl_tbl(i).defaulting_name
5652: FROM fnd_lookup_values
5653: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
5654: AND meaning = P_agdl_tbl(i).defaulting_name
5655: AND language = Userenv('LANG');
5656: EXCEPTION