APPS.HZ_ROLE_RESPONSIBILITY_PKG dependencies on HZ_ROLE_RESPONSIBILITY_S

Line 77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),

73: CREATED_BY_MODULE,
74: APPLICATION_ID
75: )
76: VALUES (
77: DECODE( X_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, NULL, HZ_ROLE_RESPONSIBILITY_S.NEXTVAL, X_RESPONSIBILITY_ID ),
78: DECODE( X_CUST_ACCOUNT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ROLE_ID ),
79: DECODE( X_RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
80: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
81: HZ_UTILITY_V2PUB.CREATED_BY,

Line 106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

102: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
103: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
104: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
105: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
106: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), NULL, TO_CHAR(NVL(X_RESPONSIBILITY_ID,HZ_ROLE_RESPONSIBILITY_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
107: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
108: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
109: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
110: ) RETURNING

Line 128: SELECT HZ_ROLE_RESPONSIBILITY_S.NEXTVAL

124: l_dummy VARCHAR2(1);
125: BEGIN
126: l_count := 1;
127: WHILE l_count > 0 LOOP
128: SELECT HZ_ROLE_RESPONSIBILITY_S.NEXTVAL
129: INTO X_RESPONSIBILITY_ID FROM dual;
130: BEGIN
131: SELECT 'Y' INTO l_dummy
132: FROM HZ_ROLE_RESPONSIBILITY

Line 180: UPDATE HZ_ROLE_RESPONSIBILITY SET

176: ) IS
177:
178: BEGIN
179:
180: UPDATE HZ_ROLE_RESPONSIBILITY SET
181: RESPONSIBILITY_ID = DECODE( X_RESPONSIBILITY_ID, NULL, RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, X_RESPONSIBILITY_ID ),
182: 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 ),
183: RESPONSIBILITY_TYPE = DECODE( X_RESPONSIBILITY_TYPE, NULL, RESPONSIBILITY_TYPE, FND_API.G_MISS_CHAR, NULL, X_RESPONSIBILITY_TYPE ),
184: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),