APPS.AHL_LTP_MATERIALS_GRP dependencies on AHL_SCHEDULE_MATERIALS

Line 70: FROM ahl_workorders awo, ahl_schedule_materials asmt

66: -- for which requested date is not equal to WO scheduled start date
67: CURSOR get_scheduled_material_id (c_wip_entity_id IN NUMBER,
68: c_requested_date IN DATE) IS
69: SELECT asmt.scheduled_material_id
70: FROM ahl_workorders awo, ahl_schedule_materials asmt
71: WHERE awo.visit_task_id = asmt.visit_task_id
72: AND awo.wip_entity_id= c_wip_entity_id
73: AND asmt.requested_date <> trunc(c_requested_date)
74: AND asmt.status <> 'DELETED';

Line 141: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different

137: );
138: END IF;
139:
140: -- This API updates all the reservation dates, if l_requested_date
141: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
142: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
143: p_api_version => 1.0,
144: p_init_msg_list => FND_API.G_FALSE,
145: p_commit => FND_API.G_FALSE,

Line 167: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date

163: ELSE
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
168: UPDATE AHL_SCHEDULE_MATERIALS
169: SET requested_date = trunc(l_requested_date),
170: last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,

Line 168: UPDATE AHL_SCHEDULE_MATERIALS

164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
168: UPDATE AHL_SCHEDULE_MATERIALS
169: SET requested_date = trunc(l_requested_date),
170: last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id