APPS.IGW_ORG_MAPS_ALL_PKG dependencies on IGW_ORG_MAPS_ALL

Line 1: PACKAGE BODY IGW_ORG_MAPS_ALL_PKG as

1: PACKAGE BODY IGW_ORG_MAPS_ALL_PKG as
2: --$Header: igwstmpb.pls 115.4 2002/11/14 18:47:47 vmedikon ship $
3:
4: procedure insert_row (
5: x_rowid IN OUT NOCOPY VARCHAR2

Line 14: from igw_org_maps_all

10: ,p_end_date_active DATE) is
11:
12: cursor c is
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;

Line 22: insert into igw_org_maps_all(

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(
23: map_id
24: ,organization_id
25: ,description
26: ,start_date_active

Line 65: from igw_org_maps_all

61: ,p_end_date_active DATE) is
62:
63: cursor c is
64: select *
65: from igw_org_maps_all
66: where rowid = x_rowid
67: for update of map_id nowait;
68:
69: tlinfo c%rowtype;

Line 110: update igw_org_maps_all

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
111: set organization_id = p_organization_id
112: , description = p_description
113: , start_date_active = p_start_date_active
114: , end_date_active = p_end_date_active

Line 129: delete from igw_org_maps_all

125:
126: procedure delete_row (x_rowid VARCHAR2) is
127: begin
128:
129: delete from igw_org_maps_all
130: where rowid = x_rowid;
131: if (sql%notfound) then
132: raise no_data_found;
133: end if;

Line 137: END IGW_ORG_MAPS_ALL_PKG;

133: end if;
134:
135: end delete_row;
136:
137: END IGW_ORG_MAPS_ALL_PKG;