APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITIONS_B_S

Line 539: SELECT ahl_prd_dispositions_b_s.NEXTVAL

535: --dbms_output.put_line('Before calling table handler API');
536: --Insert the record into the disposition entity table
537: IF (l_route_mtl_req_tbl.EXISTS(i)) THEN
538: BEGIN
539: SELECT ahl_prd_dispositions_b_s.NEXTVAL
540: INTO l_disposition_id
541: FROM dual;
542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;

1102:
1103: p_x_disposition_Rec.status_code := l_calculated_status;
1104:
1105: --prepare for insert
1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1107: --setting object version number for create
1108: p_x_disposition_rec.object_version_number := 1;
1109: --setting up user/create/update information
1110: p_x_disposition_rec.created_by := fnd_global.user_id;

Line 1215: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,

1211: p_x_disposition_rec.primary_service_request_id := l_primary_service_request_id;
1212: p_x_disposition_rec.non_routine_workorder_id := l_non_routine_workorder_id;
1213:
1214: --update the just modified field without changing object version number.
1215: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,
1216: non_routine_workorder_id = p_x_disposition_rec.non_routine_workorder_id,
1217: status_code = p_x_disposition_rec.status_code
1218: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1219: END IF;