APPS.HZ_CUST_ACCOUNT_ROLES_PKG dependencies on HZ_CUST_ACCOUNT_ROLES_S

Line 106: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL, NULL, HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL, X_CUST_ACCOUNT_ROLE_ID ),

102: APPLICATION_ID,
103: CURRENT_ROLE_STATE
104: )
105: VALUES (
106: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL, NULL, HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL, X_CUST_ACCOUNT_ROLE_ID ),
107: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
108: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
109: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
110: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),

Line 147: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCOUNT_ROLE_ID,HZ_CUST_ACCOUNT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCOUNT_ROLE_ID,HZ_CUST_ACCOUNT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

143: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
144: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
145: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
146: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
147: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCOUNT_ROLE_ID,HZ_CUST_ACCOUNT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCOUNT_ROLE_ID,HZ_CUST_ACCOUNT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
148: DECODE( X_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE25 ),
149: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
150: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
151: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 173: SELECT HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL

169: l_dummy VARCHAR2(1);
170: BEGIN
171: l_count := 1;
172: WHILE l_count > 0 LOOP
173: SELECT HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL
174: INTO X_CUST_ACCOUNT_ROLE_ID FROM dual;
175: BEGIN
176: SELECT 'Y' INTO l_dummy
177: FROM HZ_CUST_ACCOUNT_ROLES

Line 239: UPDATE HZ_CUST_ACCOUNT_ROLES SET

235: ) IS
236:
237: BEGIN
238:
239: UPDATE HZ_CUST_ACCOUNT_ROLES SET
240: CUST_ACCOUNT_ROLE_ID = DECODE( X_CUST_ACCOUNT_ROLE_ID, NULL, CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
241: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
242: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
243: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),