13: select rowid
14: from igw_org_maps_all
15: where map_id = p_map_id;
16:
17: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
18: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
19: l_last_update_date DATE := SYSDATE;
20: begin
21:
14: from igw_org_maps_all
15: where map_id = p_map_id;
16:
17: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
18: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
19: l_last_update_date DATE := SYSDATE;
20: begin
21:
22: insert into igw_org_maps_all(
101: ,p_description VARCHAR2
102: ,p_start_date_active DATE
103: ,p_end_date_active DATE) is
104:
105: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
106: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
107: l_last_update_date DATE := SYSDATE;
108: begin
109:
102: ,p_start_date_active DATE
103: ,p_end_date_active DATE) is
104:
105: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
106: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
107: l_last_update_date DATE := SYSDATE;
108: begin
109:
110: update igw_org_maps_all