APPS.AME_FIELD_HELP_API dependencies on AME_FIELD_HELP

Line 1: PACKAGE BODY AME_FIELD_HELP_API AS

1: PACKAGE BODY AME_FIELD_HELP_API AS
2: /* $Header: amefhapi.pkb 120.0 2005/07/26 06:00:13 mbocutt noship $ */
3:
4: procedure GET_CURRENT_FIELD_HELP_ROW (
5: X_FIELD_NAME in VARCHAR2,

Line 18: from AME_FIELD_HELP

14: X_PROCEDURE_NAME in VARCHAR2,
15: X_PACKAGE_NAME in VARCHAR2
16: ) is
17: select ROWID
18: from AME_FIELD_HELP
19: where FIELD_NAME = X_FIELD_NAME
20: and PROCEDURE_NAME = X_PROCEDURE_NAME
21: and PACKAGE_NAME = X_PACKAGE_NAME;
22: begin

Line 44: insert into AME_FIELD_HELP

40: X_HELP_TEXT in VARCHAR2)
41: is
42:
43: begin
44: insert into AME_FIELD_HELP
45: (
46: FIELD_NAME,
47: PROCEDURE_NAME,
48: PACKAGE_NAME,

Line 64: update AME_FIELD_HELP set

60: X_FIELD_HELP_ROWID in VARCHAR2,
61: X_HELP_TEXT in VARCHAR2)
62: is
63: begin
64: update AME_FIELD_HELP set
65: HELP_TEXT = X_HELP_TEXT
66: where ROWID = X_FIELD_HELP_ROWID;
67: end UPDATE_ROW;
68:

Line 75: delete from AME_FIELD_HELP

71: X_PROCEDURE_NAME in VARCHAR2,
72: X_PACKAGE_NAME in VARCHAR2
73: ) is
74: begin
75: delete from AME_FIELD_HELP
76: where FIELD_NAME = X_FIELD_NAME
77: and PROCEDURE_NAME = X_PROCEDURE_NAME
78: and PACKAGE_NAME = X_PACKAGE_NAME;
79:

Line 119: ame_util.runtimeException('ame_field_help_api',

115: end if;
116: end;
117: exception
118: when others then
119: ame_util.runtimeException('ame_field_help_api',
120: 'load_row',
121: sqlcode,
122: sqlerrm);
123: raise;

Line 126: END AME_FIELD_HELP_API;

122: sqlerrm);
123: raise;
124: end LOAD_ROW;
125:
126: END AME_FIELD_HELP_API;