APPS.HZ_CODE_ASSIGNMENTS_PKG dependencies on HZ_CODE_ASSIGNMENTS_S

Line 65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),

61: APPLICATION_ID,
62: ACTUAL_CONTENT_SOURCE
63: )
64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

Line 110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL

106: l_dummy VARCHAR2(1);
107: BEGIN
108: l_count := 1;
109: WHILE l_count > 0 LOOP
110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL
111: INTO X_CODE_ASSIGNMENT_ID FROM dual;
112: BEGIN
113: SELECT 'Y' INTO l_dummy
114: FROM HZ_CODE_ASSIGNMENTS

Line 158: UPDATE HZ_CODE_ASSIGNMENTS SET

154: ) IS
155:
156: BEGIN
157:
158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),