eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_APPR_HIST_PKG dependencies on FND_API

Line 86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

82: approver_type,
83: custom_setup_id,
84: log_message
85: ) VALUES (
86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),

83: custom_setup_id,
84: log_message
85: ) VALUES (
86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),

84: log_message
85: ) VALUES (
86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),

85: ) VALUES (
86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

86: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),

Line 91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

87: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),

Line 92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),

Line 93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

89: DECODE( p_object_version_num, FND_API.G_MISS_NUM, NULL, p_object_version_num),
90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),

Line 94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),

90: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),

Line 95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),

91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),

92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),

Line 97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),

93: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),

Line 98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),

94: DECODE( p_action_code, FND_API.g_miss_char, NULL, p_action_code),
95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),

Line 99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

95: DECODE( p_action_date, FND_API.G_MISS_DATE, NULL, p_action_date),
96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));

Line 100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),

96: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));
104:

Line 101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),

97: DECODE( p_approval_detail_id, FND_API.G_MISS_NUM, NULL, p_approval_detail_id),
98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));
104:
105: END Insert_Row;

Line 102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),

98: DECODE( p_note, FND_API.g_miss_char, NULL, p_note),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));
104:
105: END Insert_Row;
106:

Line 103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));

99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
100: DECODE( p_approval_type, FND_API.g_miss_char, NULL, p_approval_type),
101: DECODE( p_approver_type, FND_API.g_miss_char, NULL, p_approver_type),
102: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
103: DECODE( p_log_message, FND_API.g_miss_char, NULL, p_log_message));
104:
105: END Insert_Row;
106:
107:

Line 144: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 145: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 146: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),

Line 147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),

Line 148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),

Line 149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

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),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),

Line 150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),

146: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),

Line 151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),

147: object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num),
148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),

148: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),

Line 153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),

149: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),

Line 154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),

150: action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code),
151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),

Line 155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

151: action_date = DECODE( p_action_date, null, action_date, FND_API.G_MISS_DATE, null, p_action_date),
152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)

Line 156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),

152: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)
160: WHERE object_id = p_object_id

Line 157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),

153: approval_detail_id = DECODE( p_approval_detail_id, null, approval_detail_id, FND_API.G_MISS_NUM, null, p_approval_detail_id),
154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)
160: WHERE object_id = p_object_id
161: AND object_type_code = p_object_type_code

Line 158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),

154: note = DECODE( p_note, null, note, FND_API.g_miss_char, null, p_note),
155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)
160: WHERE object_id = p_object_id
161: AND object_type_code = p_object_type_code
162: AND approval_type = p_approval_type

Line 159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)

155: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
156: approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type),
157: approver_type = DECODE( p_approver_type, null, approver_type, FND_API.g_miss_char, null, p_approver_type),
158: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
159: log_message = DECODE( p_log_message, null, log_message, FND_API.g_miss_char, null, p_log_message)
160: WHERE object_id = p_object_id
161: AND object_type_code = p_object_type_code
162: AND approval_type = p_approval_type
163: AND sequence_num = p_sequence_num;

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: AND sequence_num = p_sequence_num;
164:
165: /*
166: IF (SQL%NOTFOUND) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169: */
170:
171:

Line 199: WHERE object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id)

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)

Line 200: AND object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code)

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)
204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);

Line 201: AND approval_type = DECODE( p_approval_type, null, approval_type, FND_API.g_miss_char, null, p_approval_type)

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)
204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);
205:

Line 202: AND sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num)

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)
204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);
205:
206: -- Do not need it as 'Open' rows will not exist in case of 1 approver

Line 203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)
204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);
205:
206: -- Do not need it as 'Open' rows will not exist in case of 1 approver
207: -- and it is not possible to check for existence of these rows before

Line 204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);

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)
203: AND object_version_num = DECODE( p_object_version_num, null, object_version_num, FND_API.G_MISS_NUM, null, p_object_version_num)
204: AND action_code = DECODE( p_action_code, null, action_code, FND_API.g_miss_char, null, p_action_code);
205:
206: -- Do not need it as 'Open' rows will not exist in case of 1 approver
207: -- and it is not possible to check for existence of these rows before
208: -- deleting them

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: -- deleting them
209: -- Also 11.5.9 upgrade customers will get errors
210: /*
211: If (SQL%NOTFOUND) then
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: End If;
214: */
215: END Delete_Row ;
216: