APPS.EAM_CONSTRUCTION_UNIT_PKG dependencies on EAM_CONSTRUCTION_UNITS

Line 35: SELECT EAM_CONSTRUCTION_UNITS_S.nextval

31: ,p_last_update_login IN NUMBER
32: ) IS
33:
34: CURSOR C1 IS
35: SELECT EAM_CONSTRUCTION_UNITS_S.nextval
36: FROM dual;
37: BEGIN
38: IF (px_cu_id IS NULL) OR (px_cu_id = FND_API.G_MISS_NUM) then
39: OPEN C1;

Line 44: INSERT INTO EAM_CONSTRUCTION_UNITS(

40: FETCH C1 INTO px_cu_id;
41: CLOSE C1;
42: END IF;
43:
44: INSERT INTO EAM_CONSTRUCTION_UNITS(
45: CU_ID,
46: CU_NAME,
47: DESCRIPTION,
48: ORGANIZATION_ID,

Line 136: UPDATE EAM_CONSTRUCTION_UNITS

132: ) IS
133:
134: BEGIN
135:
136: UPDATE EAM_CONSTRUCTION_UNITS
137: SET
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),