DBA Data[Home] [Help]

APPS.HZ_ADAPTERS_PKG dependencies on HZ_ADAPTERS_S

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 54: NULL, hz_adapters_s.NEXTVAL, x_adapter_id),

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,
58: fnd_api.g_miss_char, NULL, x_enabled_flag),

Line 110: SELECT HZ_ADAPTERS_S.NEXTVAL

106: l_temp_adapter_id := 0;
107: SELECT max(ADAPTER_ID) INTO l_max_adapter_id
108: FROM HZ_ADAPTERS;
109: WHILE l_temp_adapter_id <= l_max_adapter_id LOOP
110: SELECT HZ_ADAPTERS_S.NEXTVAL
111: INTO l_temp_adapter_id FROM dual;
112: END LOOP;
113: END;
114: ELSE