DBA Data[Home] [Help]

APPS.CSI_GIS_INSTANCE_GEO_LOC_PVT dependencies on FND_GLOBAL

Line 54: FND_GLOBAL.user_id,

50: p_inst_latitude,
51: p_inst_longitude,
52: 'Y',
53: SYSDATE,
54: FND_GLOBAL.user_id,
55: FND_GLOBAL.user_id,
56: FND_GLOBAL.login_id,
57: SYSDATE
58: );

Line 55: FND_GLOBAL.user_id,

51: p_inst_longitude,
52: 'Y',
53: SYSDATE,
54: FND_GLOBAL.user_id,
55: FND_GLOBAL.user_id,
56: FND_GLOBAL.login_id,
57: SYSDATE
58: );
59:

Line 56: FND_GLOBAL.login_id,

52: 'Y',
53: SYSDATE,
54: FND_GLOBAL.user_id,
55: FND_GLOBAL.user_id,
56: FND_GLOBAL.login_id,
57: SYSDATE
58: );
59:
60: EXCEPTION

Line 87: LAST_UPDATED_BY = FND_GLOBAL.user_id,

83:
84: UPDATE CSI_II_GEOLOCATIONS
85: SET
86: VALID_FLAG = p_valid_flag,
87: LAST_UPDATED_BY = FND_GLOBAL.user_id,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
89: LAST_UPDATE_DATE = SYSDATE
90:
91: WHERE

Line 88: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

84: UPDATE CSI_II_GEOLOCATIONS
85: SET
86: VALID_FLAG = p_valid_flag,
87: LAST_UPDATED_BY = FND_GLOBAL.user_id,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
89: LAST_UPDATE_DATE = SYSDATE
90:
91: WHERE
92: INSTANCE_ID = p_instance_id;

Line 99: LAST_UPDATED_BY = FND_GLOBAL.user_id,

95: SET
96: INST_LATITUDE = p_inst_latitude,
97: INST_LONGITUDE = p_inst_longitude,
98: VALID_FLAG = NVL(p_valid_flag,'Y'),
99: LAST_UPDATED_BY = FND_GLOBAL.user_id,
100: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
101: LAST_UPDATE_DATE = SYSDATE
102:
103: WHERE

Line 100: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

96: INST_LATITUDE = p_inst_latitude,
97: INST_LONGITUDE = p_inst_longitude,
98: VALID_FLAG = NVL(p_valid_flag,'Y'),
99: LAST_UPDATED_BY = FND_GLOBAL.user_id,
100: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
101: LAST_UPDATE_DATE = SYSDATE
102:
103: WHERE
104: INSTANCE_ID = p_instance_id;