APPS.HZ_ADDRESS_USAGES_PKG dependencies on HZ_ADDRESS_USAGES_S

Line 37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,

33: application_id
34: )
35: VALUES (
36: DECODE(x_usage_id,
37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,

Line 38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,

34: )
35: VALUES (
36: DECODE(x_usage_id,
37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,
42: x_map_id),

Line 81: SELECT HZ_ADDRESS_USAGES_S.NEXTVAL

77: l_dummy VARCHAR2(1);
78: BEGIN
79: l_count := 1;
80: WHILE l_count > 0 LOOP
81: SELECT HZ_ADDRESS_USAGES_S.NEXTVAL
82: INTO x_usage_id FROM dual;
83: BEGIN
84: SELECT 'Y' INTO l_dummy
85: FROM HZ_ADDRESS_USAGES