APPS.AMS_APPR_HIST_PKG dependencies on AMS_APPROVAL_HISTORY

Line 66: INSERT INTO ams_approval_history(

62: BEGIN
63:
64:
65:
66: INSERT INTO ams_approval_history(
67: object_id,
68: object_type_code,
69: sequence_num,
70: object_version_num,

Line 142: Update ams_approval_history

138: p_log_message VARCHAR2)
139:
140: IS
141: BEGIN
142: Update ams_approval_history
143: SET
144: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
145: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
146: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),

Line 202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');

198: l_lines_sql VARCHAR2(10000) := NULL;
199: l_ignore NUMBER;
200: BEGIN
201: FND_DSQL.init;
202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');
203:
204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');
206: FND_DSQL.add_bind(p_object_id);