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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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));
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:
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;
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:
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:
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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)
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
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
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
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;
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:
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);
207: elsif p_object_id = FND_API.G_MISS_NUM then
208: FND_DSQL.add_text(' AND object_id is null ');
209: else
210: Null;
211: end if;
212:
213: if p_object_type_code is not null then
214: FND_DSQL.add_text(' AND object_type_code = ');
215: FND_DSQL.add_bind(p_object_type_code);
216: elsif p_object_type_code = FND_API.g_miss_char then
217: FND_DSQL.add_text(' AND object_type_code is null');
218: else
219: Null;
220: end if;
221:
222: if p_approval_type is not null then
223: FND_DSQL.add_text(' AND approval_type = ');
224: FND_DSQL.add_bind(p_approval_type);
225: elsif p_approval_type = FND_API.g_miss_char then
226: FND_DSQL.add_text(' AND approval_type is null');
227: else
228: Null;
229: end if;
230:
231: if p_sequence_num is not null then
232: FND_DSQL.add_text(' AND sequence_num = ');
233: FND_DSQL.add_bind(p_sequence_num);
234: elsif p_sequence_num = FND_API.G_MISS_NUM then
235: FND_DSQL.add_text(' AND sequence_num is null');
236: else
237: Null;
238: end if;
239:
240: if p_object_version_num is not null then
241: FND_DSQL.add_text(' AND object_version_num = ');
242: FND_DSQL.add_bind(p_object_version_num);
243: elsif p_object_version_num = FND_API.G_MISS_NUM then
244: FND_DSQL.add_text(' AND object_version_num is null');
245: else
246: Null;
247: end if;
248:
249: if p_action_code is not null then
250: FND_DSQL.add_text(' AND action_code = ');
251: FND_DSQL.add_bind(p_action_code);
252: elsif p_action_code = FND_API.g_miss_char then
253: FND_DSQL.add_text(' AND action_code is null');
254: else
255: Null;
256: end if;