APPS.AHL_UNIT_ACCOMPLISH_PKG dependencies on AHL_UNIT_ACCOMPLISHMNTS

Line 37: insert into ahl_unit_accomplishmnts(

33: P_LAST_UPDATE_LOGIN IN NUMBER
34: ) IS
35:
36: BEGIN
37: insert into ahl_unit_accomplishmnts(
38: UNIT_ACCOMPLISHMNT_ID,
39: UNIT_EFFECTIVITY_ID,
40: COUNTER_ID,
41: COUNTER_VALUE,

Line 65: AHL_UNIT_ACCOMPLISHMNTS_S.NEXTVAL,

61: CREATION_DATE,
62: CREATED_BY,
63: LAST_UPDATE_LOGIN
64: ) values (
65: AHL_UNIT_ACCOMPLISHMNTS_S.NEXTVAL,
66: P_UNIT_EFFECTIVITY_ID,
67: P_COUNTER_ID,
68: P_COUNTER_VALUE,
69: P_ATTRIBUTE_CATEGORY,

Line 125: update ahl_unit_accomplishmnts set

121: P_LAST_UPDATE_LOGIN IN NUMBER
122: ) IS
123:
124: BEGIN
125: update ahl_unit_accomplishmnts set
126: UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID,
127: COUNTER_ID = P_COUNTER_ID,
128: COUNTER_VALUE = P_COUNTER_VALUE,
129: ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,

Line 164: delete from ahl_unit_accomplishmnts

160: P_UNIT_ACCOMPLISHMNT_ID IN NUMBER
161: ) IS
162: BEGIN
163:
164: delete from ahl_unit_accomplishmnts
165: where UNIT_ACCOMPLISHMNT_ID = P_UNIT_ACCOMPLISHMNT_ID;
166:
167: if (sql%notfound) then
168: raise no_data_found;