APPS.HZ_DSS_ASSIGNMENTS_PKG dependencies on HZ_DSS_ASSIGNMENTS_S

Line 43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,

39: object_version_number
40: )
41: VALUES (
42: DECODE(x_assignment_id,
43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
44: NULL, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
45: x_assignment_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',

Line 44: NULL, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,

40: )
41: VALUES (
42: DECODE(x_assignment_id,
43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
44: NULL, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
45: x_assignment_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',
48: NULL, 'A',

Line 97: SELECT HZ_DSS_ASSIGNMENTS_S.NEXTVAL

93: l_dummy VARCHAR2(1);
94: BEGIN
95: l_count := 1;
96: WHILE l_count > 0 LOOP
97: SELECT HZ_DSS_ASSIGNMENTS_S.NEXTVAL
98: INTO x_assignment_id FROM dual;
99: BEGIN
100: SELECT 'Y' INTO l_dummy
101: FROM HZ_DSS_ASSIGNMENTS