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 207: elsif p_object_id = FND_API.G_MISS_NUM then

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;

Line 216: elsif p_object_type_code = FND_API.g_miss_char then

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;

Line 225: elsif p_approval_type = FND_API.g_miss_char then

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;

Line 234: elsif p_sequence_num = FND_API.G_MISS_NUM then

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;

Line 243: elsif p_object_version_num = FND_API.G_MISS_NUM then

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;

Line 252: elsif p_action_code = FND_API.g_miss_char then

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;