APPS.AHL_UNIT_THRESHOLDS_PKG dependencies on AHL_UNIT_THRESHOLDS

Line 1: PACKAGE BODY AHL_UNIT_THRESHOLDS_PKG AS

1: PACKAGE BODY AHL_UNIT_THRESHOLDS_PKG AS
2: /* $Header: AHLLUMTB.pls 115.3 2003/07/25 21:28:23 sikumar noship $ */
3: -- ARCS header version
4: G_PKG_NAME VARCHAR2(30) := 'AHL_UNIT_THRESHOLDS_PKG';
5:

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_UNIT_THRESHOLDS_PKG';

1: PACKAGE BODY AHL_UNIT_THRESHOLDS_PKG AS
2: /* $Header: AHLLUMTB.pls 115.3 2003/07/25 21:28:23 sikumar noship $ */
3: -- ARCS header version
4: G_PKG_NAME VARCHAR2(30) := 'AHL_UNIT_THRESHOLDS_PKG';
5:
6: PROCEDURE insert_row (
7: P_X_UNIT_THRESHOLD_ID IN OUT NOCOPY NUMBER,
8: P_UNIT_DEFERRAL_ID IN NUMBER,

Line 37: insert into ahl_unit_thresholds(

33: P_LAST_UPDATE_LOGIN IN NUMBER
34: ) IS
35:
36: BEGIN
37: insert into ahl_unit_thresholds(
38: UNIT_THRESHOLD_ID,
39: UNIT_DEFERRAL_ID,
40: COUNTER_ID,
41: COUNTER_VALUE,

Line 66: AHL_UNIT_THRESHOLDS_S.NEXTVAL,

62: CREATION_DATE,
63: CREATED_BY,
64: LAST_UPDATE_LOGIN
65: ) values (
66: AHL_UNIT_THRESHOLDS_S.NEXTVAL,
67: P_UNIT_DEFERRAL_ID,
68: P_COUNTER_ID,
69: P_COUNTER_VALUE,
70: P_CTR_VALUE_TYPE_CODE,

Line 128: update ahl_unit_thresholds set

124: P_LAST_UPDATE_LOGIN IN NUMBER
125: ) IS
126:
127: BEGIN
128: update ahl_unit_thresholds set
129: UNIT_DEFERRAL_ID = P_UNIT_DEFERRAL_ID,
130: COUNTER_ID = P_COUNTER_ID,
131: COUNTER_VALUE = P_COUNTER_VALUE,
132: CTR_VALUE_TYPE_CODE = P_CTR_VALUE_TYPE_CODE,

Line 168: delete from ahl_unit_thresholds

164: P_UNIT_THRESHOLD_ID IN NUMBER
165: ) IS
166: BEGIN
167:
168: delete from ahl_unit_thresholds
169: where UNIT_THRESHOLD_ID = P_UNIT_THRESHOLD_ID;
170:
171: if (sql%notfound) then
172: raise no_data_found;

Line 179: END AHL_UNIT_THRESHOLDS_PKG;

175: END delete_row;
176:
177: ------------------------------
178:
179: END AHL_UNIT_THRESHOLDS_PKG;
180: