APPS.AHL_APPROVAL_API_PKG dependencies on AHL_APPROVAL_API

Line 1: PACKAGE BODY AHL_APPROVAL_API_PKG as

1: PACKAGE BODY AHL_APPROVAL_API_PKG as
2: /* $Header: AHLLAPIB.pls 115.2 2002/12/04 00:03:53 ssurapan noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_APPROVAL_API_ID in NUMBER,

Line 19: cursor C is select ROWID from AHL_APPROVAL_API

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from AHL_APPROVAL_API
20: where APPROVAL_API_ID = X_APPROVAL_API_ID
21: ;
22: begin
23: insert into ahl_approval_api (

Line 23: insert into ahl_approval_api (

19: cursor C is select ROWID from AHL_APPROVAL_API
20: where APPROVAL_API_ID = X_APPROVAL_API_ID
21: ;
22: begin
23: insert into ahl_approval_api (
24: APPROVAL_API_ID,
25: OBJECT_VERSION_NUMBER,
26: API_USED_BY,
27: APPROVAL_OBJECT_TYPE,

Line 78: update AHL_APPROVAL_API set

74: X_LAST_UPDATED_BY in NUMBER,
75: X_LAST_UPDATE_LOGIN in NUMBER
76: ) is
77: begin
78: update AHL_APPROVAL_API set
79: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
80: API_USED_BY = X_API_USED_BY,
81: APPROVAL_OBJECT_TYPE = X_APPROVAL_OBJECT_TYPE,
82: APPROVAL_TYPE = X_APPROVAL_TYPE,

Line 103: delete from AHL_APPROVAL_API

99: X_APPROVAL_API_ID in NUMBER
100: )
101: is
102: begin
103: delete from AHL_APPROVAL_API
104: where APPROVAL_API_ID = X_APPROVAL_API_ID;
105:
106: if (sql%notfound) then
107: raise no_data_found;

Line 131: from AHL_APPROVAL_API

127: l_api_id number;
128:
129: cursor c_obj_verno is
130: select object_version_number
131: from AHL_APPROVAL_API
132: where approval_api_id = X_APPROVAL_API_ID;
133:
134: cursor c_chk_api_exists is
135: select 'x'

Line 136: from AHL_APPROVAL_API

132: where approval_api_id = X_APPROVAL_API_ID;
133:
134: cursor c_chk_api_exists is
135: select 'x'
136: from AHL_APPROVAL_API
137: where approval_api_id = X_APPROVAL_API_ID;
138:
139: cursor c_get_api_id is
140: select ahl_approval_api_s.nextval

Line 140: select ahl_approval_api_s.nextval

136: from AHL_APPROVAL_API
137: where approval_api_id = X_APPROVAL_API_ID;
138:
139: cursor c_get_api_id is
140: select ahl_approval_api_s.nextval
141: from dual;
142:
143:
144: BEGIN

Line 166: AHL_APPROVAL_API_PKG.INSERT_ROW (

162: end if ;
163:
164: l_obj_verno := 1;
165:
166: AHL_APPROVAL_API_PKG.INSERT_ROW (
167: X_ROWID => l_row_id,
168: X_APPROVAL_API_ID => l_api_id,
169: X_OBJECT_VERSION_NUMBER => l_obj_verno,
170: X_API_USED_BY => X_API_USED_BY ,

Line 192: AHL_APPROVAL_API_PKG.UPDATE_ROW (

188: close c_obj_verno;
189:
190:
191:
192: AHL_APPROVAL_API_PKG.UPDATE_ROW (
193: X_APPROVAL_API_ID => X_APPROVAL_API_ID,
194: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
195: X_API_USED_BY => X_API_USED_BY ,
196: X_APPROVAL_OBJECT_TYPE => X_APPROVAL_OBJECT_TYPE ,

Line 212: end AHL_APPROVAL_API_PKG;

208:
209: END LOAD_ROW ;
210:
211:
212: end AHL_APPROVAL_API_PKG;