APPS.HZ_PARTY_SITE_USES_PKG dependencies on HZ_PARTY_SITE_USES_S

Line 43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),

39: CREATED_BY_MODULE,
40: APPLICATION_ID
41: )
42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 79: SELECT HZ_PARTY_SITE_USES_S.NEXTVAL

75: l_dummy VARCHAR2(1);
76: BEGIN
77: l_count := 1;
78: WHILE l_count > 0 LOOP
79: SELECT HZ_PARTY_SITE_USES_S.NEXTVAL
80: INTO X_PARTY_SITE_USE_ID FROM dual;
81: BEGIN
82: SELECT 'Y' INTO l_dummy
83: FROM HZ_PARTY_SITE_USES

Line 116: UPDATE HZ_PARTY_SITE_USES SET

112: ) IS
113:
114: BEGIN
115:
116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,