APPS.HZ_ADDRESS_USAGE_DTLS_PKG dependencies on HZ_ADDRESS_USAGE_DTLS_S

Line 35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,

31: application_id
32: )
33: VALUES (
34: DECODE(x_usage_dtl_id,
35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,

Line 36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,

32: )
33: VALUES (
34: DECODE(x_usage_dtl_id,
35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_usage_id),

Line 76: SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL

72: l_dummy VARCHAR2(1);
73: BEGIN
74: l_count := 1;
75: WHILE l_count > 0 LOOP
76: SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL
77: INTO x_usage_dtl_id FROM dual;
78: BEGIN
79: SELECT 'Y' INTO l_dummy
80: FROM HZ_ADDRESS_USAGE_DTLS