APPS.HZ_PARTIES_PKG dependencies on HZ_PARTIES_S

Line 239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),

235: CREATED_BY_MODULE,
236: APPLICATION_ID
237: )
238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),

Line 278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 359: SELECT HZ_PARTIES_S.NEXTVAL

355: l_dummy VARCHAR2(1);
356: BEGIN
357: l_count := 1;
358: WHILE l_count > 0 LOOP
359: SELECT HZ_PARTIES_S.NEXTVAL
360: INTO X_PARTY_ID FROM dual;
361: BEGIN
362: SELECT 'Y' INTO l_dummy
363: FROM HZ_PARTIES

Line 507: UPDATE HZ_PARTIES SET

503: THEN
504: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
505: END IF;
506:
507: UPDATE HZ_PARTIES SET
508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),