DBA Data[Home] [Help]

APPS.HZ_ADAPTERS_PKG dependencies on FND_API

Line 26: x_adapter_id <> fnd_api.g_miss_num

22:
23: BEGIN
24:
25: IF x_adapter_id IS NOT NULL AND
26: x_adapter_id <> fnd_api.g_miss_num
27: THEN
28: l_primary_key_passed := TRUE;
29: END IF;
30:

Line 53: DECODE(x_adapter_id, fnd_api.g_miss_num, hz_adapters_s.NEXTVAL,

49: created_by,
50: last_update_login,
51: object_version_number
52: ) VALUES (
53: DECODE(x_adapter_id, fnd_api.g_miss_num, hz_adapters_s.NEXTVAL,
54: NULL, hz_adapters_s.NEXTVAL, x_adapter_id),
55: DECODE(x_adapter_content_source,
56: fnd_api.g_miss_char, NULL, x_adapter_content_source),
57: DECODE(x_enabled_flag,

Line 56: fnd_api.g_miss_char, NULL, x_adapter_content_source),

52: ) VALUES (
53: DECODE(x_adapter_id, fnd_api.g_miss_num, hz_adapters_s.NEXTVAL,
54: NULL, hz_adapters_s.NEXTVAL, x_adapter_id),
55: DECODE(x_adapter_content_source,
56: fnd_api.g_miss_char, NULL, x_adapter_content_source),
57: DECODE(x_enabled_flag,
58: fnd_api.g_miss_char, NULL, x_enabled_flag),
59: DECODE(x_synchronous_flag,
60: fnd_api.g_miss_char, NULL, x_synchronous_flag),

Line 58: fnd_api.g_miss_char, NULL, x_enabled_flag),

54: NULL, hz_adapters_s.NEXTVAL, x_adapter_id),
55: DECODE(x_adapter_content_source,
56: fnd_api.g_miss_char, NULL, x_adapter_content_source),
57: DECODE(x_enabled_flag,
58: fnd_api.g_miss_char, NULL, x_enabled_flag),
59: DECODE(x_synchronous_flag,
60: fnd_api.g_miss_char, NULL, x_synchronous_flag),
61: DECODE(x_invoke_method_code,
62: fnd_api.g_miss_char, NULL, x_invoke_method_code),

Line 60: fnd_api.g_miss_char, NULL, x_synchronous_flag),

56: fnd_api.g_miss_char, NULL, x_adapter_content_source),
57: DECODE(x_enabled_flag,
58: fnd_api.g_miss_char, NULL, x_enabled_flag),
59: DECODE(x_synchronous_flag,
60: fnd_api.g_miss_char, NULL, x_synchronous_flag),
61: DECODE(x_invoke_method_code,
62: fnd_api.g_miss_char, NULL, x_invoke_method_code),
63: DECODE(x_message_format_code,
64: fnd_api.g_miss_char, NULL, x_message_format_code),

Line 62: fnd_api.g_miss_char, NULL, x_invoke_method_code),

58: fnd_api.g_miss_char, NULL, x_enabled_flag),
59: DECODE(x_synchronous_flag,
60: fnd_api.g_miss_char, NULL, x_synchronous_flag),
61: DECODE(x_invoke_method_code,
62: fnd_api.g_miss_char, NULL, x_invoke_method_code),
63: DECODE(x_message_format_code,
64: fnd_api.g_miss_char, NULL, x_message_format_code),
65: DECODE(x_host_address,
66: fnd_api.g_miss_char, NULL, x_host_address),

Line 64: fnd_api.g_miss_char, NULL, x_message_format_code),

60: fnd_api.g_miss_char, NULL, x_synchronous_flag),
61: DECODE(x_invoke_method_code,
62: fnd_api.g_miss_char, NULL, x_invoke_method_code),
63: DECODE(x_message_format_code,
64: fnd_api.g_miss_char, NULL, x_message_format_code),
65: DECODE(x_host_address,
66: fnd_api.g_miss_char, NULL, x_host_address),
67: DECODE(x_username,
68: fnd_api.g_miss_char, NULL, x_username),

Line 66: fnd_api.g_miss_char, NULL, x_host_address),

62: fnd_api.g_miss_char, NULL, x_invoke_method_code),
63: DECODE(x_message_format_code,
64: fnd_api.g_miss_char, NULL, x_message_format_code),
65: DECODE(x_host_address,
66: fnd_api.g_miss_char, NULL, x_host_address),
67: DECODE(x_username,
68: fnd_api.g_miss_char, NULL, x_username),
69: DECODE(x_encrypted_password,
70: fnd_api.g_miss_char, NULL, x_encrypted_password),

Line 68: fnd_api.g_miss_char, NULL, x_username),

64: fnd_api.g_miss_char, NULL, x_message_format_code),
65: DECODE(x_host_address,
66: fnd_api.g_miss_char, NULL, x_host_address),
67: DECODE(x_username,
68: fnd_api.g_miss_char, NULL, x_username),
69: DECODE(x_encrypted_password,
70: fnd_api.g_miss_char, NULL, x_encrypted_password),
71: DECODE(x_maximum_batch_size,
72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),

Line 70: fnd_api.g_miss_char, NULL, x_encrypted_password),

66: fnd_api.g_miss_char, NULL, x_host_address),
67: DECODE(x_username,
68: fnd_api.g_miss_char, NULL, x_username),
69: DECODE(x_encrypted_password,
70: fnd_api.g_miss_char, NULL, x_encrypted_password),
71: DECODE(x_maximum_batch_size,
72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
73: DECODE(x_default_batch_size,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),

Line 72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),

68: fnd_api.g_miss_char, NULL, x_username),
69: DECODE(x_encrypted_password,
70: fnd_api.g_miss_char, NULL, x_encrypted_password),
71: DECODE(x_maximum_batch_size,
72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
73: DECODE(x_default_batch_size,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),

Line 74: fnd_api.g_miss_num, NULL, x_default_batch_size),

70: fnd_api.g_miss_char, NULL, x_encrypted_password),
71: DECODE(x_maximum_batch_size,
72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
73: DECODE(x_default_batch_size,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,

Line 76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),

72: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
73: DECODE(x_default_batch_size,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,

Line 82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)

78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
83: ) RETURNING
84: adapter_id
85: INTO
86: x_ADAPTER_ID;

Line 99: RAISE fnd_api.g_exc_error;

95: IF l_primary_key_passed THEN
96: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
97: fnd_message.set_token('COLUMN', 'adapter_id');
98: fnd_msg_pub.add;
99: RAISE fnd_api.g_exc_error;
100: END IF;
101:
102: DECLARE
103: l_temp_adapter_id NUMBER;

Line 142: fnd_api.g_miss_num, NULL, x_adapter_id),

138: BEGIN
139:
140: UPDATE hz_adapters
141: SET adapter_id = DECODE(x_adapter_id, NULL, adapter_id,
142: fnd_api.g_miss_num, NULL, x_adapter_id),
143: adapter_content_source = DECODE(x_adapter_content_source,
144: NULL, adapter_content_source,
145: fnd_api.g_miss_char, NULL, x_adapter_content_source),
146: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,

Line 145: fnd_api.g_miss_char, NULL, x_adapter_content_source),

141: SET adapter_id = DECODE(x_adapter_id, NULL, adapter_id,
142: fnd_api.g_miss_num, NULL, x_adapter_id),
143: adapter_content_source = DECODE(x_adapter_content_source,
144: NULL, adapter_content_source,
145: fnd_api.g_miss_char, NULL, x_adapter_content_source),
146: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
147: fnd_api.g_miss_char, NULL, x_enabled_flag),
148: synchronous_flag = DECODE(x_synchronous_flag, NULL, synchronous_flag,
149: fnd_api.g_miss_char, NULL, x_synchronous_flag),

Line 147: fnd_api.g_miss_char, NULL, x_enabled_flag),

143: adapter_content_source = DECODE(x_adapter_content_source,
144: NULL, adapter_content_source,
145: fnd_api.g_miss_char, NULL, x_adapter_content_source),
146: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
147: fnd_api.g_miss_char, NULL, x_enabled_flag),
148: synchronous_flag = DECODE(x_synchronous_flag, NULL, synchronous_flag,
149: fnd_api.g_miss_char, NULL, x_synchronous_flag),
150: invoke_method_code = DECODE(x_invoke_method_code, NULL, invoke_method_code,
151: fnd_api.g_miss_char, NULL, x_invoke_method_code),

Line 149: fnd_api.g_miss_char, NULL, x_synchronous_flag),

145: fnd_api.g_miss_char, NULL, x_adapter_content_source),
146: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
147: fnd_api.g_miss_char, NULL, x_enabled_flag),
148: synchronous_flag = DECODE(x_synchronous_flag, NULL, synchronous_flag,
149: fnd_api.g_miss_char, NULL, x_synchronous_flag),
150: invoke_method_code = DECODE(x_invoke_method_code, NULL, invoke_method_code,
151: fnd_api.g_miss_char, NULL, x_invoke_method_code),
152: message_format_code = DECODE(x_message_format_code, NULL, message_format_code,
153: fnd_api.g_miss_char, NULL, x_message_format_code),

Line 151: fnd_api.g_miss_char, NULL, x_invoke_method_code),

147: fnd_api.g_miss_char, NULL, x_enabled_flag),
148: synchronous_flag = DECODE(x_synchronous_flag, NULL, synchronous_flag,
149: fnd_api.g_miss_char, NULL, x_synchronous_flag),
150: invoke_method_code = DECODE(x_invoke_method_code, NULL, invoke_method_code,
151: fnd_api.g_miss_char, NULL, x_invoke_method_code),
152: message_format_code = DECODE(x_message_format_code, NULL, message_format_code,
153: fnd_api.g_miss_char, NULL, x_message_format_code),
154: host_address = DECODE(x_host_address, NULL, host_address,
155: fnd_api.g_miss_char, NULL, x_host_address),

Line 153: fnd_api.g_miss_char, NULL, x_message_format_code),

149: fnd_api.g_miss_char, NULL, x_synchronous_flag),
150: invoke_method_code = DECODE(x_invoke_method_code, NULL, invoke_method_code,
151: fnd_api.g_miss_char, NULL, x_invoke_method_code),
152: message_format_code = DECODE(x_message_format_code, NULL, message_format_code,
153: fnd_api.g_miss_char, NULL, x_message_format_code),
154: host_address = DECODE(x_host_address, NULL, host_address,
155: fnd_api.g_miss_char, NULL, x_host_address),
156: username = DECODE(x_username, NULL, username,
157: fnd_api.g_miss_char, NULL, x_username),

Line 155: fnd_api.g_miss_char, NULL, x_host_address),

151: fnd_api.g_miss_char, NULL, x_invoke_method_code),
152: message_format_code = DECODE(x_message_format_code, NULL, message_format_code,
153: fnd_api.g_miss_char, NULL, x_message_format_code),
154: host_address = DECODE(x_host_address, NULL, host_address,
155: fnd_api.g_miss_char, NULL, x_host_address),
156: username = DECODE(x_username, NULL, username,
157: fnd_api.g_miss_char, NULL, x_username),
158: encrypted_password = DECODE(x_encrypted_password, NULL, encrypted_password,
159: fnd_api.g_miss_char, NULL, x_encrypted_password),

Line 157: fnd_api.g_miss_char, NULL, x_username),

153: fnd_api.g_miss_char, NULL, x_message_format_code),
154: host_address = DECODE(x_host_address, NULL, host_address,
155: fnd_api.g_miss_char, NULL, x_host_address),
156: username = DECODE(x_username, NULL, username,
157: fnd_api.g_miss_char, NULL, x_username),
158: encrypted_password = DECODE(x_encrypted_password, NULL, encrypted_password,
159: fnd_api.g_miss_char, NULL, x_encrypted_password),
160: maximum_batch_size = DECODE(x_maximum_batch_size, NULL, maximum_batch_size,
161: fnd_api.g_miss_num, NULL, x_maximum_batch_size),

Line 159: fnd_api.g_miss_char, NULL, x_encrypted_password),

155: fnd_api.g_miss_char, NULL, x_host_address),
156: username = DECODE(x_username, NULL, username,
157: fnd_api.g_miss_char, NULL, x_username),
158: encrypted_password = DECODE(x_encrypted_password, NULL, encrypted_password,
159: fnd_api.g_miss_char, NULL, x_encrypted_password),
160: maximum_batch_size = DECODE(x_maximum_batch_size, NULL, maximum_batch_size,
161: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
162: default_batch_size = DECODE(x_default_batch_size, NULL, default_batch_size,
163: fnd_api.g_miss_num, NULL, x_default_batch_size),

Line 161: fnd_api.g_miss_num, NULL, x_maximum_batch_size),

157: fnd_api.g_miss_char, NULL, x_username),
158: encrypted_password = DECODE(x_encrypted_password, NULL, encrypted_password,
159: fnd_api.g_miss_char, NULL, x_encrypted_password),
160: maximum_batch_size = DECODE(x_maximum_batch_size, NULL, maximum_batch_size,
161: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
162: default_batch_size = DECODE(x_default_batch_size, NULL, default_batch_size,
163: fnd_api.g_miss_num, NULL, x_default_batch_size),
164: default_replace_status_level = DECODE(x_default_replace_status_level,
165: NULL, default_replace_status_level,

Line 163: fnd_api.g_miss_num, NULL, x_default_batch_size),

159: fnd_api.g_miss_char, NULL, x_encrypted_password),
160: maximum_batch_size = DECODE(x_maximum_batch_size, NULL, maximum_batch_size,
161: fnd_api.g_miss_num, NULL, x_maximum_batch_size),
162: default_batch_size = DECODE(x_default_batch_size, NULL, default_batch_size,
163: fnd_api.g_miss_num, NULL, x_default_batch_size),
164: default_replace_status_level = DECODE(x_default_replace_status_level,
165: NULL, default_replace_status_level,
166: fnd_api.g_miss_char,
167: NULL, x_default_replace_status_level),

Line 166: fnd_api.g_miss_char,

162: default_batch_size = DECODE(x_default_batch_size, NULL, default_batch_size,
163: fnd_api.g_miss_num, NULL, x_default_batch_size),
164: default_replace_status_level = DECODE(x_default_replace_status_level,
165: NULL, default_replace_status_level,
166: fnd_api.g_miss_char,
167: NULL, x_default_replace_status_level),
168: last_update_date = hz_utility_v2pub.last_update_date,
169: last_updated_by = hz_utility_v2pub.last_updated_by,
170: creation_date = creation_date,

Line 175: fnd_api.g_miss_num, NULL,

171: created_by = created_by,
172: last_update_login = hz_utility_v2pub.last_update_login,
173: object_version_number = DECODE(x_object_version_number,
174: NULL, object_version_number,
175: fnd_api.g_miss_num, NULL,
176: x_object_version_number)
177:
178: WHERE rowid = x_rowid;
179: