APPS.HZ_ADAPTER_TERRITORIES_PKG dependencies on FND_API

Line 26: DECODE(x_adapter_id, fnd_api.g_miss_num, NULL, x_adapter_id),

22: last_update_date,
23: last_updated_by,
24: object_version_number
25: ) VALUES (
26: DECODE(x_adapter_id, fnd_api.g_miss_num, NULL, x_adapter_id),
27: DECODE(x_territory_code, fnd_api.g_miss_char, NULL, x_territory_code),
28: DECODE(x_enabled_flag, fnd_api.g_miss_char, NULL, x_enabled_flag),
29: DECODE(x_default_flag, fnd_api.g_miss_char, NULL, x_default_flag),
30: hz_utility_v2pub.created_by,

Line 27: DECODE(x_territory_code, fnd_api.g_miss_char, NULL, x_territory_code),

23: last_updated_by,
24: object_version_number
25: ) VALUES (
26: DECODE(x_adapter_id, fnd_api.g_miss_num, NULL, x_adapter_id),
27: DECODE(x_territory_code, fnd_api.g_miss_char, NULL, x_territory_code),
28: DECODE(x_enabled_flag, fnd_api.g_miss_char, NULL, x_enabled_flag),
29: DECODE(x_default_flag, fnd_api.g_miss_char, NULL, x_default_flag),
30: hz_utility_v2pub.created_by,
31: hz_utility_v2pub.creation_date,

Line 28: DECODE(x_enabled_flag, fnd_api.g_miss_char, NULL, x_enabled_flag),

24: object_version_number
25: ) VALUES (
26: DECODE(x_adapter_id, fnd_api.g_miss_num, NULL, x_adapter_id),
27: DECODE(x_territory_code, fnd_api.g_miss_char, NULL, x_territory_code),
28: DECODE(x_enabled_flag, fnd_api.g_miss_char, NULL, x_enabled_flag),
29: DECODE(x_default_flag, fnd_api.g_miss_char, NULL, x_default_flag),
30: hz_utility_v2pub.created_by,
31: hz_utility_v2pub.creation_date,
32: hz_utility_v2pub.last_update_login,

Line 29: DECODE(x_default_flag, fnd_api.g_miss_char, NULL, x_default_flag),

25: ) VALUES (
26: DECODE(x_adapter_id, fnd_api.g_miss_num, NULL, x_adapter_id),
27: DECODE(x_territory_code, fnd_api.g_miss_char, NULL, x_territory_code),
28: DECODE(x_enabled_flag, fnd_api.g_miss_char, NULL, x_enabled_flag),
29: DECODE(x_default_flag, fnd_api.g_miss_char, NULL, x_default_flag),
30: hz_utility_v2pub.created_by,
31: hz_utility_v2pub.creation_date,
32: hz_utility_v2pub.last_update_login,
33: hz_utility_v2pub.last_update_date,

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

31: hz_utility_v2pub.creation_date,
32: hz_utility_v2pub.last_update_login,
33: hz_utility_v2pub.last_update_date,
34: hz_utility_v2pub.last_updated_by,
35: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
36: );
37:
38: End Insert_Row;
39:

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

48:
49: BEGIN
50: UPDATE HZ_ADAPTER_TERRITORIES
51: SET adapter_id = DECODE(x_adapter_id, NULL, adapter_id,
52: fnd_api.g_miss_num, NULL, x_adapter_id),
53: territory_code = DECODE(x_territory_code, NULL, territory_code,
54: fnd_api.g_miss_char, NULL, x_territory_code),
55: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
56: fnd_api.g_miss_char, NULL, x_enabled_flag),

Line 54: fnd_api.g_miss_char, NULL, x_territory_code),

50: UPDATE HZ_ADAPTER_TERRITORIES
51: SET adapter_id = DECODE(x_adapter_id, NULL, adapter_id,
52: fnd_api.g_miss_num, NULL, x_adapter_id),
53: territory_code = DECODE(x_territory_code, NULL, territory_code,
54: fnd_api.g_miss_char, NULL, x_territory_code),
55: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
56: fnd_api.g_miss_char, NULL, x_enabled_flag),
57: default_flag = DECODE(x_default_flag, NULL, default_flag,
58: fnd_api.g_miss_char, NULL, x_default_flag),

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

52: fnd_api.g_miss_num, NULL, x_adapter_id),
53: territory_code = DECODE(x_territory_code, NULL, territory_code,
54: fnd_api.g_miss_char, NULL, x_territory_code),
55: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
56: fnd_api.g_miss_char, NULL, x_enabled_flag),
57: default_flag = DECODE(x_default_flag, NULL, default_flag,
58: fnd_api.g_miss_char, NULL, x_default_flag),
59: last_update_date = hz_utility_v2pub.last_update_date,
60: last_updated_by = hz_utility_v2pub.last_updated_by,

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

54: fnd_api.g_miss_char, NULL, x_territory_code),
55: enabled_flag = DECODE(x_enabled_flag, NULL, enabled_flag,
56: fnd_api.g_miss_char, NULL, x_enabled_flag),
57: default_flag = DECODE(x_default_flag, NULL, default_flag,
58: fnd_api.g_miss_char, NULL, x_default_flag),
59: last_update_date = hz_utility_v2pub.last_update_date,
60: last_updated_by = hz_utility_v2pub.last_updated_by,
61: creation_date = creation_date,
62: created_by = created_by,

Line 66: fnd_api.g_miss_num, NULL,

62: created_by = created_by,
63: last_update_login = hz_utility_v2pub.last_update_login,
64: object_version_number = DECODE(x_object_version_number,
65: NULL, object_version_number,
66: fnd_api.g_miss_num, NULL,
67: x_object_version_number)
68: WHERE ROWID = x_ROWID;
69:
70: If (SQL%NOTFOUND) then