APPS.HZ_ORG_CONTACTS_PKG dependencies on HZ_ORG_CONTACTS_S

Line 109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),

105: APPLICATION_ID,
106: STATUS
107: )
108: VALUES (
109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),

Line 129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 178: SELECT HZ_ORG_CONTACTS_S.NEXTVAL

174: l_dummy VARCHAR2(1);
175: BEGIN
176: l_count := 1;
177: WHILE l_count > 0 LOOP
178: SELECT HZ_ORG_CONTACTS_S.NEXTVAL
179: INTO X_ORG_CONTACT_ID FROM dual;
180: BEGIN
181: SELECT 'Y' INTO l_dummy
182: FROM HZ_ORG_CONTACTS

Line 249: UPDATE HZ_ORG_CONTACTS SET

245: ) IS
246:
247: BEGIN
248:
249: UPDATE HZ_ORG_CONTACTS SET
250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),