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: );
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:
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
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
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;
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
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;