APPS.HZ_PARTY_SITES_PKG dependencies on HZ_PARTY_SITES_S

Line 102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),

98: GLOBAL_LOCATION_NUMBER,
99: DUNS_NUMBER_C
100: )
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),

Line 170: SELECT HZ_PARTY_SITES_S.NEXTVAL

166: l_dummy VARCHAR2(1);
167: BEGIN
168: l_count := 1;
169: WHILE l_count > 0 LOOP
170: SELECT HZ_PARTY_SITES_S.NEXTVAL
171: INTO X_PARTY_SITE_ID FROM dual;
172: BEGIN
173: SELECT 'Y' INTO l_dummy
174: FROM HZ_PARTY_SITES

Line 280: UPDATE HZ_PARTY_SITES SET

276: ) IS
277:
278: BEGIN
279:
280: UPDATE HZ_PARTY_SITES SET
281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,