APPS.HZ_CUST_SITE_USES_PKG dependencies on HZ_CUST_SITE_USES_S

Line 234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),

230: APPLICATION_ID,
231: ORG_ID
232: )
233: VALUES (
234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),

239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
242: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
245: DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
246: DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
245: DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
246: DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
248: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
249: DECODE( X_PAYMENT_TERM_ID, FND_API.G_MISS_NUM, NULL, X_PAYMENT_TERM_ID ),
250: DECODE( X_GSA_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_GSA_INDICATOR ),
251: -- DECODE( X_SHIP_PARTIAL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SHIP_PARTIAL ),

Line 367: SELECT HZ_CUST_SITE_USES_S.NEXTVAL

363: l_dummy VARCHAR2(1);
364: BEGIN
365: l_count := 1;
366: WHILE l_count > 0 LOOP
367: SELECT HZ_CUST_SITE_USES_S.NEXTVAL
368: INTO X_SITE_USE_ID FROM dual;
369: BEGIN
370: SELECT 'Y' INTO l_dummy
371: FROM HZ_CUST_SITE_USES_ALL