APPS.AME_STRING_VALUES_API2 dependencies on AME_STRING_VALUES

Line 1: PACKAGE BODY AME_STRING_VALUES_API2 AS

1: PACKAGE BODY AME_STRING_VALUES_API2 AS
2: /* $Header: amesaapi.pkb 120.1 2005/10/14 04:14 ubhat noship $ */
3:
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 36: from AME_STRING_VALUES

32: X_CONDITION_ID in NUMBER,
33: X_STRING_VALUE in VARCHAR2
34: ) is
35: select 'FOUND'
36: from AME_STRING_VALUES
37: where CONDITION_ID = X_CONDITION_ID
38: and STRING_VALUE = X_STRING_VALUE;
39: begin
40: open CSR_GET_CONDITION_ID (

Line 72: from AME_STRING_VALUES

68: X_CONDITION_ID in NUMBER,
69: X_STRING_VALUE in VARCHAR2
70: ) is
71: select COUNT(*)
72: from AME_STRING_VALUES
73: where CONDITION_ID = X_CONDITION_ID
74: and STRING_VALUE = X_STRING_VALUE;
75: begin
76: if X_CONDITION_ID is not null then

Line 97: insert into AME_STRING_VALUES

93: is
94:
95: begin
96:
97: insert into AME_STRING_VALUES
98: (
99: CONDITION_ID,
100: STRING_VALUE,
101: CREATED_BY,

Line 127: delete from AME_STRING_VALUES

123: procedure DELETE_ROW (
124: X_CONDITION_ID in NUMBER
125: ) is
126: begin
127: delete from AME_STRING_VALUES
128: where CONDITION_ID = X_CONDITION_ID;
129: if (sql%notfound) then
130: raise no_data_found;
131: end if;

Line 205: ame_util.runtimeException('ame_string_values_api2',

201: end if;
202: end if;
203: exception
204: when others then
205: ame_util.runtimeException('ame_string_values_api2',
206: 'load_row',
207: sqlcode,
208: sqlerrm);
209: raise;

Line 212: END AME_STRING_VALUES_API2;

208: sqlerrm);
209: raise;
210: end LOAD_ROW;
211: --
212: END AME_STRING_VALUES_API2;