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 198: DELETE FROM ams_approval_history

194: p_object_version_num NUMBER,
195: p_approval_type VARCHAR2)
196: IS
197: BEGIN
198: DELETE FROM ams_approval_history
199: WHERE object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id)
200: AND object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code)
201: AND approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type)
202: AND sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num)