APPS.AME_STRING_VALUES_API dependencies on AME_STRING_VALUES

Line 1: PACKAGE BODY AME_STRING_VALUES_API AS

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

Line 27: from AME_STRING_VALUES

23: X_CONDITION_ID in NUMBER,
24: X_STRING_VALUE in VARCHAR2
25: ) is
26: select COUNT(*)
27: from AME_STRING_VALUES
28: where CONDITION_ID = X_CONDITION_ID
29: and STRING_VALUE = X_STRING_VALUE;
30: begin
31: if X_CONDITION_ID is not null then

Line 52: insert into AME_STRING_VALUES

48: is
49:
50: begin
51:
52: insert into AME_STRING_VALUES
53: (
54: CONDITION_ID,
55: STRING_VALUE,
56: CREATED_BY,

Line 82: delete from AME_STRING_VALUES

78: procedure DELETE_ROW (
79: X_CONDITION_ID in NUMBER
80: ) is
81: begin
82: delete from AME_STRING_VALUES
83: where CONDITION_ID = X_CONDITION_ID;
84:
85: if (sql%notfound) then
86: raise no_data_found;

Line 136: ame_util.runtimeException('ame_string_values_api',

132: end if;
133: end if;
134: exception
135: when others then
136: ame_util.runtimeException('ame_string_values_api',
137: 'load_row',
138: sqlcode,
139: sqlerrm);
140: raise;

Line 143: END AME_STRING_VALUES_API;

139: sqlerrm);
140: raise;
141: end LOAD_ROW;
142: --
143: END AME_STRING_VALUES_API;