APPS.AK_UNIQUE_KEY_COLUMNS_PKG dependencies on AK_UNIQUE_KEY_COLUMNS

Line 1: PACKAGE BODY AK_UNIQUE_KEY_COLUMNS_PKG as

1: PACKAGE BODY AK_UNIQUE_KEY_COLUMNS_PKG as
2: /* $Header: AKDUKCB.pls 115.5 2002/01/17 12:31:12 pkm ship $ */
3: --######################################################################
4: procedure INSERT_ROW (
5: X_UNIQUE_KEY_NAME in VARCHAR2,

Line 32: insert into AK_UNIQUE_KEY_COLUMNS (

28: X_ATTRIBUTE14 in VARCHAR2,
29: X_ATTRIBUTE15 in VARCHAR2)
30: is
31: begin
32: insert into AK_UNIQUE_KEY_COLUMNS (
33: UNIQUE_KEY_NAME,
34: UNIQUE_KEY_SEQUENCE,
35: ATTRIBUTE_APPLICATION_ID,
36: ATTRIBUTE_CODE,

Line 130: from AK_UNIQUE_KEY_COLUMNS

126: ATTRIBUTE12,
127: ATTRIBUTE13,
128: ATTRIBUTE14,
129: ATTRIBUTE15
130: from AK_UNIQUE_KEY_COLUMNS
131: where UNIQUE_KEY_NAME = X_UNIQUE_KEY_NAME
132: and UNIQUE_KEY_SEQUENCE = X_UNIQUE_KEY_SEQUENCE
133: for update of UNIQUE_KEY_NAME nowait;
134: recinfo c%rowtype;

Line 232: update AK_UNIQUE_KEY_COLUMNS set

228: X_ATTRIBUTE14 in VARCHAR2,
229: X_ATTRIBUTE15 in VARCHAR2
230: ) is
231: begin
232: update AK_UNIQUE_KEY_COLUMNS set
233: UNIQUE_KEY_NAME = X_UNIQUE_KEY_NAME,
234: UNIQUE_KEY_SEQUENCE = X_UNIQUE_KEY_SEQUENCE,
235: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
236: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,

Line 272: delete from AK_UNIQUE_KEY_COLUMNS

268: X_UNIQUE_KEY_SEQUENCE in NUMBER,
269: X_ATTRIBUTE_APPLICATION_ID in NUMBER,
270: X_ATTRIBUTE_CODE in VARCHAR2) is
271: begin
272: delete from AK_UNIQUE_KEY_COLUMNS
273: where UNIQUE_KEY_NAME = X_UNIQUE_KEY_NAME
274: and UNIQUE_KEY_SEQUENCE = X_UNIQUE_KEY_SEQUENCE;
275: if (sql%notfound) then
276: raise no_data_found;

Line 280: end AK_UNIQUE_KEY_COLUMNS_PKG;

276: raise no_data_found;
277: end if;
278: end DELETE_ROW;
279: --######################################################################
280: end AK_UNIQUE_KEY_COLUMNS_PKG;